The CDBD_PRICING_I table in SAP ERP or S/4HANA stores Business transaction item – pricing result data. There are total 32 fields in CDBD_PRICING_I table. The Business transaction item – pricing result table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CDBD_PRICING_I table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_PRICING_I Table Fields
Following is the list of fields that are available in SAP CDBD_PRICING_I table. The primary key fields of Business transaction item – pricing result table in SAP are CLIENT (Client), PRICING_I_GUID (Character field, length 32).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PRICING_I_GUID | Character field, length 32 | CHAR32 | CHAR (32) | |
| ORDERADM_I_GUID | Character field, length 32 | CHAR32 | CHAR (32) | |
| NET_VALUE_MAN | Total Expected Net Value Products in Document Currency | CRMT_NET_VALUE_MAN | CURR (15) | |
| TARGET_VALUE | Target Value for Contracts | CRMT_TARGET_VALUE | CURR (19) | |
| CASHFLOW_TYPE | Flow Category | CRMT_CASHFLOW_TYPE | CHAR (4) | |
| TAX_DEPART_CTY | Tax Departure Country | CRMT_TAX_DEPART_CTY | CHAR (3) | |
| TAX_DEPART_REG | Departure Region for Tax | CRMT_TAX_DEPART_REG | CHAR (3) | |
| TAXJURCODE_FROM | Tax Jurisdiction Code (Structure for tax calculation) | CRMT_TAXJURCODE | CHAR (15) | |
| TAX_GROUP_P | Product Tax Group | CRMT_TAX_GROUP | CHAR (20) | |
| TAX_TARIFF_CODE | Tax Tariff Code | CRMT_TAX_TARIFF_CODE | CHAR (16) | |
| STATISTICAL | Statistical values | CRMT_STATISTICAL | CHAR (1) | |
| PRC_INDICATOR | Pricing indicator | CRMT_PRICING_INDICATOR | CHAR (1) | |
| NET_VALUE | Net Value | CRMT_NET_VALUE | CURR (15) | |
| NET_PRICE | Net Price | CRMT_NET_PRICE | CURR (15) | |
| TAX_AMOUNT | Tax amount in document currency | CRMT_TAX_AMOUNT | CURR (15) | |
| FREIGHT | Shipment costs in document currency | CRMT_FREIGHT | CURR (15) | |
| GROSS_VALUE | Gross Order Value in PO Currency | CRMT_GROSS_VALUE | CURR (15) | |
| NET_WO_FREIGHT | Item Net Value Exclusive Shipment | PRCT_NET_VALUE_WITHOUT_FREIGHT | CURR (15) | |
| SUBTOTAL1 | Subtotal 1 from pricing procedure for condition | CRMT_SUBTOTAL1 | CURR (15) | |
| SUBTOTAL2 | Subtotal 2 from pricing procedure for condition | CRMT_SUBTOTAL2 | CURR (15) | |
| SUBTOTAL3 | Subtotal 3 from pricing procedure for condition | CRMT_SUBTOTAL3 | CURR (15) | |
| SUBTOTAL4 | Subtotal 4 from pricing procedure for condition | CRMT_SUBTOTAL4 | CURR (15) | |
| SUBTOTAL5 | Subtotal 5 from pricing procedure for condition | CRMT_SUBTOTAL5 | CURR (15) | |
| SUBTOTAL6 | Subtotal 6 from pricing procedure for condition | CRMT_SUBTOTAL6 | CURR (15) | |
| CREDIT_INDICATOR | Credit Debit Indicator | CRMT_CREDIT_INDICATOR | CHAR (1) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
