SAP Knowledge Base Article - Public

3503157 - Item Total Value Displayed as Zero for the Opportunity Volume Extended Report

Symptom

The Opportunity Volume Extended Report shows the Item Total Value as zero for the Opportunity Line Item.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics Work Center.
  2. Go into the Design Reports View.
  3. Filter for All.
  4. Search for the report Opportunity Value Extended (Report ID CRMOPPU01_Q0001).
  5. Open the report.
  6. On Selection Tab, delete all fields (except Display Currency, which is mandatory).
  7. Click on the Additional Filters button.
  8. Filter for the Opportunity ID XYZ. (Where XYZ represents the Opportunity ID)
  9. Click on Apply.

The Line Item Total Value is shown as zero (0), even though there is an Item Value maintained for it in the Opportunity document.

Cause

Opportunity Line Items do not have the "Item Total Value" parameter, but the "Item Value" parameter, which is a different component.

On the report, the "Item Total Value" means the sum of all Opportunity Line Items Value. For this reason, it is zero (0.00) for the Line Items.

If each Line Item value is desired on the report, the "Item Value" Row Field must be added.

Resolution

On the report, to add the "Item Value" field, follow the below steps:

  1. Go to the Business Analytics Work Center.
  2. Go into the Design Reports View.
  3. Filter for All.
  4. Search for the report Opportunity Value Extended (Report ID CRMOPPU01_Q0001).
  5. Open the report.
  6. Go to the View Tab.
  7. On the Row Fields Sub Tab, click the + (plus) simbol to add row.
  8. Search for "Item Value" on the search bar.
  9. On the Opportunity Item section, mark the displayed Item Value checkbox. 
  10. Click Ok.

Now, each Line Item Value is displayed on the report.

Keywords

item value, opportunity, report, line item, item, zero, not displayed, not shown, byd, volume extended, business analytics , KBA , SRD-CRM-ORD , Orders & Contracts , How To

Product

SAP Business ByDesign all versions