The CRMR_PRICING table in SAP ERP or S/4HANA stores Data for Pricing data. There are total 34 fields in CRMR_PRICING table. The Data for Pricing 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 CRMR_PRICING table. It is in Pricing-Relevant Data from CRM Document (Pricing Set) (CRM_PRICING) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CRMR_PRICING Table Fields
Following is the list of fields that are available in SAP CRMR_PRICING 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) | |
| REF_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| VALID_FROM | Time Dependency: Validity Start Date | CRMT_VALID_FROM | DEC (15) | |
| VALID_TO | Time Dependency: Validity End Date | CRMT_VALID_TO | DEC (15) | |
| TRANS_TIME | Time Last Change was Made | CRMT_TRANS_TIME | DEC (15) | |
| EXCHG_TYPE | Exchange Rate Type | CRMT_EXCHG_TYPE | TCURV | CHAR (4) |
| EXCHG_DATE | Exchange Rate Date | CRMT_EXCHG_DATE | DATS (8) | |
| TAXJURCODE | Tax Jurisdiction Code (Structure for tax calculation) | CRMT_TAXJURCODE | CHAR (15) | |
| CUST_PRIC_PROC | Customer Pricing Procedure | CRMT_CUST_PRIC_PROC | * | CHAR (2) |
| REF_CURRENCY | Reference Currency | CRMT_REF_CURRENCY | TCURC | CUKY (5) |
| ENT_STRATEGY | Entitlement Strategy | CRMT_ENT_STRATEGY | CHAR (1) | |
| CURRENCY | Currency | CRMT_CURRENCY | TCURC | CUKY (5) |
| PRICE_DATE | Pricing Date | CRMT_PRICE_DATE | DATS (8) | |
| PMNTTRMS | Terms of Payment | CRMT_PMNTTRMS | CHAR (4) | |
| PRICE_GRP | Customer Price Group | CRMT_PRICE_GRP | T188 | CHAR (2) |
| PRICE_LIST | Price List Type | CRMT_PRICE_LIST | T189 | CHAR (2) |
| CUST_GROUP | Customer Group | CRMT_CUST_GROUP | T151 | CHAR (2) |
| EXCHG_RATE | Exchange Rate | CRMT_EXCHG_RATE | DEC (9) | |
| TAX_DEST_CTY | Tax Destination Country | CRMT_TAX_DEST_CTY | T005 | CHAR (3) |
| TAX_DEST_REG | Region (State, Province, County) | CRMT_REGION | * | CHAR (3) |
| ETAX_HAND_TYPE | Excise Tax Handling Type (Denotes Use of Material) | CRMT_ETAX_HAND_TYPE | * | CHAR (2) |
| ETAX_SOURCE | Source of Excise Tax Rates | CRMT_ETAX_SOURCE | * | CHAR (2) |
| SCORE | Result Value of an Internal Creditworthiness Check | CRMT_SCORE | CHAR (10) | |
| GRADE | Rating | BP_GRADE | * | CHAR (10) |
| AC_INDICATOR | Accounting Indicator | CRMT_AC_INDICATOR | TBMOT | CHAR (2) |
| CUSTOMER_TYPE | Business Partner Type | CRMT_CUSTOMER_TYPE | * | CHAR (4) |
| CFOP_CODE | Text (10 Characters) | TEXT10 | * | CHAR (10) |
| PAYMENT_METHOD | Payment Method | CRMT_BUAG_PAYMETH | * | CHAR (1) |
| SCRAP_CURRENCY | Currency Key for Reuse Threshold Value | CRMT_SPL_SCRAP_CUKY | * | CUKY (5) |
| SCRAP_INSTR_LOW | Procedure for Values under Threshold | CRMT_SPL_SCRAP_INSTR_LOW | CHAR (1) | |
| SCRAP_INSTR_HIGH | Procedure for Values over Threshold | CRMT_SPL_SCRAP_INSTR_HIGH | CHAR (1) | |
| PRICING_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| PRICING_CONTROL | Pricing Control | CRMS4_PRICING_CONTROL | CHAR (1) |
