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

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.

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.Click Continue Button.

Step 2) Create Application component.

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

3. Navigate to Modeling tab->Data Sources.
4. Choose the Source System.

5. Right click -> Create Application Component.

6. Enter the Technical Name.
7. Enter the Description.
8. Click Continue.

Step 3) Create Data Source.

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

3. Navigate to Modeling tab->Data Sources.
4. Right click -> Create Data Source.

5. Enter Technical Name.
6. Choose the DataType DataSource.
7. Click Continue.

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

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

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

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

3. Navigate to Modeling tab->InfoProvider.
4. Create Transformation.

5. Enter Target Object Type.
6. Enter Target Object Name.
7. Enter Source Object Type.
8. Enter Source Object Name.
9. Enter the Source System.
10. Click Continue.

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

Step 5) Create Data Transfer Process.

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

Below screen shows the DTP created.

Step 6) 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 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.