RSA5 Tcode in SAP BW: Load ECC Transaction Data

What is Transaction Data Loading from ECC?

Loading transaction data from ECC into SAP BW makes business transaction data, such as purchasing or sales documents, available for reporting. This example uses the Logistics (Purchasing) module to extract data from an ECC DataSource, enhance it, replicate it in BW, and load it into the PSA staging layer.

Enhance and Activate the DataSource in ECC (RSA5)

Step 1) Log into the ERP system.

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

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

Step 3) Go to the folder MM (Materials Management) – MM-IO as shown below.

Step 4) Choose the DataSource 2LIS_02_ITM, which is purchasing data at item level.

Step 5) Choose the DataSource 2LIS_02_ITM, go to the DataSource tab, and click Change the DataSource.

Note: This step is used when you need to add additional fields to push into BW. The same steps (1-5) can be repeated for fields you do not wish to populate in BW. After choosing the Change DataSource tab, you can see all the fields associated with this DataSource.

Step 6) The field EFFWR (Effective value item) is unchecked in the selection field, which means it is not available in BW. To populate EFFWR in BW, check it in the selection field as shown below.

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

Step 8) Activate the DataSource as shown below.

Now you are ready to push the changed DataSource 2LIS_02_ITM, with the field EFFWR, into BW.

Replicate the DataSource in BW

Step 9)

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

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

After successful replication of the DataSource, the field EFFWR is available in BW.

Load the Data with an InfoPackage

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

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

3. Navigate to the Modeling tab -> DataSources.
4. Right click on the DataSource -> Create InfoPackage.

This InfoPackage loads the data from ECC into the BW system at the PSA level, which is an intermediate level.

5. Enter the InfoPackage description.
6. Click Save.

7. To trigger the data load from ECC into BW, go to the InfoPackage and click the Schedule tab.
8. Click the Start button to start the load.

FAQs