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

What is Flat File Data Loading in SAP BW?

Loading transaction data from a flat file lets you bring external data, such as a CSV or text file, into SAP BW for reporting. In this scenario, data is loaded into a DSO named “DEMO_DSO” with the following fields:

• Key Fields: ZCUST (Customer), ZMAT (Material)
• Data Fields: ZPRICE (Material Price), ZQTY (Quantity)

Below are the steps to load data to the DSO from a flat file.

Step 1: Create a Source System for the Flat File

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

In the next screen:

1. Navigate to the 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 the Continue button.

Step 2: Create an Application Component

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

3. Navigate to the 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 the DataSource

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

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

5. Enter the 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 is placed and activate the DataSource.

Step 4: Create a Transformation (DataSource to DSO)

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

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

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

The below screen shows the transformation created with automatic mapping of the source fields to the target fields.

Step 5: Create a Data Transfer Process

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

The below screen shows the DTP created.

Step 6: Create an InfoPackage and Schedule the Load

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

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

5. Enter the InfoPackage description.
6. Click Save.

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

Step 7: Load Data to the DSO

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

FAQs