SAP Knowledge Base Article - Public

2596662 - Behaviour of Key Figure Days in Sales Phase

Symptom

You are using the key figure Days in Sales Phase (technical ID: CODOPPU_CKF_04) in a custom or standard report and the values are not fully clear to you.

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics Workcenter.
  2. Go to the Design Reports View.
  3. Show all and search for report Opportunity Analysis (technical ID CODOPPU_Q0018) or any other report based on data source Opportunity Header and Item (technical ID CODOPPU).
  4. Run the report with your selection.
  5. The key figure Days in Sales Phase shows a value that is not clear to you.

Cause

The key figure Days in Sales Phase is based on another key figure Phase Sales Date. When you open the key figure documentation, you will find the formula.

Formula: Days in Sales Phase = Today - Phase Start Time.

When you add key figure Phase Start Time to the report, you will notice that it displays the last date available, so it is the maximum of all dates.

Resolution

This is the expected system behavior and it works as designed.

To avoid any confusion, we would recommend to always use the key figure Days in Sales Phase with an additional characteristic (Opportunity for example).

Keywords

Days in Sales Phase, key Figure, Opportunity, Sales Phase, Sales Date, report, result , KBA , opportunity header and item , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions