Symptom
When sending a patch request to <CPQ Tenant URL>/api/custom-table/v1/customTables/{tableName}/entries it can be noted a shift in the values in the Table.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
- Create a Custom Table
- Send a PATCH request to PATCH <CPQ Tenant URL>/api/custom-table/v1/customTables/{tableName}/entries
- Observe that updated values are not the ones intended to change, and a shift has occurred in the table values.
Cause
Expected Behavior.
Resolution
- Issue: PATCH method causing shift in Custom Table during update of values
- Root Cause: Unnecessary spaces in payload are shifting values during patch operation
- Behavior that causes the issue: In current CPQ implementation, during the lookup process (to find the existing entry that matches the combination of keys provided), column values are trimmed before comparing them—so CPQ matches the existing entry regardless of any extra spaces. However, when performing the update, CPQ updates all fields using the exact values from the payload without trimming them. This results in the key column being updated with the space, and since its value now differs from the original (trimmed) version, it appears in the audit trail as changed
- Solution: Review payload in order to fix the issue.
Keywords
Shift, Inconsistency, Custom Table, Entries, Custom Table Entries, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Known Error
Product
SAP CPQ 2024
SAP Knowledge Base Article - Public