SAP Knowledge Base Article - Public

2938156 - How to Show Follow-Up Opportunities to Visits in Reporting

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

  1. Go to the work center Business Analytics and the view Design Data Sources.
  2. Search for 'Visit Header' and click Preview. 
  3. In the selection, filter for a visit. 
  4. 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

Product

SAP Cloud for Customer core applications all versions