Implementing Data Warehouse InfoObjects - Part 3: ABAP Developments in SAP Source System

[sander_vanwilligen]

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. Implementing Data Warehouse InfoObjects - Part 1: ABAP Dictionary Objects 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. Part 3 describes all ABAP developments to be done in every SAP source system that is subject to Generating Data Warehouse InfoObjects.

Please have a look here to download the attachments.

Step 1: Create Line Structures

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

T/code: SE11

 

Create Line Structures YBW_S_DATEL, YBW_S_DATELTEXT, YBW_S_DOMAIN and YBW_S_DOMAINTEXT as shown in the screenshots.

 

Figure 1: Line Structure Data Element

 

Figure 2: Line Structure Data Element Text

 

Figure 3: Line Structure Domain

 

Figure 4: Line Structure Domain Text

Step 2: Create Table Types

Note: This activity has to be executed in every SAP source system

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

T/code: SE11

 

Create Table Types YBW_T_DATEL, YBW_T_DATELTEXT, YBW_T_DOMAIN and YBW_T_DOMAINTEXT as shown in the screenshots.

 

Figure 5: Table Type Data Element

 

Figure 6: Table Type Data Element Text

 

Figure 7: Table Type Domain

 

Figure 8: Table Type Domain Text

Step 3: Create Function Modules

Note: This activity has to be executed in every SAP source system

SAP Menu: Tools > ABAP Workbench > Development > Function Builder

T/code: SE37

 

Create Function Group YBWDWHIOBJ, Function Module Y_BW_RETRIEVE_DATEL_TEXTS and Function Module Y_BW_RETRIEVE_DOMAIN_TEXTS as shown in the screenshots.

 

Figure 9: Function Group

 

Figure 10: Function Module for Data Element Texts (1)

 

Figure 11: Function Module for Data Element Texts (2)

 

Figure 12: Function Module for Data Element Texts (3)

 

Refer to the attached file Y_BW_RETRIEVE_DATEL_TEXTS_v1.txt for the source code to be inserted.

 

Figure 13: Function Module for Domain Texts (1)

 

Figure 14: Function Module for Domain Texts (2)

 

Figure 15: Function Module for Domain Texts (3)

 

Refer to the attached file Y_BW_RETRIEVE_DOMAIN_TEXTS_v1.txt for the source code to be inserted.