SAP Knowledge Base Article - Public

2803034 - You Can't Find Key Figure "Quantity" and "Net Value" when Download Data Source in CSV format for Report "Sales Order Analysis".

Symptom

 Key Figure "Quantity" and "Net Value" are missing when Download Data Source in CSV format for Report "Sales Order Analysis".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Order work center, open Report View, then open the report "Sales Order Analysis"
  2. Select Company as "ABC" (where ABC stands for Company you have selected); Reporting Period as "Last Month"
  3. Start the report
  4. You can see the Key Figure "Quantity" and "Net Value"
  5. Click Share button, then Download Data Source in CSV format
  6. Open the downloaded file in Excel
  7. You can find that the Key Figure column "Quantity" and "Net Value" are missing 

Cause

For the Report ID: /SFL0000Q/SOA; Report Name: Sales order analysis; Data Source ID: CRMSLOIB, the key figure "Quantity" and "Net Value" available in report are not coming from the datasource directly, but are defined as restricted key figures.

These key figures are not considered in the download of data source.

Resolution

The key figure "Quantity" and "Net Value" are not missing when Download Report in CSV Format or Report in MS Excel in XML Format. You can make use of these two report formats.

Keywords

 Sales Order Analysis, Key Figure, Quantity, Net Value , KBA , SRD-CRM-ORD , Orders & Contracts , How To

Product

SAP Business ByDesign all versions