SAP TABLES | Customer Relationship Management | Business Transactions(CRM-BTX) SAP CRM

CRMD_PRICING SAP Business Transaction Pricing Parameter Set Table








CRMD_PRICING is a standard SAP Table which is used to store Business Transaction Pricing Parameter Set information. This 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 Table CRMD_PRICING and the data within it using relevant SAP 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 containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


Dictionary fields for SAP Table CRMD_PRICING




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDECRMT_OBJECT_KEY One Order: Key Fields
CLIENTMANDTCLNT3
*
Client
GUIDCRMT_OBJECT_GUIDRAW16 GUID of a CRM Order Object
.INCLUDECRMT_PRICING_INT Pricing: Only Internally Determined Fields
EXCHG_TYPECRMT_EXCHG_TYPECHAR4 TCURVExchange Rate Type
EXCHG_DATECRMT_EXCHG_DATEDATS8 Exchange Rate Date
TAXJURCODECRMT_TAXJURCODECHAR15
*
Tax Jurisdiction Code (Structure for tax calculation)
CUST_PRIC_PROCCRMT_CUST_PRIC_PROCCHAR1
*
Customer Pricing Procedure
REF_CURRENCYCRMT_REF_CURRENCYCUKY5 TCURCReference Currency
ENT_STRATEGYCRMT_ENT_STRATEGYCHAR1 Entitlement Strategy
.INCLUDECRMT_PRICING_EXT Pricing: Externally Changeable Fields
CURRENCYCRMT_CURRENCYCUKY5 TCURCCurrency
PRICE_DATECRMT_PRICE_DATEDATS8 Pricing Date
PMNTTRMSCRMT_PMNTTRMSCHAR4
*
Terms of Payment
PRICE_GRPCRMT_PRICE_GRPCHAR2 CRMC_PRICEGRPCustomer Price Group
PRICE_LISTCRMT_PRICE_LISTCHAR2 CRMC_PRICELISTPrice List Type
CUST_GROUPCRMT_CUST_GROUPCHAR2 CRMC_CUSTGRPCustomer Group
EXCHG_RATECRMT_EXCHG_RATEDEC9(5) Exchange RateEXCRT
TAX_DEST_CTYCRMT_TAX_DEST_CTYCHAR3 T005Tax Destination Country
TAX_DEST_REGCRMT_REGIONCHAR3
*
Region (State, Province, County)
VAT_REG_NOCRMT_VAT_REG_NOCHAR20 Sales tax registration number
ETAX_HAND_TYPECRMT_ETAX_HAND_TYPECHAR2
*
Excise Tax Handling Type (Denotes Use of Material)
ETAX_SOURCECRMT_ETAX_SOURCECHAR2
*
Source of Excise Tax Rates
SCORECRMT_SCORECHAR10 Result Value of an Internal Creditworthiness Check
GRADEBP_GRADECHAR10
*
Rating
AC_INDICATORCRMT_AC_INDICATORCHAR2 CRMC_AC_INDAccounting Indicator
CUSTOMER_TYPECRMT_CUSTOMER_TYPECHAR4
*
Business Partner Type
.INCLUDECRMT_PRICING_LOC Pricing Set: Country-specific fields
CFOP_CODEITL_CFOPCHAR10 COMC_CFOP_CODECFOP Code and ExtensionCFOBR
ICMS_TAXLAWITL_TAXLAW1CHAR3 COMC_TAX_LAW_1ICMS Tax Law IDALPHA
IPI_TAXLAWITL_TAXLAW2CHAR3 COMC_TAX_LAW_2IPI Tax Law IDALPHA
TAX_MAT_USAGETAX_MAT_USAGECHAR1
*
Material Usage
LOC_TAXCATLOC_TAXCATCHAR2 CRMC_TAXCATTax Category
LOC_ZEROVATLOC_ZEROVATCHAR1 CRMC_ZEROVATReason for Zero-Rated VAT
LOC_ACTCODELOC_ACTCODECHAR2 CRMC_ACTCODEActivity Code for Gross Income Tax
LOC_DISTTYPELOC_DISTTYPECHAR2 CRMC_DISTTYPEDistribution Type for Employment Tax
LOC_TXRELCLASLOC_TXRELCLASCHAR10 CRMC_TXRELCLASTax Relevance Classification
PAYMENT_METHODCRMT_BUAG_PAYMETHCHAR1
*
Payment Method
SCRAP_VALUECRMT_SPL_SCRAP_VALUECURR10(2) Threshold for Further Action for New Parts
SCRAP_CURRENCYCRMT_SPL_SCRAP_CUKYCUKY5
*
Currency Key for Reuse Threshold Value

SCRAP_INSTR_LOWCRMT_SPL_SCRAP_INSTR_LOWCHAR1 Procedure for Values under Threshold
SCRAP_INSTR_HIGHCRMT_SPL_SCRAP_INSTR_HIGHCHAR1 Procedure for Values over Threshold
.INCLUDECRMT_TIME_DEP One Contract : Time Dependency
VALID_FROMCRMT_VALID_FROMDEC15 Time Dependency: Validity Start DateTSTPS
VALID_TOCRMT_VALID_TODEC15 Time Dependency: Validity End DateTSTPS
TRANS_TIMECRMT_TRANS_TIMEDEC15 Time Last Change was MadeTSTPS


Key field
Non-key field