Symptom
SQL Pre filtering is not loading any quote after being set.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
- On Setup;
- Go to Quote Visibility;
- Set SQL Join query on sys_QuoteCustomField using as alias qcf;
- 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
- Quote visibility - https://help.sap.com/docs/SAP_CPQ/884885f05e6b4c8082254d4d9d63f19b/a4e93dd75a104d1d9e8d4a8217aad67f.html?version=latest
- Prefiltering in Quote Visibility - https://launchpad.support.sap.com/#/notes/0003289566
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