SAP Knowledge Base Article - Public

3494875 - How to Change Extracted Financial Data Format?

Symptom

You want to know if it is possible to extract data in a format other than the standard SAP Audit format i.e. AIS Format.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Navigate to the Extraction Run for Financial Data view.
  3. Select the Run ID in question and click Download.
  4. The downloaded file will be in AIS Format.

Cause

When creating an extraction run for financial data, the output format is always set to SAP Audit Format. This cannot be changed.

To extract data in CSV or XML format, execute the reports individually with the desired parameters and then use the download option. This allows you to download the report in CSV or XML format.

Resolution

To extract data in CSV or XML format, follow these steps:

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Select the desired report.
  4. Run the report with the required parameters.
  5. Click on the Share icon and select the Download option.
  6. Download the report in XML or CSV Format.

See Also

Extraction Run for Financial Data Quick Guide | SAP Help Portal

Keywords

Extraction Run for Financial Data, Reports, XML Format, CSV Format, Standard SAP Audit Format, AIS Format , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions