Symptom
Request to create index in a SAP CPQ Custom Table.
Environment
SAP SALES CLOUD CPQ
Resolution
A case should be submitted to SAP CPQ Operations Team (component: CEC-SAL-CPQ-OPS) containing the following information:
- Business Impact - Reason and/or business justification explaining the problem and the need for SAP CPQ Custom Table index
- SQL query for index creation - SQL query CREATE INDEX statements which will be executed on target SAP CPQ custom table
- Written approval to execute index creation query.
If you do not have the SQL query for index creation, please provide the following:
- Business Impact - Reason and/or business justification explaining the problem and the need for SAP CPQ Custom Table index
- SQL query(s) whose performance(s) will be improved by index(es) - Listing of working SQL queries targeting SAP CPQ Custom Table which should benefit from indexes
- Listing of involved SAP CPQ Custom Tables - Listing of SAP CPQ custom table names and columns used in provided SQL query examples
- Written approval to execute index creation query.
Please note without mandatory information it will not be possible to proceed with request.
Keywords
Index, Custom Table, Request, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To
Product
SAP CPQ 2023