In this post, I will try and describe everything you need to know about the SAP crmd_pricing table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_PRICING what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_PRICING....Right lets get started!
Object Name: CRMD_PRICING
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 | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| EXCHG_TYPE | CRMT_EXCHG_TYPE | CHAR | 4(0) | TCURV | Exchange Rate Type | KURST | CRM | |||||
| EXCHG_DATE | CRMT_EXCHG_DATE | DATS | 8(0) | Exchange Rate Date | CRM_EXCHG_DATE | CRM | ||||||
| TAXJURCODE | CRMT_TAXJURCODE | CHAR | 15(0) | * | Tax Jurisdiction Code (Structure for tax calculation) | TXJCD | CRM_TAX_SH_TAXJURCODE | TAXJURCODE | CRM | |||
| CUST_PRIC_PROC | CRMT_CUST_PRIC_PROC | CHAR | 1(0) | * | Customer Pricing Procedure | CRM_CUST_PRIC_PROC | CRM | |||||
| REF_CURRENCY | CRMT_REF_CURRENCY | CUKY | 5(0) | TCURC | Reference Currency | WAERS | CRM | |||||
| ENT_STRATEGY | CRMT_ENT_STRATEGY | CHAR | 1(0) | Entitlement Strategy | CRM_ENT_STRATEGY | CRM | ||||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | TCURC | Currency | WAERS | FWS | CRM | ||||
| PRICE_DATE | CRMT_PRICE_DATE | DATS | 8(0) | Pricing Date | CRM_PRICE_DATE | CRM | ||||||
| PMNTTRMS | CRMT_PMNTTRMS | CHAR | 4(0) | * | Terms of Payment | CRM_PMNTTRMS | CRM | |||||
| PRICE_GRP | CRMT_PRICE_GRP | CHAR | 2(0) | CRMC_PRICEGRP | Customer Price Group | CRM_PRICE_GRP | CRM_PRICE_GRP | PRICE_GROUP | CRM | |||
| PRICE_LIST | CRMT_PRICE_LIST | CHAR | 2(0) | CRMC_PRICELIST | Price List Type | CRM_PRICE_LIST | CRM_PRICE_LIST | PRICE_LIST | CRM | |||
| CUST_GROUP | CRMT_CUST_GROUP | CHAR | 2(0) | CRMC_CUSTGRP | Customer Group | CRM_CUST_GROUP | CRM | |||||
| EXCHG_RATE | CRMT_EXCHG_RATE | DEC | 9(5) | Exchange Rate | CRM_EXCHG_RATE | CRM | ||||||
| TAX_DEST_CTY | CRMT_TAX_DEST_CTY | CHAR | 3(0) | T005 | Tax Destination Country | LAND1 | CRM | |||||
| TAX_DEST_REG | CRMT_REGION | CHAR | 3(0) | * | Region (State, Province, County) | REGIO | CRM | |||||
| VAT_REG_NO | CRMT_VAT_REG_NO | CHAR | 20(0) | Sales tax registration number | CRM | |||||||
| ETAX_HAND_TYPE | CRMT_ETAX_HAND_TYPE | CHAR | 2(0) | * | Excise Tax Handling Type (Denotes Use of Material) | CRM_ETAX_HAND_TYPE | CRM | |||||
| ETAX_SOURCE | CRMT_ETAX_SOURCE | CHAR | 2(0) | * | Source of Excise Tax Rates | CRM_ETAX_SOURCE | CRM | |||||
| SCORE | CRMT_SCORE | CHAR | 10(0) | Result Value of an Internal Creditworthiness Check | CRM_SCORE | CRM | ||||||
| GRADE | BP_GRADE | CHAR | 10(0) | * | Rating | BP_GRADE | CRM | |||||
| AC_INDICATOR | CRMT_AC_INDICATOR | CHAR | 2(0) | CRMC_AC_IND | Accounting Indicator | CRMT_AC_INDICATOR | CRM | |||||
| CUSTOMER_TYPE | CRMT_CUSTOMER_TYPE | CHAR | 4(0) | * | Business Partner Type | BU_KIND | CRM | |||||
| CFOP_CODE | ITL_CFOP | CHAR | 10(0) | COMC_CFOP_CODE | CFOP Code and Extension | ITL_CFOP | CRM | |||||
| ICMS_TAXLAW | ITL_TAXLAW1 | CHAR | 3(0) | COMC_TAX_LAW_1 | ICMS Tax Law ID | ITL_TAXLAW1 | CRM | |||||
| IPI_TAXLAW | ITL_TAXLAW2 | CHAR | 3(0) | COMC_TAX_LAW_2 | IPI Tax Law ID | ITL_TAXLAW2 | CRM | |||||
| TAX_MAT_USAGE | TAX_MAT_USAGE | CHAR | 1(0) | * | Material Usage | TAX_MAT_USAGE | CRM | |||||
| LOC_TAXCAT | LOC_TAXCAT | CHAR | 2(0) | CRMC_TAXCAT | Tax Category | LOC_TAXCAT | CRM | |||||
| LOC_ZEROVAT | LOC_ZEROVAT | CHAR | 1(0) | CRMC_ZEROVAT | Reason for Zero-Rated VAT | LOC_ZEROVAT | CRM | |||||
| LOC_ACTCODE | LOC_ACTCODE | CHAR | 2(0) | CRMC_ACTCODE | Activity Code for Gross Income Tax | LOC_ACTCODE | CRM | |||||
| LOC_DISTTYPE | LOC_DISTTYPE | CHAR | 2(0) | CRMC_DISTTYPE | Distribution Type for Employment Tax | LOC_DISTTYPE | CRM | |||||
| LOC_TXRELCLAS | LOC_TXRELCLAS | CHAR | 10(0) | CRMC_TXRELCLAS | Tax Relevance Classification | LOC_TXRELCLAS | CRM | |||||
| PAYMENT_METHOD | CRMT_BUAG_PAYMETH | CHAR | 1(0) | * | Payment Method | CRM_BUAG_PAYMETH | CRM | |||||
| SCRAP_VALUE | CRMT_SPL_SCRAP_VALUE | CURR | 10(2) | Threshold for Further Action for New Parts | CRM | |||||||
| SCRAP_CURRENCY | CRMT_SPL_SCRAP_CUKY | CUKY | 5(0) | * | Currency Key for Reuse Threshold Value | WAERS | CRM | |||||
| SCRAP_INSTR_LOW | CRMT_SPL_SCRAP_INSTR_LOW | CHAR | 1(0) | Procedure for Values under Threshold | CRM_SPL_SCRAP_INSTRUCTION | CRM | ||||||
| SCRAP_INSTR_HIGH | CRMT_SPL_SCRAP_INSTR_HIGH | CHAR | 1(0) | Procedure for Values over Threshold | CRM_SPL_SCRAP_INSTRUCTION | CRM | ||||||
| VALID_FROM | CRMT_VALID_FROM | DEC | 15(0) | Time Dependency: Validity Start Date | BCOS_TSTMP | CRM | ||||||
| VALID_TO | CRMT_VALID_TO | DEC | 15(0) | Time Dependency: Validity End Date | BCOS_TSTMP | CRM | ||||||
| TRANS_TIME | CRMT_TRANS_TIME | DEC | 15(0) | Time Last Change was Made | BCOS_TSTMP | CRM |