SAP S/4Hana table CRMD_PRICING_I stores Transaction Item Pricedata

  

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_I 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_I dictionary attributes

Object Name: CRMD_PRICING_I
Dictionary Type: Transparent table
Description: Transaction Item Price


Field list for CRMD_PRICING_I 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
NET_VALUE_MANCRMT_NET_VALUE_MANCURR15(2) Total Expected Net Value Products in Document CurrencyWERTV8
TARGET_VALUECRMT_TARGET_VALUECURR19(2) Target Value for ContractsWERTV10
COST_AMOUNT_MANCRMT_COST_AMOUNT_MANCURR15(2) Total Expected Cost Amount in Document CurrencyWERTV8
CASHFLOW_TYPECRMT_CASHFLOW_TYPECHAR4(0) Flow CategoryCRMT_CASHFLOW_TYPE
TAX_GROUP_PCRMT_TAX_GROUPCHAR20(0) Product Tax GroupCRM_TAX_GROUP
TAX_GROUP_P_CTYCRMT_TAX_LANDCHAR3(0) *Tax CountryLAND1
TAX_GROUP_P_REGCRMT_TAX_REGIONCHAR3(0) *Tax RegionREGIO
TAX_GROUP_P_TTPCRMT_TAX_TYPECHAR4(0) Tax TypeBUTX_TAX_TYPE
EXPENSE_TYPECRM_FM_FU_EXPENSE_TYPECHAR4(0) Expense TypeCRM_FM_FU_EXPENSE_TYPE
REASONCRMT_CLA_REASONCHAR4(0) *Claim ReasonCRMT_CLA_REASON
LOY_POINT_TYPECRMT_MKTPL_LOY_POINT_CODECHAR10(0) ID of Point TypeCRM_MKTPL_LOY_POINT_CODE
POINTS_SPENTCRMT_LOY_POINTS_SPENTDEC10(2) Loyalty Points Spent
PRICING_I_DUMMYDUMMYCHAR1(0) Dummy function in length 1DUMMYSAP
INV_VER_TAX_CTYCRMT_INV_VERIF_TAX_CTYCHAR3(0) *Invoice Verficitaion Tax Code CountryLAND1
INV_VER_TAX_DIRCRMT_INV_VERIF_TAX_DIRCHAR2(0) Invoice Verification Tax Code DirectionCRM_CLA_TAX_DIRECTION
INV_VER_TAX_CODECRMT_INV_VERIF_TAX_CODECHAR2(0) *Invoice Verification Tax CodeMWSKZ
INV_VER_JUR_CODECRMT_INV_VERIF_TAX_JUR_CODECHAR15(0) *Invoice Verification Tax Jurisdiction CodeTXJCD
PRICE_SOURCEPRICE_SOURCECHAR15(0) Source of price in service confirmationPRICE_SOURCE
TAX_DEPART_CTYCRMT_TAX_DEPART_CTYCHAR3(0) *Tax Departure CountryLAND1
TAX_DEPART_REGCRMT_TAX_DEPART_REGCHAR3(0) *Departure Region for TaxREGIO
TAXJURCODE_FROMCRMT_TAXJURCODECHAR15(0) Tax Jurisdiction Code (Structure for tax calculation)TXJCDCRM_TAX_SH_TAXJURCODETAXJURCODE
TAX_TARIFF_CODECRMT_TAX_TARIFF_CODECHAR16(0) Tax Tariff CodeCHAR16
STATISTICALCRMT_STATISTICALCHAR1(0) Statistical valuesCRM_STATISTICAL
PRC_INDICATORCRMT_PRICING_INDICATORCHAR1(0) Pricing indicatorCRM_PRICING_INDICATOR
NET_VALUECRMT_NET_VALUECURR15(2) Net ValueWERTV8
NET_PRICECRMT_NET_PRICECURR15(2) Net PriceWERTV8
TAX_AMOUNTCRMT_TAX_AMOUNTCURR15(2) Tax amount in document currencyWERTV8
FREIGHTCRMT_FREIGHTCURR15(2) Shipment costs in document currencyWERTV8
GROSS_VALUECRMT_GROSS_VALUECURR15(2) Gross Order Value in PO CurrencyWERTV8
NET_WO_FREIGHTPRCT_NET_VALUE_WITHOUT_FREIGHTCURR15(2) Item Net Value Exclusive ShipmentWERTV8
SUBTOTAL1CRMT_SUBTOTAL1CURR15(2) Subtotal 1 from pricing procedure for conditionWERTV8
SUBTOTAL2CRMT_SUBTOTAL2CURR15(2) Subtotal 2 from pricing procedure for conditionWERTV8
SUBTOTAL3CRMT_SUBTOTAL3CURR15(2) Subtotal 3 from pricing procedure for conditionWERTV8
SUBTOTAL4CRMT_SUBTOTAL4CURR15(2) Subtotal 4 from pricing procedure for conditionWERTV8
SUBTOTAL5CRMT_SUBTOTAL5CURR15(2) Subtotal 5 from pricing procedure for conditionWERTV8
SUBTOTAL6CRMT_SUBTOTAL6CURR15(2) Subtotal 6 from pricing procedure for conditionWERTV8
CREDIT_INDICATORCRMT_CREDIT_INDICATORCHAR1(0) Credit Debit IndicatorCRMT_CREDIT_INDICATOR
NETPR_PRIC_UNITPRCT_COND_PRICING_UNITDEC5(0) Condition Pricing UnitPRC_CONDITION_PRICING_UNITVF
NETPR_UOMPRCT_COND_UOMUNIT3(0) *Condition UnitMEINS
COST_AMOUNTCRMT_COST_AMOUNTCURR15(2) Cost amount in document currencyWERTV8
LOY_POINTSCRM_LOY_PT_POINTDEC10(2) Loyalty Point
PAYMENT_AMOUNTCRMT_PAYMENT_AMOUNTCURR15(2) Payment amount in order currencyWERTV8
RECURRING_CHARGECRMT_RECURRING_CHARGECURR15(2) Periodically charged valuesWERTV8
RECURRING_TAXCRMT_RECURRING_TAXCURR15(2) Periodically charged taxesWERTV8
RECURRING_GROSSCRMT_RECURRING_GROSSCURR15(2) Periodically charged values including taxesWERTV8
REC_DURATIONCRMT_REC_DURATIONDEC13(0) Duration of a recurrence periodTIMEDURA
REC_TIME_UNITCRMT_REC_TIME_UNITCHAR12(0) TIMECUUTTime unit of a recurrence periodTIMEUNITNA
REC_MAIN_ITM_CUMCRMT_REC_MAIN_ITEM_CUMCHAR1(0) Cumulation of recurring charges on main item levelFLAG
TOTAL_DISCOUNTPRCT_COND_VALUECURR15(2) Price Determination: Condition ValueWERTV8


View list of all S4 Hana tables