Skip to Content

Data Warehouse InfoObjects can be defined as the data elements to populate the Data Warehouse layer of your Enterprise Data Warehouse. Please refer for a conceptual overview to my blog Introducing Data Warehouse InfoObjects – Part 1: Conceptual Overview. For SAP source systems it is advisable to take advantage of the structured and comprehensive ABAP Data Dictionary to generate these Data Warehouse InfoObjects. Please refer for more technical details to my blog Introducing Data Warehouse InfoObjects – Part 2: Technical Details.

I created an ABAP program to generate Data Warehouse InfoObjects for SAP source systems’ DataSources. For more information on using the program please refer to the blog series:

I would like to share via 3 documents detailed technical instructions how to create the ABAP program and all related objects. Part 1 explains how to create all ABAP Dictionary objects. Implementing Data Warehouse InfoObjects – Part 2: ABAP Programming & Other Objects focuses on ABAP programming and other ABAP Workbench objects. Implementing Data Warehouse InfoObjects – Part 3: ABAP Developments in SAP Source System describes all ABAP developments to be done in every SAP source system that is subject to Generating Data Warehouse InfoObjects.

Step 1: Create Domains

SAP Menu: Tools > ABAP Workbench > Development > ABAP Dictionary

T/code: SE11

Create Domains YBWPATTERN and YBWPATTERNTYPE as shown in the screenshots.

Fig_01_Domain_Pattern_String.jpg

Figure 1: Domain for Pattern String

Fig_02_Domain_Pattern_Type_1.jpg

Figure 2: Domain for Pattern Type (1)

Fig_03_Domain_Pattern_Type_2.jpg

Figure 3: Domain for Pattern Type (2)

Step 2: Create Data Elements

SAP Menu: Tools > ABAP Workbench > Development > ABAP Dictionary

T/code: SE11

Create Data Elements YBWPATTERN and YBWPATTERNTYPE as shown in the screenshots.

Fig_04_Data_Element_Pattern_String.jpg

Figure 4: Data Element for Pattern String

Fig_05_Data_Element_Pattern_Type.jpg

Figure 5: Data Element for Pattern Type

Step 3: Create Search Helps

SAP Menu: Tools > ABAP Workbench > Development > ABAP Dictionary

T/code: SE11

Create Search Helps YBW_DSFIELD and YBW_IOBJFNM as shown in the screenshots.

Fig_06_Search_Help_DataSource_Fields.jpg

Figure 6: Search Help  for DataSource Fields

Fig_07_Search_Help_InfoObject_Field_Name.jpg

Figure 7: Search Help  for InfoObject and Field Name

Step 4: Create Tables

SAP Menu: Tools > ABAP Workbench > Development > ABAP Dictionary

T/code: SE11

Create Tables YBWADMIN, YBWIOBJBAS, YBWIOBJREF, YBWIOBJUNI, YBWIOBJKYF, YBWIOBJTIM, YBWIOBJEXP and YBWMAPPING as shown in the screenshots.

Note: The following Delivery and Maintenance properties apply for all tables.

Fig_08_Delivery_Maintenance_Properties.jpg

Figure 8: Delivery and Maintenance Properties

Fig_09_Table_Administration_Settings.jpg

Figure 9: Control Table – Administration Settings

Fig_10_Table_Basic_Characteristics.jpg

Figure 10: Metadata Repository Table – Basic Characteristics

Fig_11_Table_Characteristics_with_Reference.jpg

Figure 11: Metadata Repository Table – Characteristics with Reference

Fig_12_Table_Units.jpg

Figure 12: Metadata Repository Table – Units

Fig_13_Table_Key_Figures.jpg

Figure 13: Metadata Repository Table – Key Figures

Fig_14_Table_Time_Characteristics_1.jpg

Figure 14: Customizing Table – Time Characteristics (1)

Fig_15_Table_Time_Characteristics_2.jpg

Figure 15: Customizing Table – Time Characteristics (2)

