The CRMD_PRICING_I table in SAP ERP or S/4HANA stores Transaction Item Price data. There are total 44 fields in CRMD_PRICING_I table. The Transaction Item Price 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 CRMD_PRICING_I table. It is in Pricing Results (CRM_PRICING_I) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CRMD_PRICING_I Table Fields
Following is the list of fields that are available in SAP CRMD_PRICING_I table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| 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) | |
| COST_AMOUNT_MAN | Total Expected Cost Amount in Document Currency | CRMT_COST_AMOUNT_MAN | CURR (15) | |
| CASHFLOW_TYPE | Flow Category | CRMT_CASHFLOW_TYPE | CHAR (4) | |
| TAX_GROUP_P | Product Tax Group | CRMT_TAX_GROUP | CHAR (20) | |
| TAX_GROUP_P_TTP | Tax Type | CRMT_TAX_TYPE | CHAR (4) | |
| LOY_POINT_TYPE | ID of Point Type | CRMT_MKTPL_LOY_POINT_CODE | CHAR (10) | |
| PRICING_I_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| INV_VER_TAX_CTY | Invoice Verficitaion Tax Code Country | CRMT_INV_VERIF_TAX_CTY | * | CHAR (3) |
| INV_VER_TAX_CODE | Invoice Verification Tax Code | CRMT_INV_VERIF_TAX_CODE | * | CHAR (2) |
| INV_VER_JUR_CODE | Invoice Verification Tax Jurisdiction Code | CRMT_INV_VERIF_TAX_JUR_CODE | * | CHAR (15) |
| PRICE_SOURCE | Source of price in service confirmation | PRICE_SOURCE | CHAR (15) | |
| 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_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) | |
| NETPR_PRIC_UNIT | Condition Pricing Unit | PRCT_COND_PRICING_UNIT | DEC (5) | |
| NETPR_UOM | Condition Unit | PRCT_COND_UOM | * | UNIT (3) |
| COST_AMOUNT | Cost amount in document currency | CRMT_COST_AMOUNT | CURR (15) | |
| PAYMENT_AMOUNT | Payment amount in order currency | CRMT_PAYMENT_AMOUNT | CURR (15) | |
| RECURRING_CHARGE | Periodically charged values | CRMT_RECURRING_CHARGE | CURR (15) | |
| RECURRING_TAX | Periodically charged taxes | CRMT_RECURRING_TAX | CURR (15) | |
| RECURRING_GROSS | Periodically charged values including taxes | CRMT_RECURRING_GROSS | CURR (15) | |
| REC_DURATION | Duration of a recurrence period | CRMT_REC_DURATION | DEC (13) | |
| REC_TIME_UNIT | Time unit of a recurrence period | CRMT_REC_TIME_UNIT | TIMECUUT | CHAR (12) |
| REC_MAIN_ITM_CUM | Cumulation of recurring charges on main item level | CRMT_REC_MAIN_ITEM_CUM | CHAR (1) | |
| TOTAL_DISCOUNT | Price Determination: Condition Value | PRCT_COND_VALUE | CURR (15) |
