How to Load Master Data From ECC in SAP BI/BW
Jessica Blake
⚡ Smart Summary
Loading master data from ECC into SAP BW creates a generic DataSource for the text, attribute, or hierarchy, builds a transformation to the target InfoObject, and runs an InfoPackage and data transfer process to load the records.
What is Master Data Loading from ECC?
Master data describes business entities such as customers, materials, and cost centers through attributes, texts, and hierarchies. Loading master data from ECC into SAP BW creates a generic DataSource for the data, builds a transformation to the target InfoObject, and runs an InfoPackage and data transfer process to load the records.
Step 1: Create a Generic DataSource for the Text InfoObject
Right click on the BI Source System -> Customizing Extractors.
In the next screen, click on Maintain Generic DataSources.
In the next screen:
- Type a technical name for the text.
- Click the Create button.
In the next screen:
- Enter the Short, Medium, and Long Description.
- Enter the View/Table name.
Press the Enter button. The below screen is displayed.
Now:
- Go to transaction code RSA1.
- Click the OK button.
In the next screen:
- Go to the DataSource tab.
- Click Find.
- Type the DataSource technical name.
- Click the Search button.
Next, from the DataSource ZGR24CC_TEXT, right click Replicate Metadata as shown below. Activate the DataSource.
Step 2: Create a Transformation (DataSource to InfoObject Text)
- Go to transaction code RSA1.
- Click the OK button.
In the next screen, right click on the DataSource -> Create Transformation.
In the next screen:
- Enter the Target Object Type.
- Enter the Target Object Name.
- Enter the SubType. Choose Text.
- Click Continue.
The transformation is created with automatic mapping of the source fields to the target fields.
Step 3: Create an InfoPackage and Schedule the Load to PSA
- Go to transaction code RSA1.
- Click the OK button.
- Navigate to the Modeling tab -> DataSources.
- Right click on the DataSource -> Create InfoPackage.
- Enter the InfoPackage description.
- Click Save.
- Click on the Schedule tab.
- Click the Start button to start the load to the DataSource (PSA).
Step 4: Create a Data Transfer Process
Right click on the DTP folder and choose the option “Create Data Transfer Process” from the context menu.
The below screen shows the DTP created.
Step 5: Load Data to the InfoObject Text
- Click the Execute tab in the DTP.
- Click the Execute button to start the data load from the DataSource (PSA) to the InfoObject Text.
