How to Load Transaction Data from ECC: SAP RSA5

Load Transaction Data from ECC

Following are the steps to perform the data extraction from ECC into BW systems. We will take Logistics (Purchasing application module) in our example.

Step 1) Login into ERP system

  1. Input the T code- RSA5.
  2. Click Continue button.

Load Transaction Data from ECC in SAP

Step 2) Click on the folder SAP R/3 as shown below screenshot

Load Transaction Data from ECC in SAP

Step 3) Go to the Folder MM (Materials Management)—MM-IO as shown below in screenshot in Box.

Load Transaction Data from ECC in SAP

Step 4) Choose the datasource 2LIS_02_ITM, which is purchasing data at Item level.

Load Transaction Data from ECC in SAP

Step 5) Choose the datasource 2LIS_02_ITM and go to the Datasource tab and click Change the datasource as shown in screenshot.

Load Transaction Data from ECC in SAP

Note: This step is used when we need to add additional fields, to push into BW. Similarly, we can do the same steps (Step1-5) for of fields which we don’t wish to populate in BW.

After choosing the Change datasource tab, you can see all the fields associated with this datasource as shown below.

Load Transaction Data from ECC in SAP

Step 6) Now, as per the above screenshot the Field EFFWR –Effective value item is unchecked in selection field which means that it is not available in BW. To populate the Field EFFWR in BW, we will have to check mark in selection field as shown below.

Load Transaction Data from ECC in SAP

Step 7) After checking the field EFFWR in selection save the datasource as shown below.

Load Transaction Data from ECC in SAP

Step 8) Activate the datasource as shown below.

Load Transaction Data from ECC in SAP

Now we are ready to push the changed datasource 2LIS_02_ITM after selecting the Field EFFWR into BW.

Step 9)

  1. Log into BW system, go to the Datasource tab
  2. Click Find to search.
  3. Type the datasource technical name.
  4. Click Search button.

Load Transaction Data from ECC in SAP

Step 10) From the datasource 2LIS_02_ITM, right click Replicate Metadata as shown below.

Load Transaction Data from ECC in SAP

After sucessfull replication of datasource, the Filed EFFWR will be available in BW

Load Transaction Data from ECC in SAP

Step 11) Load the data from ECC into BW to populate the filed EFFWR with some data.

  1. Go to transaction code RSA1
  2. Click the OK button.

Load Transaction Data from ECC in SAP

  1. Navigate to Modeling tab->DataSources.
  2. Right Click on DataSource -> Create Infopackage.

Load Transaction Data from ECC in SAP

This Infopackage is used to load the data from ECC into BW system at PSA level which is intermediate level.

  1. Enter the InfoPackage Description.
  2. Click Save.

Load Transaction Data from ECC in SAP

  1. In order to trigger the data load from ECC into BW, go to the Infopackage, Click on Schedule tab.
  2. Click Start button to start the load from the flat file to the Data Source.

Load Transaction Data from ECC in SAP