Fig_16_Table_Time_Characteristics_3.jpg

Figure 16: Customizing Table – Time Characteristics (3)

Fig_17_Table_Exclude_Patterns.jpg

Figure 17: Customizing Table – Exclude Patterns

Fig_18_Table_Mapping_1.jpg

Figure 18: Metadata Repository Table – Mapping (1)

Fig_19_Table_Mapping_2.jpg

Figure 19: Metadata Repository Table – Mapping (2)

Fig_20_Table_Mapping_3.jpg

Figure 20: Metadata Repository Table – Mapping (3)

Fig_21_Table_Mapping_4.jpg

Figure 21: Metadata Repository Table – Mapping (4)

Fig_22_Table_Mapping_5.jpg

Figure 22: Metadata Repository Table – Mapping (5)

Step 5: Create Lock Objects

SAP Menu: Tools > ABAP Workbench > Development > ABAP Dictionary

T/code: SE11

Create Lock Objects EYBWIOBJBAS, EYBWIOBJREF, EYBWIOBJUNI, EYBWIOBJKYF, and EYBWMAPPING as shown in the screenshots.

Fig_23_Lock_Object_Basic_Characteristics_1.jpg

Figure 23: Lock Object – Basic Characteristics (1)

Fig_24_Lock_Object_Basic_Characteristics_2.jpg

Figure 24: Lock Object – Basic Characteristics (2)

Fig_25_Lock_Object_Characteristics_with_Reference_1.jpg

Figure 25: Lock Object – Characteristics with Reference (1)

Fig_26_Lock_Object_Characteristics_with_Reference_2.jpg

Figure 26: Lock Object – Characteristics with Reference (2)

Fig_27_Lock_Object_Units_1.jpg

Figure 27: Lock Object – Units (1)

Fig_28_Lock_Object_Units_2.jpg

Figure 28: Lock Object – Units (2)

Fig_29_Lock_Object_Key_Figures_1.jpg

Figure 29: Lock Object – Key Figures (1)

Fig_30_Lock_Object_Key_Figures_2.jpg

Figure 30: Lock Object – Key Figures (2)

Fig_31_Lock_Object_Mapping_1.jpg

Figure 31: Lock Object – Mapping Rules (1)

Fig_32_Lock_Object_Mapping_2.jpg

Figure 32: Lock Object – Mapping Rules (2)

To report this post you need to login first.

3 Comments

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

  1. Sander van Willigen Post author

    Changes in version 3:

    • Figure 13 (Metadata Repository Table – Key Figures) was obsolete and is renewed;
    • Figure 14 (Customizing Table – Time Characteristics (1)) was obsolete and is renewed;
    • Figure 15 (Customizing Table – Time Characteristics (2)) was obsolete and is renewed.
    (0) 
    1. Rekha Singh

      Dear Sander,

      I would like a logic in creating transformations.

      Scenario:

      1. I’m in a situation of re-creating existing BW objects(InfoObjects,DSO,Infocubes,Multi provider , queries ) with a different name completely in a new BW system.

      2. Source will remain same. However, I have created all the above mentioned BW objects – Infoobjects,DSO, Infocubes and multi provider through ABAP. Now, I am stuck where, I’ve to create transformations to these newly cerated objects through ABAP code.

      Please guide me with the logic, table names to use, BAPIs or function modules to use in creating BW transformations, will be great.

      Pls. mail me at rekha.siingh@gmail.com

      Regards,

      Rekha

      (0) 
      1. Sander van Willigen Post author

        Hi Rekha,

        Unfortunately I don’t have any suggestion at the moment. I am using BAPIs for creating InfoObjects and template InfoProviders. There are no BAPIs for creating Transformations.

        Please be careful with creating Transformations using ABAP. There is so much functionality behind Transformations. I am convinced that it will be a hard job or even a mission impossible. Good luck and please share your findings.

        Best regards,

        Sander

        (0) 

Leave a Reply