---
description: 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 Ma
title: How To Load Master Data From Flat File in SAP BI/BW
image: https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png
---

[Skip to content](#main)

**⚡ Smart Summary**

Load master data from a flat file in SAP BI/BW by configuring a flat file source system, creating a DataSource, transformation, DTP, and InfoPackage. The structured workflow ensures clean attribute mapping, validated extraction, and reliable loading into InfoObjects.

- 🧱 **Source System Setup:** Use transaction RSA1 in SAP BI to register a flat file source system under the FILE folder before any data load.
- 📦 **DataSource Creation:** Define an Application Component, create a DataSource with field structure matching the target InfoObject attributes, and activate it.
- 🔁 **Transformation Mapping:** Build a transformation between the flat file DataSource and the InfoObject attribute target so source fields map cleanly to target fields.
- ⚙️ **DTP Execution:** Create the Data Transfer Process to move records from PSA into the master data InfoObject reliably.
- 📥 **InfoPackage Scheduling:** Configure an InfoPackage to schedule the load from the flat file into the PSA, then run the DTP to load the DSO.

Read More

[![Load Master Data From Flat File in SAP BI/BW](https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png)](https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png)

## Load Master Data From Flat File

Master data loading in SAP BI/BW is a foundational task for analytical reporting. In this walkthrough, you will learn how to load master data into an InfoObject from a flat file using a clear, repeatable workflow.

**We will learn the load with the help of a scenario:** Load master data into InfoObject **ZMAT** (Material Number), which has the attribute **ZMAT\_NM** (Material Name). Below are detailed steps to load data into the master data InfoObject from a flat file.

[![Load Master Data From Flat File]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_1.jpg)

## Step 1: Create a Source System for the Flat File

The first stage is to register a flat file source system so SAP BI can recognize where the incoming data originates.

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

[![Create Source System Transaction RSA1]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_2.jpg)

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.

[![Create FILE Source System]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_3.jpg)

On the next screen:

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

[![Enter Logical System Name]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_4.jpg)

**Don't Miss:**

- [How to Create an InfoObject Catalog in SAP BI/BW](https://www.guru99.com/how-to-create-an-infoobject-catalog.html)
- [How to Create an InfoObject with Characteristics in SAP BI/BW](https://www.guru99.com/how-to-create-an-infoobject-with-characteristics.html)
- [RSA5 Tcode in SAP BW: Load ECC Transaction Data](https://www.guru99.com/how-to-load-transaction-data-from-ecc.html)
- [Star Schema & Extended Star Schema in SAP BI/BW](https://www.guru99.com/all-about-classical-extended-star-schema.html)

## Step 2: Create an Application Component

Application Components organize DataSources logically. Define one before creating the DataSource so the flat file load is grouped sensibly.

1. Navigate to **Modeling tab > Data Sources**.
2. Choose the Source System you just created.

[![Choose Source System for Data Source]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_5.jpg)

3. Right-click and select **Create Application Component**.

[![Create Application Component]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_6.jpg)

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

[![Enter Application Component Technical Name]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_7.jpg)

### Create the DataSource

Next, create a DataSource under the Application Component to hold the incoming flat file structure.

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

[![Create Data Source]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_8.jpg)

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

[![Choose DataSource DataType]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_9.jpg)

12. Enter the fields shown below. This structure should match the [DSO](https://www.guru99.com/what-is-dso-why-use-it.html) to which transaction data will be loaded.

[![DataSource Fields Matching DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_10.jpg)

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 is placed, then activate the DataSource.

[![Extraction Tab Flat File Path]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_11.jpg)

Click **Save**.

## Step 3: Create Transformation Between DataSource and InfoObject Attribute

The transformation defines how source fields map to the target InfoObject attributes. SAP BI auto-suggests mappings when field names align.

Right-click on the DataSource and select **Create Transformation**.

[![Create Transformation from DataSource]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_12.jpg)

On the next screen:

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

[![Transformation Target Object Settings]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_13.jpg)

The transformation is created with automatic mapping of the source fields to the target fields.

### Create the Data Transfer Process (DTP)

A DTP transfers records from the PSA into the active data target.

Right-click on the DTP folder and choose **Create Data Transfer Process** from the context menu.

[![Create Data Transfer Process]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_14.jpg)

The screen below shows the DTP created successfully.

[![DTP Created Confirmation]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_15.jpg)

## Step 4: Create an InfoPackage and Schedule the Data Load

The InfoPackage controls how the flat file is read into the PSA. Schedule it before running the DTP.

1. Enter **RSA1** in the command prompt.
2. Press **Enter**.
3. Navigate to **Modeling tab > DataSources**.
4. Right-click on the DataSource and select **Create InfoPackage**.

[![Create InfoPackage]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_16.jpg)

5. Enter the InfoPackage Description.
6. Click **Save**.

[![InfoPackage Description]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_17.jpg)

7. Click the **Schedule** tab.
8. Click **Start** to begin the load from the flat file to the DataSource.

[![Schedule InfoPackage]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_18.jpg)

## Step 5: Load Data to the DSO

The final stage executes the DTP to move records from PSA into the active master data InfoObject.

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

[![Execute DTP Load to DSO]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_19.jpg)

## Best Practices for Flat File Master Data Loads

Following a few proven habits keeps flat file loads predictable and easy to troubleshoot in SAP BI/BW.

- **Validate the flat file:** Ensure the field order, delimiters, and date formats in the file match the DataSource structure before activation.
- **Match attribute keys:** Verify the key field of the InfoObject is unique in the source file to avoid load rejections.
- **Test with small samples:** Run the InfoPackage and DTP with a small file first, then scale to full volume after the mapping is confirmed.
- **Monitor PSA records:** Check the PSA after the InfoPackage run to confirm record counts before triggering the DTP.
- **Document the load:** Record the Application Component, DataSource, and DTP names so the load can be reproduced or handed over easily.

## FAQs

📂 What flat file formats does SAP BI/BW support for master data loads?

SAP BI/BW supports CSV text files and ASCII files for flat file loads. Files can be loaded from the local workstation or from an application server path defined in the DataSource Extraction tab.

🔄 What is the difference between an InfoPackage and a DTP?

An InfoPackage loads source data into the PSA layer. A DTP (Data Transfer Process) then moves records from the PSA into the target object such as a DSO, InfoCube, or master data InfoObject.

⚠️ Why does my flat file load fail with mapping errors?

Mapping errors usually occur when source fields do not match target InfoObject attributes by name or type. Verify the DataSource field structure, data types, and key fields align with the target InfoObject before activation.

🛠️ Can I schedule recurring flat file loads in SAP BI/BW?

Yes. Use the Schedule tab in the InfoPackage to configure periodic loads such as daily or weekly runs. For unattended runs, place the file on the application server and schedule via Process Chains.

🤖 How can AI improve flat file master data loading in SAP BI/BW?

AI tools can profile source files, detect anomalies, and recommend field mappings between DataSource structures and InfoObject attributes. Machine learning models can also flag duplicate records and forecast volume spikes that may impact load performance.

✨ Can AI auto-cleanse master data before loading into SAP BI/BW?

Yes. AI-powered data quality tools can standardize names, deduplicate records, fix casing, and validate reference codes in the flat file before it reaches the PSA. This reduces transformation rejects and improves InfoObject attribute accuracy.

#### Summarize this post with:

ChatGPTPerplexityGrokGoogle AI

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.**

##### Sign up for the newsletter

Subscribe for Free

You have successfully subscribed.  
Please check your inbox.

![AI-Newsletter]() Chosen by over **350,000+** professionals

[Scroll to top](#wrapper)

×

Search for:

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png","url":"https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png","width":"700","height":"250","caption":"Load Master Data From Flat File in SAP BI/BW","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sap-bi","name":"SAP - BI"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html","name":"How To Load Master Data From Flat File in SAP BI/BW"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#webpage","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html","name":"How To Load Master Data From Flat File in SAP BI/BW","dateModified":"2026-10-09T16:25:47+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"How To Load Master Data From Flat File in SAP BI/BW","description":"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 Ma","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-09T16:25:47+05:30","image":{"@id":"https://www.guru99.com/images/load-master-data-from-flat-file-in-sap-bi-bw.png"},"copyrightYear":"2026","name":"How To Load Master Data From Flat File in SAP BI/BW","subjectOf":[{"@type":"HowTo","name":"How To Load Master Data From Flat File in SAP BI/BW","description":"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","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_1.jpg","step":[{"@type":"HowToStep","text":"Create source system for flat file.","name":"Go to transaction code RSA1","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_2.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html"},{"@type":"HowToStep","text":"Create Application component.","name":"Navigate to Modeling tab->Data Sources.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_5.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html"},{"@type":"HowToStep","text":"Create transformation between Data Source(Source) and InfoObject Attribute(Target).","name":"Right click on the DataSource -> Create Transformation","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_12.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html"},{"@type":"HowToStep","text":"Create Infopackage and Schedule dataload to the DataSource(PSA).","name":"Enter RSA1 in command prompt","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_16.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html"},{"@type":"HowToStep","text":"Load data to the DSO.","name":"Click Execute tab in the DTP.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_14_19.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html"}]},{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What flat file formats does SAP BI/BW support for master data loads?","acceptedAnswer":{"@type":"Answer","text":"SAP BI/BW supports CSV text files and ASCII files for flat file loads. Files can be loaded from the local workstation or from an application server path defined in the DataSource Extraction tab."}},{"@type":"Question","name":"What is the difference between an InfoPackage and a DTP?","acceptedAnswer":{"@type":"Answer","text":"An InfoPackage loads source data into the PSA layer. A DTP (Data Transfer Process) then moves records from the PSA into the target object such as a DSO, InfoCube, or master data InfoObject."}},{"@type":"Question","name":"Why does my flat file load fail with mapping errors?","acceptedAnswer":{"@type":"Answer","text":"Mapping errors usually occur when source fields do not match target InfoObject attributes by name or type. Verify the DataSource field structure, data types, and key fields align with the target InfoObject before activation."}},{"@type":"Question","name":"Can I schedule recurring flat file loads in SAP BI/BW?","acceptedAnswer":{"@type":"Answer","text":"Yes. Use the Schedule tab in the InfoPackage to configure periodic loads such as daily or weekly runs. For unattended runs, place the file on the application server and schedule via Process Chains."}},{"@type":"Question","name":"How can AI improve flat file master data loading in SAP BI/BW?","acceptedAnswer":{"@type":"Answer","text":"AI tools can profile source files, detect anomalies, and recommend field mappings between DataSource structures and InfoObject attributes. Machine learning models can also flag duplicate records and forecast volume spikes that may impact load performance."}},{"@type":"Question","name":"Can AI auto-cleanse master data before loading into SAP BI/BW?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI-powered data quality tools can standardize names, deduplicate records, fix casing, and validate reference codes in the flat file before it reaches the PSA. This reduces transformation rejects and improves InfoObject attribute accuracy."}}]}],"@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#schema-558500","isPartOf":{"@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/how-to-load-master-data-from-flat-file.html#webpage"}}]}
```