You can write data from the BW system to a file via the open hub destination.
- Choose File as the type of destination. The file formats CSV, ASCII, and XML are supported during extraction to files. A control file with information about the metadata is also generated.
- You can save the file either on the application server or in a local directory. For technical reasons, you can only select file format XML for files on the application server. If the file is located on the application server, you can schedule extraction in the background.
If you save the file locally, the file size must not exceed half a gigabyte. When transferring mass data, you should save the file on the application server.
The User Account Control (UAC) in Windows 7 and Windows Vista can create the impression that data is written to a local directory, but no files are actually created. Do not use a directory with restricted authorization.
- If you want to write the data to an application server from the BW system, you have two options for the file name:
- If you save the file in a local directory, you cannot change the name of the file. It is made up of the technical name of the open hub destination and the extension .CSV, .TXT or .XML. The associated control file also has the prefix S_.
- If you select data format XML, you can choose the following formats:
- SAP Standard XML ist the default SAP XML format. It is optimized for data exchange between SAP and external systems in both directions.
- SAP Binary Protocol XML is an internal binary SAP variant of asXML. It can only be used in the SAP system environment. With binary and structure compression however, it provides considerable performance and storage advantages compared to other XML options.
- You can select Default Setting or Direct Entry as the string setting. If you select Default Setting, the system codepage is used. If you select Direct Entry, you can specify your own codepage.