How to Load Transaction Data from Flat File in SAP BI/BW

We will learn how to load transactional data from a Flat File with the help of a scenario.

Scenario: Load data to the DSO named “DEMO_DSO”. The DSO has the following fields.

Key Fields:

ZCUST – Customer

ZMAT – Material

Data Fields:

ZPRICE – Material Price

ZQTY – Quantity

Load Transaction Data from Flat File

Lets look into the Steps to Load data to DSO from Flat file

Step 1) Create source system for flat file.

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

Load Transaction 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 Transaction Data from Flat File

In the next screen,

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

Load Transaction Data from Flat File

Step 2) Create Application component.

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

Load Transaction Data from Flat File

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

Load Transaction Data from Flat File

  1. Right click -> Create Application Component.

Load Transaction Data from Flat File

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

Load Transaction Data from Flat File

Step 3) Create Data Source.

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

Load Transaction Data from Flat File

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

Load Transaction Data from Flat File

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

Load Transaction 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 Transaction 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 Transaction Data from Flat File

Step 4) Create transformation between Data Source(Source) and DSO(Target).

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

Load Transaction Data from Flat File

  1. Navigate to Modeling tab->InfoProvider.
  2. Create Transformation.

Load Transaction Data from Flat File

  1. Enter Target Object Type.
  2. Enter Target Object Name.
  3. Enter Source Object Type.
  4. Enter Source Object Name.
  5. Enter the Source System.
  6. Click Continue.

Load Transaction Data from Flat File

Below screen shows the transformation created with automatic mapping of the Source fields to the Target fields.

Load Transaction Data from Flat File

Step 5) Create Data Transfer Process.

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

Load Transaction Data from Flat File

Below screen shows the DTP created.

Load Transaction Data from Flat File

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

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

Load Transaction Data from Flat File

  1. Navigate to Modeling tab->DataSources.
  2. Right click on the DataSource -> Create InfoPackage.

Load Transaction Data from Flat File

  1. Enter the InfoPackage Description.
  2. Click Save.

Load Transaction 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 Transaction Data from Flat File

Step 7) 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 Transaction Data from Flat File