Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
sander_vanwilligen
Active Contributor


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

Please have a look here to download the attachments.

Step 1: Create Number Range Object


SAP Menu: Tools > ABAP Workbench > Development > Other Tools > Number Ranges


T/code: SNRO


 

Create Number Range Object YBWDSOTMPL as shown in the screenshots.


 


Figure 1: Number Range Object (1)


 


Figure 2: Number Range Object (2)


 


Figure 3: Number Range Object (3)



Step 2: Create Application Log Object and Subobject


SAP Menu: Tools > ABAP Workbench > Development > Other Tools > Application Log


T/code: SLG0


 

Create Application Log Object YBW and Application Log Subobject YBWDWHIOBJ as shown in the screenshot.


 


Figure 4: Application Log Object and Subobject



Step 3: Create Authorization Object


SAP Menu: Tools > ABAP Workbench > Development > Other Tools > Authorization Objects > Objects


T/code: SU21

 

Create Authorization Object Class YBW and Authorization Object YBWDWHIOBJ as shown in the screenshots.


 


Figure 5: Authorization Object Class


 


Figure 6: Authorization Object (1)


 


Figure 7: Authorization Object (2)



Step 4: Create Message Class


SAP Menu: Tools > ABAP Workbench > Development > Programming Environment > Messages


T/code: SE91


 

Create Message Class YBWIOBJ as shown in the screenshots.


 


Figure 8: Message Class (1)


 


Figure 9: Message Class (2)


 

Refer to the attached file YCX_BW_DWH_IOBJ_and_YBWIOBJ_v1.txt (Part 1 - Message Class YBWIOBJ) for an overview of all messages with their short text.



Step 5: Create Exception Class


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


T/code: SE24


 

Create class YCX_BW_DWH_IOBJ as shown in the screenshots. Make sure that you flag checkbox With Message Class.


 


Figure 10: Exception Class (1)


 

Furthermore, specify on the Properties tab Message Class YBWIOBJ.


 


Figure 11: Exception Class (2)


 

Refer to the attached file YCX_BW_DWH_IOBJ_and_YBWIOBJ_v1.txt. From here you can quite easily build up the class using copy & paste:

  • Public Section: the source code can be found in Part 2 of the attached file;

  • Method CREATE_MSG: the source code can be found in Part 3 of the attached file;

  • Description of Title, Attributes, Method and Parameters can be found in Part 4 of the attached file.


Step 6: Create Class


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


T/code: SE24


 

Create class YCL_BW_DWH_IOBJ as shown in the screenshot.


 


Figure 12: Class


 

Refer to the attached file YCL_BW_DWH_IOBJ_v1.txt. From here you can quite easily build up the class using copy & paste:

  • Source code can be found in Part 1 of the attached file;

  • Description of Title, Attributes, Methods, Parameters, Types and Text Symbols can be found in Part 2 of the attached file.


 

A manual post-processing action is necessary to restrict the SAP BW system(s) in which the program can be executed. Refer to public static method SYSTEM_CHECK. Just after the comment * Execute system check you can define the system(s). Typically you enter here your Development and Sandbox systems.

Step 7: Create Program


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


T/code: SE38


 

Create program YBW_DWH_IOBJ_CREATE as shown in the screenshot.


 


Figure 13: Program


 

Refer to the attached file YBW_DWH_IOBJ_CREATE_v1.txt. From here you can quite easily build up the program using copy & paste:

  • Source code can be found in Part 1 of the attached file;

  • Description of Title, Text Symbols and Selection Texts can be found in Part 2 of the attached file.


Step 8: Create Transaction Code


SAP Menu: Tools > ABAP Workbench > Development > Other Tools > Transactions


T/code: SE93


 

Create transaction code YIOBJ as shown in the screenshots.


 


Figure 14: Transaction Code (1)


 


Figure 15: Transaction Code (2)



5 Comments
Labels in this area