CRMD_PRICING - Business Transaction Pricing Parameter Set

Business Transaction Pricing Parameter Set information is stored in SAP table CRMD_PRICING.
It is part of development package CRM_PRICING in software component CRM-BTX. This development package consists of objects that can be grouped under "Pricing-Relevant Data from CRM Document (Pricing Set)".

Fields for table CRMD_PRICING

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXCRMT_OBJECT_KEY0
CLIENTClientXMANDTCLNT6*
GUIDGUID of a CRM Order ObjectXCRMT_OBJECT_GUIDRAW16
.INCLUDECRMT_PRICING_INT0
EXCHG_TYPEExchange Rate TypeCRMT_EXCHG_TYPECHAR8TCURV
EXCHG_DATEExchange Rate DateCRMT_EXCHG_DATEDATS16
TAXJURCODETax Jurisdiction Code (Structure for tax calculation)CRMT_TAXJURCODECHAR30*
CUST_PRIC_PROCCustomer Pricing ProcedureCRMT_CUST_PRIC_PROCCHAR4*
REF_CURRENCYReference CurrencyCRMT_REF_CURRENCYCUKY10TCURC
ENT_STRATEGYEntitlement StrategyCRMT_ENT_STRATEGYCHAR2
.INCLUDECRMT_PRICING_EXT0
CURRENCYCurrencyCRMT_CURRENCYCUKY10TCURC
PRICE_DATEPricing DateCRMT_PRICE_DATEDATS16
PMNTTRMSTerms of PaymentCRMT_PMNTTRMSCHAR8
PRICE_GRPCustomer Price GroupCRMT_PRICE_GRPCHAR4T188
PRICE_LISTPrice List TypeCRMT_PRICE_LISTCHAR4T189
CUST_GROUPCustomer GroupCRMT_CUST_GROUPCHAR4T151
EXCHG_RATEExchange RateCRMT_EXCHG_RATEDEC5
TAX_DEST_CTYTax Destination Country/RegionCRMT_TAX_DEST_CTYCHAR6T005
TAX_DEST_REGRegion (State, Province, County)CRMT_REGIONCHAR6*
VAT_REG_NOSales tax registration numberCRMT_VAT_REG_NOCHAR40
ETAX_HAND_TYPEExcise Tax Handling Type (Denotes Use of Material)CRMT_ETAX_HAND_TYPECHAR4*
ETAX_SOURCESource of Excise Tax RatesCRMT_ETAX_SOURCECHAR4*
SCOREResult Value of an Internal Creditworthiness CheckCRMT_SCORECHAR20
GRADERatingBP_GRADECHAR20*
AC_INDICATORAccounting IndicatorCRMT_AC_INDICATORCHAR4TBMOT
CUSTOMER_TYPEBusiness Partner TypeCRMT_CUSTOMER_TYPECHAR8*
.INCLUDECRMT_PRICING_LOC0
CFOP_CODEText (10 Characters)TEXT10CHAR20*
ICMS_TAXLAWICMS Tax Law IDCHAR6
IPI_TAXLAWIPI Tax Law IDCHAR6
TAX_MAT_USAGEMaterial UsageCHAR2
LOC_TAXCATTax CategoryLOC_TAXCATCHAR4*
LOC_ZEROVATReason for Zero-Rated VATLOC_ZEROVATCHAR2*
LOC_ACTCODEActivity Code for Gross Income TaxCHAR4
LOC_DISTTYPEDistribution Type for Employment TaxCHAR4
LOC_TXRELCLASTax Relevance ClassificationLOC_TXRELCLASCHAR20*
ISS_TAXLAWISS Tax LawCHAR6
COFINS_TAXLAWCOFINS Tax LawCHAR6
PIS_TAXLAWPIS Tax LawCHAR6
PAYMENT_METHODPayment MethodCRMT_BUAG_PAYMETHCHAR2*
SCRAP_VALUEObsolete (Threshold for Further Action for New Parts)CURR6
SCRAP_CURRENCYObsolete (Currency Key for Reuse Threshold Value)CUKY10
SCRAP_INSTR_LOWObsolete (Procedure for Values under Threshold)CHAR2
SCRAP_INSTR_HIGHObsolete (Procedure for Values over Threshold)CHAR2
LOY_MEMS_IDMembership IDCHAR20
LOY_PSH_IDPartnership IDCHAR20
FUND_EXCHG_TYPEFund Exchange Rate Type(OBSOLETE)CHAR8
FUND_EXCHG_DATEFund Exchange Date(OBSOLETE)DATS16
FUND_EXCHG_RATEFund Exchange Rate(OBSOLETE)DEC5
FUND_EXCHG_R_TGFund Exchange Rate(OBSOLETE)DEC5
.INCLUDEINCL_EEW_PRICING0
PRICING_DUMMYDummy function in length 1DUMMYCHAR2
.INCLUDECI_EEW_PRICING0
TAX_EXEMPT_GUIDObject Header GUIDRAW16
TAX_EXEMPT_IDCustomer Tax Exemption Certificate IDCHAR60
POINT_PMT_INDICCHAR2
POINT_PMT_AMTDEC6
POINT_PMT_PTYPECHAR20
PRICING_CONTROLPricing ControlCRMS4_PRICING_CONTROLCHAR2
.INCLUDECRMT_TIME_DEP0
VALID_FROMTime Dependency: Validity Start DateCRMT_VALID_FROMDEC8
VALID_TOTime Dependency: Validity End DateCRMT_VALID_TODEC8
TRANS_TIMETime Last Change was MadeCRMT_TRANS_TIMEDEC8
Privacy Policy