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
- Navigate to Sales
- Go to Opportunities.
- Select and open the desired Opportunity to make changes.
- Proceed to the Changes Tab.
- 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:
Keywords
Opportunity History Data Source, Changes , Custom report, , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem