CRMD_PRICING is a standard SAP Table which is used to store Business Transaction Pricing Parameter Set data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP CRMD_PRICING Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
Dictionary Type: Transparent table
Description: Business Transaction Pricing Parameter Set
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field |
CLIENT | MANDT | CLNT | 3(0) | Assigned to domain | Client | MANDT | TEST | ||||
GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | ||||||
EXCHG_TYPE | CRMT_EXCHG_TYPE | CHAR | 4(0) | TCURV | Exchange Rate Type | KURST | |||||
EXCHG_DATE | CRMT_EXCHG_DATE | DATS | 8(0) | Exchange Rate Date | CRM_EXCHG_DATE | ||||||
TAXJURCODE | CRMT_TAXJURCODE | CHAR | 15(0) | Assigned to domain | Tax Jurisdiction Code (Structure for tax calculation) | TXJCD | CRM_TAX_SH_TAXJURCODE | TAXJURCODE | |||
CUST_PRIC_PROC | CRMT_CUST_PRIC_PROC | CHAR | 1(0) | Assigned to domain | Customer Pricing Procedure | CRM_CUST_PRIC_PROC | |||||
REF_CURRENCY | CRMT_REF_CURRENCY | CUKY | 5(0) | TCURC | Reference Currency | WAERS | |||||
ENT_STRATEGY | CRMT_ENT_STRATEGY | CHAR | 1(0) | Entitlement Strategy | CRM_ENT_STRATEGY | ||||||
CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | TCURC | Currency | WAERS | FWS | ||||
PRICE_DATE | CRMT_PRICE_DATE | DATS | 8(0) | Pricing Date | CRM_PRICE_DATE | ||||||
PMNTTRMS | CRMT_PMNTTRMS | CHAR | 4(0) | Assigned to domain | Terms of Payment | CRM_PMNTTRMS | |||||
PRICE_GRP | CRMT_PRICE_GRP | CHAR | 2(0) | CRMC_PRICEGRP | Customer Price Group | CRM_PRICE_GRP | CRM_PRICE_GRP | PRICE_GROUP | |||
PRICE_LIST | CRMT_PRICE_LIST | CHAR | 2(0) | CRMC_PRICELIST | Price List Type | CRM_PRICE_LIST | CRM_PRICE_LIST | PRICE_LIST | |||
CUST_GROUP | CRMT_CUST_GROUP | CHAR | 2(0) | CRMC_CUSTGRP | Customer Group | CRM_CUST_GROUP | |||||
EXCHG_RATE | CRMT_EXCHG_RATE | DEC | 9(5) | Exchange Rate | EXCRT | CRM_EXCHG_RATE | |||||
TAX_DEST_CTY | CRMT_TAX_DEST_CTY | CHAR | 3(0) | T005 | Tax Destination Country | LAND1 | |||||
TAX_DEST_REG | CRMT_REGION | CHAR | 3(0) | Assigned to domain | Region (State, Province, County) | REGIO | |||||
VAT_REG_NO | CRMT_VAT_REG_NO | CHAR | 20(0) | Sales tax registration number | |||||||
ETAX_HAND_TYPE | CRMT_ETAX_HAND_TYPE | CHAR | 2(0) | Assigned to domain | Excise Tax Handling Type (Denotes Use of Material) | CRM_ETAX_HAND_TYPE | |||||
ETAX_SOURCE | CRMT_ETAX_SOURCE | CHAR | 2(0) | Assigned to domain | Source of Excise Tax Rates | CRM_ETAX_SOURCE | |||||
SCORE | CRMT_SCORE | CHAR | 10(0) | Result Value of an Internal Creditworthiness Check | CRM_SCORE | ||||||
GRADE | BP_GRADE | CHAR | 10(0) | Assigned to domain | Rating | BP_GRADE | |||||
AC_INDICATOR | CRMT_AC_INDICATOR | CHAR | 2(0) | CRMC_AC_IND | Accounting Indicator | CRMT_AC_INDICATOR | |||||
CUSTOMER_TYPE | CRMT_CUSTOMER_TYPE | CHAR | 4(0) | Assigned to domain | Business Partner Type | BU_KIND | |||||
CFOP_CODE | ITL_CFOP | CHAR | 10(0) | COMC_CFOP_CODE | CFOP Code and Extension | CFOBR | ITL_CFOP | ||||
ICMS_TAXLAW | ITL_TAXLAW1 | CHAR | 3(0) | COMC_TAX_LAW_1 | ICMS Tax Law ID | ALPHA | ITL_TAXLAW1 | ||||
IPI_TAXLAW | ITL_TAXLAW2 | CHAR | 3(0) | COMC_TAX_LAW_2 | IPI Tax Law ID | ALPHA | ITL_TAXLAW2 | ||||
TAX_MAT_USAGE | TAX_MAT_USAGE | CHAR | 1(0) | Assigned to domain | Material Usage | TAX_MAT_USAGE | |||||
LOC_TAXCAT | LOC_TAXCAT | CHAR | 2(0) | CRMC_TAXCAT | Tax Category | LOC_TAXCAT | |||||
LOC_ZEROVAT | LOC_ZEROVAT | CHAR | 1(0) | CRMC_ZEROVAT | Reason for Zero-Rated VAT | LOC_ZEROVAT | |||||
LOC_ACTCODE | LOC_ACTCODE | CHAR | 2(0) | CRMC_ACTCODE | Activity Code for Gross Income Tax | LOC_ACTCODE | |||||
LOC_DISTTYPE | LOC_DISTTYPE | CHAR | 2(0) | CRMC_DISTTYPE | Distribution Type for Employment Tax | LOC_DISTTYPE | |||||
LOC_TXRELCLAS | LOC_TXRELCLAS | CHAR | 10(0) | CRMC_TXRELCLAS | Tax Relevance Classification | LOC_TXRELCLAS | |||||
PAYMENT_METHOD | CRMT_BUAG_PAYMETH | CHAR | 1(0) | Assigned to domain | Payment Method | CRM_BUAG_PAYMETH | |||||
SCRAP_VALUE | CRMT_SPL_SCRAP_VALUE | CURR | 10(2) | Threshold for Further Action for New Parts | |||||||
SCRAP_CURRENCY | CRMT_SPL_SCRAP_CUKY | CUKY | 5(0) | Assigned to domain | Currency Key for Reuse Threshold Value | WAERS | |||||
SCRAP_INSTR_LOW | CRMT_SPL_SCRAP_INSTR_LOW | CHAR | 1(0) | Procedure for Values under Threshold | CRM_SPL_SCRAP_INSTRUCTION | ||||||
SCRAP_INSTR_HIGH | CRMT_SPL_SCRAP_INSTR_HIGH | CHAR | 1(0) | Procedure for Values over Threshold | CRM_SPL_SCRAP_INSTRUCTION | ||||||
VALID_FROM | CRMT_VALID_FROM | DEC | 15(0) | Time Dependency: Validity Start Date | TSTPS | BCOS_TSTMP | |||||
VALID_TO | CRMT_VALID_TO | DEC | 15(0) | Time Dependency: Validity End Date | TSTPS | BCOS_TSTMP | |||||
TRANS_TIME | CRMT_TRANS_TIME | DEC | 15(0) | Time Last Change was Made | TSTPS | BCOS_TSTMP |