How to Load Master Data From ECC in SAP BI/BW

Steps to Load Master Data From ECC

Step 1) Creating a Generic Data Source for Text InfoObject

Right click on the BI Source System -> Customizing Extractors.

In next screen, click on Maintain Generic DataSources.

In next screen,

1. Type a Technical name for the Text.
2. Click Create Button.

In next screen,

1. Enter the Short, Medium and Long Description.
2. Enter the View/Table name.

Press the Enter button. The below screen is displayed.

Now,

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

In next screen,

1. Go to the Datasource tab
2. Click Find
3. Type the datasource technical name.
4. Click Search button.

Next, from the datasource ZGR24CC_TEXT, right click Replicate Metadata as shown below. Activate the DataSource.

Step 2) Create transformation between Data Source(Source) and InfoObject Text(Target).

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

In next screen, right click on the DataSource -> Create Transformation

In next screen,

1. Enter Target Object Type.
2. Enter Target Object Name.
3. Enter the SubType. Choose Text.
4. Click Continue.

The transformation would be created with automatic mapping of the Source fields to the Target fields.

Step 3) Create Infopackage and Schedule Dataload to the DataSource(PSA).

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

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

5. Enter the InfoPackage Description
6. Click Save.

7. Click on Schedule tab.
8. Click Start button to start the load from the flat file to the Data Source.

Step 4) Create Data Transfer Process.

Right-Click on DTP folder and choose the option “Create Data Transfer Process” from the context menu.

The below shows the DTP created.

Step 5) Load Data to the InfoObject Text.

1. Click Execute tab in the DTP.
2. Click the Execute Button to start data load from the DataSource(PSA) to the InfoObject Text.