Example: Importing CSV Files

Uploading a CSV to the file server

Convert the input data above into a CSV file format and upload it to the server /usr/sap/trans70/hana (the whitelist path).

You can configure the whitelist path under Environment  File Format Tab.

Server File Tab

1. In the function details, while in edit mode, choose Upload.

2. Choose the input data that you want to upload. Select the file name of the CSV file.

Use the CSV file in the function

1. Once you have uploaded the file to the server, choose the Refresh Directory List button.

2. Select .csv file, then choose the Select File button.

3. The system displays the file name in the header section as “ <File name>.csv”.

Mapping of Fields

1. You can map the file columnsto existing fields in the environment. In edit mode, choose the Field Mapping Proposal button. This button helps to match columns to field names.

2. In the File column, there should be a field named ZX_QTY (Quantity).

3. Map ZX_QTY to ZE_QTY by assigning ZE_QTY in the Field column.