Symptom
You would like to create a report to show visits and their follow-up opportunities, however in the Visit data sources (like Visit Header or Visit Details) you can only see the Predecessor Opportunity field.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Data Sources.
- Search for 'Visit Header' and click Preview.
- In the selection, filter for a visit.
- Check available fields in the view; only the characteristic Preceding Opportunity is available, and as the name suggests it only shows preceding opportunities, not follow-up ones.
Cause
The data source Activity BTD Reference can be used for this requirement.
Resolution
You can use this data source on its own or join it with a visit related data source, like Visit Header or Visit Details. The join condition should be set on Activity UUID and Visit.
Then, in the data source preview or the report, you can use the field BTD Reference ID and BTD Reference Role Code to indicate the related document ID and if it's a predecessor or successor.
Keywords
follow up opportunities, follow-up, opps, visits, data source, missing, successor, predecessor, business analytics, reporting, CODACTBTDB, CODAPAVISITHB, CODVISITHB , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-ACT-VST , Visit Planning , How To