SAP Knowledge Base Article - Public

3292029 - Create index on CPQ custom table

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:

  1. Business Impact - Reason and/or business justification explaining the problem and the need for SAP CPQ Custom Table index
  2. SQL query for index creation - SQL query CREATE INDEX statements which will be executed on target SAP CPQ custom table
  3. Written approval to execute index creation query.

If you do not have the SQL query for index creation, please provide the following:

  1. Business Impact - Reason and/or business justification explaining the problem and the need for SAP CPQ Custom Table index
  2. 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
  3. Listing of involved SAP CPQ Custom Tables - Listing of SAP CPQ custom table names and columns used in provided SQL query examples
  4. 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