How To Load Master Data From Flat File in SAP BI/BW

Load Master Data From Flat File

We will learn the load with the help of a scenario –

Load Master data to InfoObject ZMAT (Material Number) which has the attribute, ZMAT_NM (Material Name. Below are detailed Steps to Load data to Master data Infoobject from Flat file

Step 1) Create source system for flat file.

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

In the next screen,

1. Navigate to Modeling tab->Source Systems.
2. Right click on the folder named FILE and choose “Create” from the context menu.

In the next screen,

1. Enter the Logical System Name.
2. Enter the Description.
3. Click Continue Button.

Step 2) Create Application component.

1. Navigate to Modeling tab->Data Sources.
2. Choose the Source System.

3. Right click -> Create Application Component.

4. Enter the Technical Name.
5. Enter the Description.
6. Click Continue.

7. Navigate to Modeling tab->Data Sources.
8. Right click -> Create Data Source

9. Enter Technical Name.
10. Choose the DataType DataSource.
11. Click Continue.

12. Enter the Fields shown below. This Structure should be the same as the DSO to which transaction data is to be loaded.

13. In the Extraction tab, choose the Adapter as “Load Text-Type File from Local Workstation”.
14. Choose the file path where the flat file to be loaded is placed in the system and activate data source.

Click Save.

Step 3) Create transformation between Data Source(Source) and InfoObject Attribute(Target).

Right click on the DataSource -> Create Transformation

In the next screen,

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

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

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

Below screen shows the DTP created.

Step 4) Create Infopackage and Schedule dataload to the DataSource(PSA).

1. Enter RSA1 in command prompt
2. Hit Enter
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 5) Load data to the DSO.

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