Although the primary motivation of this blog is to find out the database table where data is persistent against which we see in the UI. However I would also like to address some of the key aspects of our daily needs in the development environment too. Therefore it will take you through step by step approach.
Starting from UI (Floorplan Manager Applications) -> Floorplan manager BOPF Integration (FBI) -> BOPF (Business Object Processing framework).
Use Case: How to find out the DB table in which Capacity Selection profile (CAPA) settings are stored?
To see the capacity selection profile, go to GUI easy access / NWBC -> Application Administration ->Planning -> Planning Profile Settings -> Capacity Selection Settings
1. What is the application/component configuration of a web application that you are working with?
Answer to this question would also help you to find and choose which component configuration to be enhanced/customized whenever you have been asked to add new ‘Z’ Fields to particular section(Technically called as GUIBB) of application layout.
Launch the application and navigate to page/area/tab for which you are interested in the application.
Keep cursor and Right click -> Select Technical help -> Popup is displayed with Technical details.
Here you should consider and look at Component configuration of Current View.
Please note Component customizing will be displayed if there had been customization done before.
Click on Component Configuration link -> Component Configuration is displayed -> Here either we can enhance the component configuration by choosing Enhance from ‘Additional Functions’ button choice or choose CUSTOMIZE_COMPONENT in the URL to apply administrator personalization and to incorporate new ‘Z’ fields.
2. What is the BO object & corresponding BO node that you are working with?
Answer to this question will also help you whenever you have been asked to enhance the application layout to add new ‘Z’ fields and that field value should be saved in the database, then you should know which BO Object and node should be considered. You can achieve the same using append structure with new ‘Z’ fields to Extension Include structure (Extension include is visible to nodes for which setting ‘Node can be enhanced’ is true) of that particular node and then you can write required logic by creating a determination on the same node.
Click on ‘Feeder Class Parameters’ button in the General Settings-> Popup is displayed -> Take FBI View name from here.
Go to SE84 transaction -> Search for Component Configuration with FBI View Name -> Launch the Dsiplay configuration from SE84 -> Below screen will be displayed.
3. What is the DB table in which data is stored?
Take the Business Object name from above screenshot and go to transaction BOBF or /BOBF/CONF_UI.
4. How to cross-check am I correct?
Go to Transaction – BOBT or /BOBF/TEST_UI to check and cross-verify the data what you see in the application is same as what you see here.
We can check the data entries in table from transaction SE16 as well.
Appreciate your feedback and comments.