Symptom
You have the need to show the historical Note comments of an opportunity in a report face by using the standard data source Opportunity Header and Item (technical ID CODOPPU). However, only the latest note is displayed.
Environment
SAP Cloud for Customer
Reproducing the Issue
You run a report based on the Opportunity Header and Item data source in order to report on a Note description field, however the Note characteristic only shows one entry of this note, in case you have more than one.
Cause
This is the expected behavior, the note in Opportunity Header and Item data source (technical ID CODOPPU) can only take one note for one opportunity.
Resolution
If you want to have all the notes in a data source, you can use another data source for Opportunity Note history: Opportunity Notes (technical ID CODOPPNOTESB).
See Also
In order to see all the notes you need to change the scoping for Opportunity Notes. This information is available in Knowledge Base Article 2696539 - Data Source Opportunity Notes (technical ID CODOPPNOTESB) only shows the latest Note.
Keywords
CODOPPU, Note, notes, historical, opportunity, CODOPPNOTESB, opportunity notes , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-EMP , Employee , How To