Exporting Data 
Definition
Command for a data provider.
Use
You can export the data of a data provider to a CSV or MS Excel 2000 file or an XML file with this instruction.
Structure
CMD |
EXPORT |
Parameter |
Description |
FORMAT |
Format 'CSV' = CSV file 'XLS' = MS Excel 2000 file 'XML' = XML file |
REDIRECT_URL (optional) |
This parameter is optional for use fort he XML format: The generated XML can be automatically forwarded to antoher service as a form field if this address is specified as the REDIRECT_URL when the export command“is called. This enhancement is especially useful for integration scenarios in which post-processing of query data should occur in another service. |
Notes about the XML format
The XML scheme is equivalent to data description in the Table Interface of the Web API reference. You can find more information under Web Service for Access to Query Data.
Example
Exporting data to MS Excel 2000
<SAP_BW_URL DATA_PROVIDER='View1' CMD='EXPORT' FORMAT='XLS'>