SAP Table CRMD_PRICING stores Business Transaction Pricing Parameter Setdata

  

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!


SAP CRMD_PRICING dictionary attributes

Object Name: CRMD_PRICING
Dictionary Type: Transparent table
Description: Business Transaction Pricing Parameter Set


CRMD_PRICING field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
EXCHG_TYPECRMT_EXCHG_TYPECHAR4(0) TCURVExchange Rate TypeKURSTCRM
EXCHG_DATECRMT_EXCHG_DATEDATS8(0) Exchange Rate DateCRM_EXCHG_DATECRM
TAXJURCODECRMT_TAXJURCODECHAR15(0) *Tax Jurisdiction Code (Structure for tax calculation)TXJCDCRM_TAX_SH_TAXJURCODETAXJURCODECRM
CUST_PRIC_PROCCRMT_CUST_PRIC_PROCCHAR1(0) *Customer Pricing ProcedureCRM_CUST_PRIC_PROCCRM
REF_CURRENCYCRMT_REF_CURRENCYCUKY5(0) TCURCReference CurrencyWAERSCRM
ENT_STRATEGYCRMT_ENT_STRATEGYCHAR1(0) Entitlement StrategyCRM_ENT_STRATEGYCRM
CURRENCYCRMT_CURRENCYCUKY5(0) TCURCCurrencyWAERSFWSCRM
PRICE_DATECRMT_PRICE_DATEDATS8(0) Pricing DateCRM_PRICE_DATECRM
PMNTTRMSCRMT_PMNTTRMSCHAR4(0) *Terms of PaymentCRM_PMNTTRMSCRM
PRICE_GRPCRMT_PRICE_GRPCHAR2(0) CRMC_PRICEGRPCustomer Price GroupCRM_PRICE_GRPCRM_PRICE_GRPPRICE_GROUPCRM
PRICE_LISTCRMT_PRICE_LISTCHAR2(0) CRMC_PRICELISTPrice List TypeCRM_PRICE_LISTCRM_PRICE_LISTPRICE_LISTCRM
CUST_GROUPCRMT_CUST_GROUPCHAR2(0) CRMC_CUSTGRPCustomer GroupCRM_CUST_GROUPCRM
EXCHG_RATECRMT_EXCHG_RATEDEC9(5) Exchange RateCRM_EXCHG_RATECRM
TAX_DEST_CTYCRMT_TAX_DEST_CTYCHAR3(0) T005Tax Destination CountryLAND1CRM
TAX_DEST_REGCRMT_REGIONCHAR3(0) *Region (State, Province, County)REGIOCRM
VAT_REG_NOCRMT_VAT_REG_NOCHAR20(0) Sales tax registration numberCRM
ETAX_HAND_TYPECRMT_ETAX_HAND_TYPECHAR2(0) *Excise Tax Handling Type (Denotes Use of Material)CRM_ETAX_HAND_TYPECRM
ETAX_SOURCECRMT_ETAX_SOURCECHAR2(0) *Source of Excise Tax RatesCRM_ETAX_SOURCECRM
SCORECRMT_SCORECHAR10(0) Result Value of an Internal Creditworthiness CheckCRM_SCORECRM
GRADEBP_GRADECHAR10(0) *RatingBP_GRADECRM
AC_INDICATORCRMT_AC_INDICATORCHAR2(0) CRMC_AC_INDAccounting IndicatorCRMT_AC_INDICATORCRM
CUSTOMER_TYPECRMT_CUSTOMER_TYPECHAR4(0) *Business Partner TypeBU_KINDCRM
CFOP_CODEITL_CFOPCHAR10(0) COMC_CFOP_CODECFOP Code and ExtensionITL_CFOPCRM
ICMS_TAXLAWITL_TAXLAW1CHAR3(0) COMC_TAX_LAW_1ICMS Tax Law IDITL_TAXLAW1CRM
IPI_TAXLAWITL_TAXLAW2CHAR3(0) COMC_TAX_LAW_2IPI Tax Law IDITL_TAXLAW2CRM
TAX_MAT_USAGETAX_MAT_USAGECHAR1(0) *Material UsageTAX_MAT_USAGECRM
LOC_TAXCATLOC_TAXCATCHAR2(0) CRMC_TAXCATTax CategoryLOC_TAXCATCRM
LOC_ZEROVATLOC_ZEROVATCHAR1(0) CRMC_ZEROVATReason for Zero-Rated VATLOC_ZEROVATCRM
LOC_ACTCODELOC_ACTCODECHAR2(0) CRMC_ACTCODEActivity Code for Gross Income TaxLOC_ACTCODECRM
LOC_DISTTYPELOC_DISTTYPECHAR2(0) CRMC_DISTTYPEDistribution Type for Employment TaxLOC_DISTTYPECRM
LOC_TXRELCLASLOC_TXRELCLASCHAR10(0) CRMC_TXRELCLASTax Relevance ClassificationLOC_TXRELCLASCRM
PAYMENT_METHODCRMT_BUAG_PAYMETHCHAR1(0) *Payment MethodCRM_BUAG_PAYMETHCRM
SCRAP_VALUECRMT_SPL_SCRAP_VALUECURR10(2) Threshold for Further Action for New PartsCRM
SCRAP_CURRENCYCRMT_SPL_SCRAP_CUKYCUKY5(0) *Currency Key for Reuse Threshold ValueWAERSCRM
SCRAP_INSTR_LOWCRMT_SPL_SCRAP_INSTR_LOWCHAR1(0) Procedure for Values under ThresholdCRM_SPL_SCRAP_INSTRUCTIONCRM
SCRAP_INSTR_HIGHCRMT_SPL_SCRAP_INSTR_HIGHCHAR1(0) Procedure for Values over ThresholdCRM_SPL_SCRAP_INSTRUCTIONCRM
VALID_FROMCRMT_VALID_FROMDEC15(0) Time Dependency: Validity Start DateBCOS_TSTMPCRM
VALID_TOCRMT_VALID_TODEC15(0) Time Dependency: Validity End DateBCOS_TSTMPCRM
TRANS_TIMECRMT_TRANS_TIMEDEC15(0) Time Last Change was MadeBCOS_TSTMPCRM


View list of all tables