SAP Knowledge Base Article - Public

3537548 - Missing info in DS Opportunity history

Symptom

"Changed on" date in Opportunity History Data Source is not showing all changes from Opportunity OWL

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Navigate to Sales
  2. Go to Opportunities.
  3. Select and open the desired Opportunity to make changes.
  4. Proceed to the Changes Tab.
  5. Note that numerous changes are displayed along with the "Change On" date.

    AND

    1. Navigate to the Data Analytics 
    2. Locate and open the Opportunity Data Source
    3. Find and select 'Opportunity History [CODOPPHHB]'
    4. Attempt to create a new custom report that displays the "changed on" date for a specific field, such as "Opportunity Sales Phase".
    5. Notice that the "changed on" date is constantly being overwritten by any changes made at the opportunity level.
    6. Observe the discrepancy between the Opportunity History Data Source and the opportunity details in the OWL, where all changes and their respective "changed on" dates can be seen in the "changes" tab.
    7. Question why the same structured table or behavior is not retrievable in the dedicated Data Source.

Cause

Expected System Behavior

Resolution

The field "Changed On" will always show the latest change date of each opportunity in the data source Opportunity History. This is not an issue but the design of the data source instead. The Opportunity History is a data source designed to display historical information about an opportunity’s quantities and values. For example: Sales Phase, Status, Item Total Value, Expected Value, Chance of Success. The data is stored for a validity period, based on date the change was made.

We respect your requirement of showing all the dates where a change was done in the opportunities, and you can submit this as a new enhancement request via one of our channels dedicated to new project requirements. We will list below a few channels you can approach to address your requirement properly. The Continuous Influence channel. Through this channel, you can request the new features for the new releases of the system:

https://influence.sap.com/sap/ino/#/campaign/1868

Keywords

Opportunity History Data Source, Changes , Custom report,  , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer core applications 2411