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 |