SAP S/4Hana table CRMD_PRICING stores Business Transaction Pricing Parameter Setdata

  

So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_PRICING look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana CRMD_PRICING dictionary attributes

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


Field list for CRMD_PRICING table on an S/4 SAP system

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTEST
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
EXCHG_TYPECRMT_EXCHG_TYPECHAR4(0) TCURVExchange Rate TypeKURST
EXCHG_DATECRMT_EXCHG_DATEDATS8(0) Exchange Rate DateCRM_EXCHG_DATE
TAXJURCODECRMT_TAXJURCODECHAR15(0) Tax Jurisdiction Code (Structure for tax calculation)TXJCDCRM_TAX_SH_TAXJURCODETAXJURCODE
CUST_PRIC_PROCCRMT_CUST_PRIC_PROCCHAR2(0) *Customer Pricing ProcedureKALKS
REF_CURRENCYCRMT_REF_CURRENCYCUKY5(0) TCURCReference CurrencyWAERS
ENT_STRATEGYCRMT_ENT_STRATEGYCHAR1(0) Entitlement StrategyCRM_ENT_STRATEGY
CURRENCYCRMT_CURRENCYCUKY5(0) TCURCCurrencyWAERSFWS
PRICE_DATECRMT_PRICE_DATEDATS8(0) Pricing DateCRM_PRICE_DATE
PMNTTRMSCRMT_PMNTTRMSCHAR4(0) Terms of PaymentZTERM
PRICE_GRPCRMT_PRICE_GRPCHAR2(0) T188Customer Price GroupKONDACRM_PRICE_GRPPRICE_GROUP
PRICE_LISTCRMT_PRICE_LISTCHAR2(0) T189Price List TypePLTYPCRM_PRICE_LISTPRICE_LIST
CUST_GROUPCRMT_CUST_GROUPCHAR2(0) T151Customer GroupKDGRP
EXCHG_RATECRMT_EXCHG_RATEDEC9(5) Exchange RateCRM_EXCHG_RATE
TAX_DEST_CTYCRMT_TAX_DEST_CTYCHAR3(0) T005Tax Destination CountryLAND1
TAX_DEST_REGCRMT_REGIONCHAR3(0) *Region (State, Province, County)REGIO
VAT_REG_NOCRMT_VAT_REG_NOCHAR20(0) Sales tax registration number
ETAX_HAND_TYPECRMT_ETAX_HAND_TYPECHAR2(0) *Excise Tax Handling Type (Denotes Use of Material)CRM_ETAX_HAND_TYPE
ETAX_SOURCECRMT_ETAX_SOURCECHAR2(0) *Source of Excise Tax RatesCRM_ETAX_SOURCE
SCORECRMT_SCORECHAR10(0) Result Value of an Internal Creditworthiness CheckCRM_SCORE
GRADEBP_GRADECHAR10(0) *RatingBP_GRADE
AC_INDICATORCRMT_AC_INDICATORCHAR2(0) TBMOTAccounting IndicatorBEMOTCRM_AC_INDAC_INDICATOR
CUSTOMER_TYPECRMT_CUSTOMER_TYPECHAR4(0) *Business Partner TypeBU_KIND
CFOP_CODEITL_CFOPCHAR10(0) COMC_CFOP_CODECFOP Code and ExtensionITL_CFOP
ICMS_TAXLAWITL_TAXLAW1CHAR3(0) COMC_TAX_LAW_1ICMS Tax Law IDITL_TAXLAW1
IPI_TAXLAWITL_TAXLAW2CHAR3(0) COMC_TAX_LAW_2IPI Tax Law IDITL_TAXLAW2
TAX_MAT_USAGETAX_MAT_USAGECHAR1(0) Material UsageTAX_MAT_USAGE
LOC_TAXCATLOC_TAXCATCHAR2(0) CRMC_TAXCATTax CategoryLOC_TAXCAT
LOC_ZEROVATLOC_ZEROVATCHAR1(0) CRMC_ZEROVATReason for Zero-Rated VATLOC_ZEROVAT
LOC_ACTCODELOC_ACTCODECHAR2(0) CRMC_ACTCODEActivity Code for Gross Income TaxLOC_ACTCODE
LOC_DISTTYPELOC_DISTTYPECHAR2(0) CRMC_DISTTYPEDistribution Type for Employment TaxLOC_DISTTYPE
LOC_TXRELCLASLOC_TXRELCLASCHAR10(0) CRMC_TXRELCLASTax Relevance ClassificationLOC_TXRELCLAS
ISS_TAXLAWLOC_TAX_LAW3CHAR3(0) ISS Tax LawLOC_TAX_LAW3
COFINS_TAXLAWLOC_TAX_LAW4CHAR3(0) COFINS Tax LawLOC_TAX_LAW4
PIS_TAXLAWLOC_TAX_LAW5CHAR3(0) PIS Tax LawLOC_TAX_LAW5
PAYMENT_METHODCRMT_BUAG_PAYMETHCHAR1(0) *Payment MethodCRM_BUAG_PAYMETH
SCRAP_VALUECRMT_SPL_SCRAP_VALUECURR10(2) Threshold for Further Action for New Parts
SCRAP_CURRENCYCRMT_SPL_SCRAP_CUKYCUKY5(0) *Currency Key for Reuse Threshold ValueWAERS
SCRAP_INSTR_LOWCRMT_SPL_SCRAP_INSTR_LOWCHAR1(0) Procedure for Values under ThresholdCRM_SPL_SCRAP_INSTRUCTION
SCRAP_INSTR_HIGHCRMT_SPL_SCRAP_INSTR_HIGHCHAR1(0) Procedure for Values over ThresholdCRM_SPL_SCRAP_INSTRUCTION
LOY_MEMS_IDCRM_LOY_MEMS_IDCHAR10(0) Membership IDCRM_LOY_MEMS_ID
LOY_PSH_IDCRM_LOY_PSH_IDCHAR10(0) Partnership IDCRM_LOY_PSH_ID
FUND_EXCHG_TYPECRMT_FUND_EXCHG_TYPECHAR4(0) *Fund Exchange Rate TypeKURST
FUND_EXCHG_DATECRMT_FUND_EXCHG_DATEDATS8(0) Fund Exchange DateCRM_EXCHG_DATE
FUND_EXCHG_RATECRMT_FUND_EXCHG_RATEDEC9(5) Fund Exchange RateCRM_EXCHG_RATE
FUND_EXCHG_R_TGCRMT_FUND_EXCHG_RATEDEC9(5) Fund Exchange RateCRM_EXCHG_RATE
PRICING_DUMMYDUMMYCHAR1(0) Dummy function in length 1DUMMYSAP
TAX_EXEMPT_GUIDCRM_TAX_EXEMPT_HEADER_GUIDRAW16(0) Object Header GUIDSYSUUID
TAX_EXEMPT_IDCRM_TAX_EXEMPT_IDCHAR30(0) Customer Tax Exemption Certificate IDCRM_TAX_EXEMPT_ID
POINT_PMT_INDICCRMT_LOY_POINT_PAYMENTCHAR1(0) Point Payment OptionCRM_LOY_POINT_PAYMENT
POINT_PMT_AMTCRMT_LOY_PMT_AMTDEC10(2) Point Payment Amount - Header
POINT_PMT_PTYPECRMT_LOY_PMT_PTTYPECHAR10(0) Payment Point TypeCRM_MKTPL_LOY_POINT_CODE
PRICING_CONTROLCRMS4_PRICING_CONTROLCHAR1(0) Pricing ControlCRMS4_PRICING_CONTROL
VALID_FROMCRMT_VALID_FROMDEC15(0) Time Dependency: Validity Start DateBCOS_TSTMP
VALID_TOCRMT_VALID_TODEC15(0) Time Dependency: Validity End DateBCOS_TSTMP
TRANS_TIMECRMT_TRANS_TIMEDEC15(0) Time Last Change was MadeBCOS_TSTMP


View list of all S4 Hana tables