Skip to Content

In this document, we are going to learn how to extract the data from SAP ECC systems into SAP BI system.

Please have a look at the detailed data flow diagram as shown below.

Consider a scenario where we have got a requirement to develop a Sales report with has the following fields

Follow the steps as shown in the figure below

Steps in detail:

Pre-requisite: Make sure that the data in setup tables is deleted (tcode is LBWG)

Step 1: Make sure that RFC connection exists

Go to ECC system:

Step 2: Find the suitable database table with the fields in the report. For Example: Let us assume that we have the fields which we got in the requirement in VBAP table

Step 3: Find the suitable Datasource in LBWE (2LIS_11_VA0ITM) and activate the data source. When the data source is activated, it comes with extraction structure, communication structure and setup tables

Go to SAP BI system:

Step 4: Replicate the data source into BI system

Step 5: Activate the data source (upon activation, a PSA table is generated)

Go to ECC system:

Step 6: Fill the setup tables (OLI*BW)

Go to BI system:

Step 7: Create necessary info objects, info cubes, Data Store Objects, Transformations and Data Transfer Process and activate all the objects

Step 8: Create an info package with ‘Initialization’ option and load the data till PSA. If initialization is successful, a delta queue is created and the delta records come to PSA from the delta queue (not from setup tables)

Step 9: Create an info package with ‘Delta Update’ to load delta records into PSA

Step 10: Load the data to targets using DTP (Data Transfer Process)

Step 11: Create reports on top of info cube as per the requirement using BEx reporting tools

Note:

1. The Direct delta, Queued delta and Unserialized V3 update are the different types of updates in which the data comes to delta queue (The records come to delta queue in any one of the above update techniques)

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