Implementing Data Warehouse InfoObjects

Implementing Data Warehouse InfoObjects: 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:

• Generating Data Warehouse InfoObjects – Part 1: Introduction;
• Generating Data Warehouse InfoObjects – Part 2: Metadata Repository;
• Generating Data Warehouse InfoObjects – Part 3: Customizing;
• Generating Data Warehouse InfoObjects – Part 4: Optimizing Results.

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.

Figure 1: Domain for Pattern String

Figure 2: Domain for Pattern Type (1)

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.

Figure 4: Data Element for Pattern String

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.

Figure 6: Search Help  for DataSource Fields

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.

Figure 8: Delivery and Maintenance Properties

Figure 9: Control Table – Administration Settings

Figure 10: Metadata Repository Table – Basic Characteristics

Figure 11: Metadata Repository Table – Characteristics with Reference

Figure 12: Metadata Repository Table – Units

Figure 13: Metadata Repository Table – Key Figures

Figure 14: Customizing Table – Time Characteristics (1)

 

Figure 15: Customizing Table – Time Characteristics (2)

Figure 16: Customizing Table – Time Characteristics (3)

Figure 17: Customizing Table – Exclude Patterns

Figure 18: Metadata Repository Table – Mapping (1)

Figure 19: Metadata Repository Table – Mapping (2)

Figure 20: Metadata Repository Table – Mapping (3)

Figure 21: Metadata Repository Table – Mapping (4)

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.

Figure 23: Lock Object – Basic Characteristics (1)

Figure 24: Lock Object – Basic Characteristics (2)

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

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

Figure 27: Lock Object – Units (1)

Figure 28: Lock Object – Units (2)

Figure 29: Lock Object – Key Figures (1)

Figure 30: Lock Object – Key Figures (2)

Figure 31: Lock Object – Mapping Rules (1)

Figure 32: Lock Object – Mapping Rules (2)