3234813 - How to retrieve the "ship to" and "bill to" information when writing a report in the report module.

Symptom

How to retrieve the "ship to" and "bill to" information when writing a report in the report module.

Environment

SAP SALES CLOUD CPQ

Cause

Information of the quote can be found in the CART table but for more detailed information for "BILL TO" and "SHIP TO" of the quote can be found on different tables.

Resolution

In the database table CART, there are 2 columns that reference the "SHIP TO" and "BILL TO" data.

Column "CUSTOMER_ID" is for "Bill To" customer and is referenced in db table "CUSTOMER_INFO" by column "column ID"

Column "SHIP_TO" is for "Ship To" customer role and is referenced in db table "SHIP_TO" by column "SHIP_ID"

Keywords

CART, Database, Scripting, Bill To, Ship To , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To

Product

SAP CPQ 2025