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

Load Master Data From Flat File

Step 1) Create source system for flat file.

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

Load Master Data From Flat File

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.

Load Master Data From Flat File

In the next screen,

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

Load Master Data From Flat File

Step 2) Create Application component.

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

Load Master Data From Flat File

  1. Right click -> Create Application Component.

Load Master Data From Flat File

  1. Enter the Technical Name.
  2. Enter the Description.
  3. Click Continue.

Load Master Data From Flat File

  1. Navigate to Modeling tab->Data Sources.
  2. Right click -> Create Data Source

Load Master Data From Flat File

  1. Enter Technical Name.
  2. Choose the DataType DataSource.
  3. Click Continue.

Load Master Data From Flat File

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

Load Master Data From Flat File

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

Load Master Data From Flat File

Click Save.

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

Right click on the DataSource -> Create Transformation

Load Master Data From Flat File

In the next screen,

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

Load Master Data From Flat File

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.

Load Master Data From Flat File

Below screen shows the DTP created.

Load Master Data From Flat File

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.

Load Master Data From Flat File

  1. Enter the InfoPackage Description
  2. Click Save.

Load Master Data From Flat File

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

Load Master Data From Flat File

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.

Load Master Data From Flat File