Skip to Content

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.

Technical Help.png

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.

Feeder class Parameters.PNG

Go to SE84 transaction -> Search for Component Configuration with FBI View Name -> Launch the Dsiplay configuration from SE84 -> Below screen will be displayed.

FBI Configuration.PNG

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.

DB Table from BOPF.PNG

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.

Test UI.PNG

Appreciate your feedback and comments.

Thanks,

Bharath.K

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Melinda Miskolczi

    Dear Bharath,

    I’d like to share an additional information. There’s another way to open the Component Configuration.

    On transaction SU01 the following Parameter need to be maintained for the user ID:

    Parameter ID: FPM_CONFIG_EXPERT

    Parameter value: X

    /wp-content/uploads/2015/10/su01_804693.jpg

    If this parameter is maintained for the user, on NWBC UI a new button can be seen on the upper right corner: ‘Show Configurable Area’.

    2015-10-07- 11-11-18.jpg

    After clicking on this button and select an area you can open the Component Configuration.

    Best regards,

    Melinda

    (0) 
  2. ashok vadapally

    Thank you very much. Very useful article.

    I am able to find some of the fields in Freight Unit using this. I am still unable to find Dangerous Goods data of FU items – database table, association info in BOBT. Can you please shed some light ? What am I missing ?

    Thank you

    (0) 
    1. Melinda Miskolczi

      In case of FU the Dangerous Goods information can be found on BO /SCMTMS/TOR on node ITEMTRDANGGOODSINFO

      DG.jpg

      Please note that the Dangerous Goods maintainance (which is very dynamical) in TM is an exception and it works not as usual in the BOBF model. This means that the information in the UI sometimes is not in sync with the information on /BOBF/TEST_UI.

      Therefore the node of dangerous goods information is not supported in BOBF.

      (0) 
      1. ashok vadapally

        Thank you very much Melinda. In the BOBF node ITEMTRDANGGOODSINFO, I see database table as /SCMTMS/D_TRQDGI but I couldn’t see DG data for a given FU.

        Also tried to view the data in /BOBF/TEST_UI but in vain. For my FU, I checked ITEMDANGGOODSINFO under ITEM_TR, ITEM_TR_MAIN,*FU_ITEM, *TRQ_ITEM, *CARGO_MAIN etc in both /SCMTMS/TOR and /SCMTMS/TRQ but couldn’t find the DG data info. What am I missing ? Am still in learning phase. Sorry if this is a silly question. Searched online but didn’t find the info I am looking for.

        (0) 
        1. Melinda Miskolczi

          As I have mentioned the DG maintainance is an exception is TM and it doesn’t work as usual in the BOBF model therefore the node DG information is not supported in BOBF.

          (0) 

Leave a Reply