SAP Knowledge Base Article - Public

3208524 - Performance Issue with Report Customer Demand Details

Symptom

You are using report Customer Demand Details (SCMCDU01_Q0001), however it takes several minutes to load a small number of lines.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Select Design Reports view.
  3. Find report Customer Demand Details (SCMCDU01_Q0001).
  4. Open the report.
  5. Use the relevant filter.
  6. Click Apply.
  7. Notice that the system takes several minutes to load the data returned. 

Cause

You need to remove or replace the default selection of Last 12 months for Requested Delivery Year/Month of the report.

This will ensure that the orders of only the requested period are fetched by the report and would be faster, as a lot of data will be called when Last 12 months is utilized.

Resolution

  1. Go to Business Analytics work center.
  2. Select Design Reports view.
  3. Find report Customer Demand Details (SCMCDU01_Q0001).
  4. Open the report.
  5. Use the relevant filter.
  6. Delete the variable value for Requested Delivery Year/Month or change it for other selection. 
  7. Click Apply. 

Keywords

report, performance, load , KBA , report , performance , load , AP-CR-CR , Customer Requirement , How To

Product

SAP Business ByDesign all versions