Show TOC Entering content frame

Procedure documentation Transferring Flat Files Locate the document in its SAP Library structure


A file exists that has been saved in *.csv or *.asc format. 


Creating the Source System


       1.      Click Source systems in the tree on the left.

       2.      Right mouse click the Source systems node on the right and choose Create.

       3.      Select FileSystem, manual meta data, data using file interface.

       4.      Choose Enter.

       5.      Enter a name and a description for the source system.

       6.      Choose Enter.

Creating the InfoPackage


Difficulties are sometimes encountered when uploading dates. The system interprets dates from flat files in the user-defined format. Therefore it is essential that you change your user settings to fit the date format in the flat file. To do so, choose System -> User profile -> Own data -> Defaults and select the relevant date format. For more details, see SAP notes 161506, 157643, and 141298.


The following is a short recipe for the entries you need to make in the InfoPackage for Excel files. For detailed information about the individual steps, see Structure linkMaintaining InfoPackages in the Business Information Warehouse documentation for the Administration Workbench.


       1.      Click on InfoSources in the tree on the left.

       2.      Navigate down the InfoSource tree until you can right mouse click the source system you created earlier.

       3.      Choose Create InfoPackage.

       4.      Enter a description, select the DataSource and choose Save.

       5.      You are now in the Scheduler: Maintain InfoPackage screen.

       6.      Make the following settings on the tab pages:



External Data

External Data Parameters


Data Targets

Update Parameters

Schedule Tab

Radio buttons

Client workstation


Control file: No


File type: CSV file


PSA and then into data targets (packet by packet)

Update in all data targets for which update rules exist

Full update


Always update data even if no master data exists for the data

Instant loading of data online



Currency conversion for external systems






Data separator ;

To check the data separator, open the .csv file in Notepad.

Thousand separator ,


Character for decimal point .





File name

C:/ path and name of .csv file














The file is now uploaded from the flat file to the InfoCube.


If you encounter performance difficulties, refer to SAP note 359761.

Leaving content frame