SAP Knowledge Base Article - Public

3312241 - SQL Pre Filtering on Quote Visibility is not working

Symptom

SQL Pre filtering is not loading any quote after being set.

Environment

SAP SALES CLOUD CPQ

Reproducing the Issue

  1. On Setup;
  2. Go to Quote Visibility;
  3. Set SQL Join query on sys_QuoteCustomField using as alias qcf;
  4. When opening Other Quotes an error message appears "Could not get the list of Quotes.Please view Log for more details".

Cause

sys_QuoteCustomField alias cannot be qcf, as it is already being used by system.

Resolution

Customer should change alias name of sys_QuoteCustomField table when creating JOIN clause.

See Also

Keywords

Quote Visibility, Quote List, Other Quotes, Quote, Quote 2.0 engine, Visibility, SQL, Pre Filtering, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Bug Filed

Product

SAP CPQ 2023