SAP Knowledge Base Article - Public

3219855 - Inconsistent Sales Quote ID and Preceding Opportunity ID Displayed in Sales Quote Item Data Source [CRMCQTIB]

Symptom

In a scenario where you wish to display Sales Quote IDs and Preceding Opportunity IDs in the Sales Quote Item Data Source, some data is shown as '#' instead of the expected value.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Open the Design Reports view.
  3. Search for Data Source 'Sales Quote Item'.
  4. Highlight it and click on Preview 
  5. Under Selection, filter by Sales Quote IDs ABC, DEF and GHI (Where ABC, DEF and GHI represent IDs of multiple Sales Quotes).
  6. Under View, remove the fields from the Columns and add fields 'Sales Quote' and 'Preceding Opportunity'.
  7. Run the Report.

 You see that some of the IDs are displayed correctly, but others are displayed as '#' (For both Sales Quote IDs and Preceding Opportunity IDs).

 The same is also true if filtering by Preceding Opportunity ID instead of Sales Quote ID.

Cause

This is how the system checks the IDs in this Data Source:

  1. First, the system takes the Sales Quote Items and checks for Opportunities which are linked to that item.
  2. Then, the system checks if the Sales Quote itself is consistent.
  3. If the items have no reference to the Opportunity, the Data Source will show the ID as '#'.

 So, we have 3 cases where the ID will be shown as '#':

  • If the Sales Quotes have no items that reference an Opportunity.
  • If the Sales Quote has no items.
  • If the Sales Quote is inconsistent.

 This happens because the Data Source is based on the Sales Quote Items, and not the Sales Quote itself. 

Resolution

  This is the expected system behaviour.

Keywords

Sales Quote; Item; Preceding; Data Source; CRMCQTIB; Opportunity; Inconsistent; Not Showing; Not available; Pound; Hashtag , KBA , SRD-CRM-QUO , Quotations , How To

Product

SAP Business ByDesign all versions