SAP Knowledge Base Article - Public

3646533 - Custom table Entries Patch method shifting table entries

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

  1. Create a Custom Table
  2. Send a PATCH request to PATCH <CPQ Tenant URL>/api/custom-table/v1/customTables/{tableName}/entries
  3. 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