SAP Table
SAP CRMD_PRICING Table Business Transaction Pricing Parameter Set
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.
SAP CRMD_PRICING dictionary attributes
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 list of CRMD_PRICING SAP table
.| 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 | |||||
CRMD_PRICING_I - Transaction Item Price
CRMD_PROC_COMP - Process components
CRMD_PROC_COMP_T - Process components text table
CRMD_PRODUCT_I - Transaction Item - Product
CRMD_PSL_PRP_REL - Relationship: Prod. Service Letter and Partner/Prod. Range
CRMD_QUALIF - Qualification Requirement Set
CRMD_READING_H - Counter Item Link Table
CRMD_READING_I - Counter Item Link Table
CRMD_RF_TRACEDB - Test Queries for FS
CRMD_RF_TRACEDBW - Where clauses