SAP Knowledge Base Article - Public

2095706 - Sales Quote Funnel data source shows two copies of the same key Figure - Net Value

Symptom

You want to know why the Sales Quote Funnel data source has two Key Figures with the same name - Net Value.

Reproducing the Issue

  1. Go to Business Analytics Workcenter.
  2. Go to Design Data Sources view.
  3. Search for the Data Source - Sales Quote Funnel
  4. Click on Preview.
  5. Find two copies of the same Key Figure - Net Value.

Cause

Sales Quote Funnel data source is a Combined Data Source of Sales Quote Item data source and Sales Order Item data source.  Hence the view element names have been repeated.  

Resolution

The two Net Value Key Figures correspond to Sales Quote and subsequently the Sales Order values. For those Sales Quotes where a Sales Order is not created, one of the Net Value Key Figures shows 0. The Net Value Key Figures are calculated by summing Total Item Net Value and Freight.

You can verify the values by navigating to the respective Sales Quotes and Sales orders and then by navigating to the Pricing tab. There you can refer to the Total pricing section under which the summation of the Total Item Net Value and Freight gives you the Net Value.

To avoid confusion, you can also re-name the Net value Key Figures as desired by making copies of the existing Net Value Key Figure.  This functionality is available in Business Analytics work center->Design Key Figures->New Key Figure.

Keywords

KBA , AP-SLO-SO , Sales Order , How To

Product

SAP BUSINESS BYDESIGN 1708