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. 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.

 

Fig_01_Line_Structure_Data_Element.jpg

Figure 1: Line Structure Data Element

 

Fig_02_Line_Structure_Data_Element_Text.jpg

Figure 2: Line Structure Data Element Text

 

Fig_03_Line_Structure_Domain.jpg

Figure 3: Line Structure Domain

 

Fig_04_Line_Structure_Domain_Text.jpg

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.

 

Fig_05_Table_Type_Data_Element.jpg

Figure 5: Table Type Data Element

 

Fig_06_Table_Type_Data_Element_Text.jpg

Figure 6: Table Type Data Element Text

 

Fig_07_Table_Type_Domain.jpg

Figure 7: Table Type Domain

 

Fig_08_Table_Type_Domain_Text.jpg

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.

 

Fig_09_Function_Group.jpg

Figure 9: Function Group

 

Fig_10_Function_Module_Data_Element_Texts_1.jpg

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

 

Fig_11_Function_Module_Data_Element_Texts_2.jpg

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

 

Fig_12_Function_Module_Data_Element_Texts_3.jpg

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.

 

Fig_13_Function_Module_Domain_Texts_1.jpg

Figure 13: Function Module for Domain Texts (1)

 

Fig_14_Function_Module_Domain_Texts_2.jpg

Figure 14: Function Module for Domain Texts (2)

 

Fig_15_Function_Module_Domain_Texts_3.jpg

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.

To report this post you need to login first.

3 Comments

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

Leave a Reply