Other possibilites for loading logistics data from from SAP ECC to SAP BI
Exercise 3: Load ECC logistics data to BI
Exercise Objectives
After completing this exercise, you will be able to:
• Load the data you created in the SAP ECC system in preparation for reporting in BI
Business Example
Before you can report on your logistics data in BI you first have to load this from a source system, in our case the SAP ECC system.
Note: In the following exercises you will load your sales and purchase order data only. You will NOT load your production order data (the instructor will do this for the entire class).
Task 1:
You will now create a DTP in order to define the parameters for the loading of your sales order data. You will then execute the DTP so that only your data is loaded to a shared BI InfoCube.
1. Logon to the assigned BI system using the logon details provided by your instructor and navigate to the Data Warehousing Workbench.
2. Create a DTP with the name Group ## Load Sales Data to load the data from the DataSource (PSA) 2LIS_11_ VAITM (under the source system T90CLNT090) to the InfoCube T_SDDEMO2. Do not change any default settings in the DTP except for the filter value. You should define a filter so that only your material (150-##) is loaded.
Execute your DTP immediately and check the monitor to ensure the data loaded successfully.
Task 2:
You will now create a DTP in order to define the parameters for the loading of your purchase order data. You will then execute the DTP so that only your data is loaded to a BI InfoCube.
1. Create a DTP with the name Group ## Load Purchase Order Data to load the data from the DataSource (PSA) 2LIS_02_ITM (under the source system T90CLNT090) to the InfoCube 0PUR_C01. Do not change any default settings in the DTP except for the filter value. You should define a
Solution 3: Load ECC logistics data to BI
Task 1:
You will now create a DTP in order to define the parameters for the loading of your sales order data. You will then execute the DTP so that only your data is loaded to a shared BI InfoCube.
1. Logon to the assigned BI system using the logon details provided by your instructor and navigate to the Data Warehousing Workbench.
a) Ask your instructor for the logon information. Once you have logged on use the transaction RSA1 to reach the Data Warehousing Workbench.
2. Create a DTP with the name Group ## Load Sales Data to load the data from the DataSource (PSA) 2LIS_11_ VAITM (under the source system T90CLNT090) to the InfoCube T_SDDEMO2. Do not change any default settings in the DTP except for the filter value. You should define a filter so that only your material (150-##) is loaded.
Execute your DTP immediately and check the monitor to ensure the data loaded successfully.
a) Under the Modelling panel on the left of the screen click on the entry Source Systems.
b) Expand the node SAP and locate the source system with the technical name T90CLNT090. Right click on this entry and from the context menu choose Display DataSource Tree.
c) Expand the node in the following path SAP→ SAP Application Components→ Sales and Distribution and locate the DataSource with the technical name 2LIS_11_VAITM.
d) Right click on the DataSource and choose the context menu entry Create Data Transfer Process.
e) Use the table below to fill in the required fields for the first dialog in the DTP creation. Hit the button Continue when you are done with the first dialog.
Field Name Value to Enter
Data Transfer Proc. Group ## Load Sales Data Target of DTP > Object
Type
Infocube
Target of DTP > Name T_SDDEMO2
f) On the second screen on the Extraction tab press the button Filter and you will see a dialog appear containing a list of proposed filter characteristics. The oane we want is not on the list so we have to add it in the next step.
g) Press the button Change Selection and locate Material from the list on the right. Click on this characteristic to highlight it then press the arrow left button to move it across to the left side. (to check it you may have to scroll to the bottom of the list on the left). Press Continue to close the Change Selection dialog ready to enter a filter values.
h) Enter your material 150-## in the selection field then press the Continue button to close the dialog.
i) From the toolbar click on the button Activate Data Transfer Process . Make sure you have no error messages before continuing.
j) Click on the Execute tab and press the button Execute. When prompted click Yes to jump to the monitor. Make sure your job has a green light next to it to show it loaded the data successfully.
k) Use the regular back arrow at the top of the screen to leave the monitor.
Task 2:
You will now create a DTP in order to define the parameters for the loading of your purchase order data. You will then execute the DTP so that only your data is loaded to a BI InfoCube.
1. Create a DTP with the name Group ## Load Purchase Order Data to load the data from the DataSource (PSA) 2LIS_02_ITM (under the source system T90CLNT090) to the InfoCube 0PUR_C01. Do not change any default settings in the DTP except for the filter value. You should define a filter so that only your material (RM-##) is loaded.
Execute your DTP and check the monitor to ensure the data loaded successfully.
a) Under the Modelling panel on the left of the screen click on the entry Source Systems.
b) Expand the node SAP and locate the source system with the technical name T90CLNT090. Right click on this entry and fro the context menu choose Display DataSource Tree.
c) Expand the node in the following path SAP→ SAP Application Components→ Materials Management and locate the DataSource with the technical name 2LIS_02_ITM.
d) Right click on the DataSource and choose the context menu entry Create Data Transfer Process.
e) Use the table below to fill in the required fields for the first dialog in the DTP creation. Hit the buttonContinue when you are done with the first dialog.
Field Name Value to Enter
Data Transfer Proc. Group ## Load Purchase Order Data Target of DTP > Object
Type
Infocube
Target of DTP > Name 0PUR_C01
f) On the second screen on the Extraction tab press the button Filter and you will see a dialog appear containing a list of proposed filter characteristics. The one we want is not on the list so we have to add it in the next step.
g) Press the button Change Selection and locate Material from the list on the right. Click on this characteristic to highlight it then press the arrow left button to move it across to the left side. (to check it you may have to scroll to the bottom of the list on the left). Press Continue to close the Change Selection dialog ready to enter some filter values.
h) Enter your material RM-## in the selection field then press the Continue button to close the dialog.
i) From the toolbar click on the button Activate Data Transfer Process.
Make sure you have no error messages before continuing.
j) Click on the Execute tab and press the button Execute. When prompted click Yes to jump to the monitor. Make sure your job has a green light next to it to show it loaded the data successfully.
Lesson Summary
You should now be able to:
• Describe the necessary steps to extract data from the ECC system to BI.
Unit Summary
You should now be able to:
• Describe the necessary steps to extract data from the ECC system to BI.
Test Your Knowledge
1. What is the sequence in which data is extracted from ECC to BI?
Choose the correct answer(s).
□ A Info Sources→ Info Cubes → Data Sources
□ B Info Sources→ Data Sources → Info Cubes
□ C Data Sources→ Info Sources → Info Cubes
□ D Data Sources→ Info Cubes → Info Sources
□ E Info Cubes→ Data Sources → Info Sources
□ F Info Cubes→ Info Sources → Data Sources
2. What are the update modes for InfoPackage?
Choose the correct answer(s).
□ A Delta Update
□ B Initialisation Process
□ C Part Update
□ D Full Updates
Answers
1. What is the sequence in which data is extracted from ECC to BI?
Answer: C
The data comes in the Data sources first. Using transfer rules, this is loaded into Info Sources. Then Transformations are used to transfer this to InfCubes.
2. What are the update modes for InfoPackage?
Answer: A, B, D
You can do a full update or do an initialisation followed by delta updates.