File (SAP Library - Business Intelligence)

File

Use

With the node This graphic is explained in the accompanying text Read Data from File, you are able to use data from a file in an analysis process. The file can either be found on an application server or on the presentation server.

Functions

The technical name of the InfoObject has to be in the first line of the file, for example, 0BPARTNER for the business partner. The data is in the following lines. The values are separated from one another with semicolons (;). Each line in the file becomes a data record. The data are transferred with ABAP MOVE logic into type-related fields. The data is expected in internal data format.

Example

Internal date format for displaying date: YYYYMMDD

Example: 02. January 2004 = 20040102

Internal date format for numeric entries: leading zeros are added until the field length is filled.

Example for an eight digit field: 1234 = 00001234

If you require several columns with the same InfoObject, you can add a field name prefix when you specify the InfoObejct: <fieldname> <InfoObject>. Separate the field name from the name of the InfoObject with a colon (:).

Example

You want to read a file that contains the answers of a questionnaire in each line. The first line of the file can contain the following information:

0BPARTNER ; ANSWER1:0WS_ANSWER ; ANSWER2:0WS_ANSWER ; ANSWER3:0WS_ANSWER

Only data from the application server can be used in background processing.

Example

A file should contain the following data:

Business partner	Sales Revenue	Currency
1000	1200	EUR
1002	1500	EUR
1080	1100	EUR

The file must also have the following content:

0BPARTNER;0REVENUE;0CURRENCY

1000;1200;EUR

1002;1500;EUR

1080;1100;EUR