Extraction to Flat Files 

Use

You can select flat files in the format .CSV as an open hub destination.

Functions

The only file format that is supported for extraction to flat files is .CSV. A control file with information about the metadata is also generated. You can either save the file on the application server or in a local directory.

If you save the file locally, the file size may not exceed a half GB. When transferring mass data, you should save the file on the application server.

If the data is to be written to an application server from the BW system you have to options for determining the file name:

·        File name:

The file name is made up of the name of the HOME directory (DIR_HOME in the transaction AL11), the technical name of the InfoSpoke and the suffix .CSV. You cannot change this name.

·        Logical file name:

Using input help, you can select a logical file name that you have previously defined in Customizing. Create a logical path and assign a logical name to it (see also Creating and Defining Logical Paths and Creating and Defining Logical File Names).

When you define a logical file name you can also specify a data format. However, the InfoSpoke ignores this specification. Extraction always takes place in CSV format.

A logical file name can be comprised of hard-defined path information, but also of variables such as calendar day and time. Logical file names can be transported.

If you save the file in a local directory, you cannot change the name of the file. It is comprised of the technical name of the InfoSpoke and the suffix .CSV. The associated control file also receives the prefix S_.