Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

flat file

Hello experts ,

I m searching a step by step process for Master data upload using a flat file the BW .

replied

Hello Raman,

Well master data is being uploaded using a standard method in BW and it is being mentioned below:-

Master Data Upload using Flat File

Under the InfoSource tab, right click on Infosources and create an Application Component ZAPPL_GRP## and description as Application Component for Group##.

In your Application Component, create an InfoSource for Direct Update of Master Data.

Enter the characteristic ZPRNM##.

Assign a datasource to that InfoSource. In Source System, give FILE.

Maintain the Transfer Structure by assigning the InfoObject in Transfer Rules.

The Transfer Structure must describe your Flat File Structure.

Maintain the Communication Structure by transferring all the Transfer Structure fields to the Communication Structure.

Save and Activate.

Create an Infopackage for uploading data from the Source System.

In the External Data tab, enter the Name of the File. Make sure that the file in CSV format.

Select the File Type as CSV file and the Data Separator as comma (,).

Enter 1 in the field Number of Header Rows to be Ignored, because the CSV file contains the description of the columns in the first row.

Save and Preview to check whether that data can be processed correctly.

Select the appropriate option in the Processing tab.

Start the extraction from the Schedule tab and Monitor.

Create the same for other characteristics.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question