CRMD_PRICING_I - Transaction Item Price

Transaction Item Price information is stored in SAP table CRMD_PRICING_I.
It is part of development package CRM_PRICING_I in software component CRM-BTX. This development package consists of objects that can be grouped under "Pricing Results".

Fields for table CRMD_PRICING_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMT_OBJECT_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID	GUID of a CRM Order Object	X	CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_PRICING_I_EXT	0
NET_VALUE_MAN	Total Expected Net Value Products in Document Currency		CRMT_NET_VALUE_MAN	CURR	8
TARGET_VALUE	Target Value for Contracts		CRMT_TARGET_VALUE	CURR	10
COST_AMOUNT_MAN	Total Expected Cost Amount in Document Currency		CRMT_COST_AMOUNT_MAN	CURR	8
CASHFLOW_TYPE	Flow Category		CRMT_CASHFLOW_TYPE	CHAR	8
TAX_GROUP_P	Product Tax Group		CRMT_TAX_GROUP	CHAR	40
TAX_GROUP_P_CTY	Tax Country			CHAR	6
TAX_GROUP_P_REG	Tax Region			CHAR	6
TAX_GROUP_P_TTP	Tax Type		CRMT_TAX_TYPE	CHAR	8
EXPENSE_TYPE	Expense Type		CRM_FM_FU_EXPENSE_TYPE	CHAR	8
REASON	Claim Reason(OBSOLETE)			CHAR	8
LOY_POINT_TYPE	ID of Point Type		CRMT_MKTPL_LOY_POINT_CODE	CHAR	20
POINTS_SPENT				DEC	6
.INCLUDE				INCL_EEW_PRICING_I	0
PRICING_I_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_EEW_PRICING_I	0
INV_VER_TAX_CTY	Invoice Verficitaion Tax Code Country/Region		CRMT_INV_VERIF_TAX_CTY	CHAR	6	*
INV_VER_TAX_DIR	Invoice Verification Tax Code Direction		CRMT_INV_VERIF_TAX_DIR	CHAR	4
INV_VER_TAX_CODE	Invoice Verification Tax Code		CRMT_INV_VERIF_TAX_CODE	CHAR	4	*
INV_VER_JUR_CODE	Invoice Verification Tax Jurisdiction Code		CRMT_INV_VERIF_TAX_JUR_CODE	CHAR	30	*
PRICE_SOURCE	Source of price in service confirmation		PRICE_SOURCE	CHAR	30
.INCLUDE				CRMT_PRICING_I_INT	0
TAX_DEPART_CTY	Tax Departure Country		CRMT_TAX_DEPART_CTY	CHAR	6	*
TAX_DEPART_REG	Departure Region for Tax		CRMT_TAX_DEPART_REG	CHAR	6	*
TAXJURCODE_FROM	Tax Jurisdiction Code (Structure for tax calculation)		CRMT_TAXJURCODE	CHAR	30	*
TAX_TARIFF_CODE	Tax Tariff Code		CRMT_TAX_TARIFF_CODE	CHAR	32
STATISTICAL	Statistical values		CRMT_STATISTICAL	CHAR	2
PRC_INDICATOR	Pricing indicator		CRMT_PRICING_INDICATOR	CHAR	2
NET_VALUE	Net Value		CRMT_NET_VALUE	CURR	8
NET_PRICE	Net Price		CRMT_NET_PRICE	CURR	8
TAX_AMOUNT	Tax amount in document currency		CRMT_TAX_AMOUNT	CURR	8
FREIGHT	Shipment costs in document currency		CRMT_FREIGHT	CURR	8
GROSS_VALUE	Gross Order Value in PO Currency		CRMT_GROSS_VALUE	CURR	8
NET_WO_FREIGHT	Item Net Value Exclusive Shipment		PRCT_NET_VALUE_WITHOUT_FREIGHT	CURR	8
SUBTOTAL1	Subtotal 1 from pricing procedure for condition		CRMT_SUBTOTAL1	CURR	8
SUBTOTAL2	Subtotal 2 from pricing procedure for condition		CRMT_SUBTOTAL2	CURR	8
SUBTOTAL3	Subtotal 3 from pricing procedure for condition		CRMT_SUBTOTAL3	CURR	8
SUBTOTAL4	Subtotal 4 from pricing procedure for condition		CRMT_SUBTOTAL4	CURR	8
SUBTOTAL5	Subtotal 5 from pricing procedure for condition		CRMT_SUBTOTAL5	CURR	8
SUBTOTAL6	Subtotal 6 from pricing procedure for condition		CRMT_SUBTOTAL6	CURR	8
CREDIT_INDICATOR	Credit Debit Indicator		CRMT_CREDIT_INDICATOR	CHAR	2
NETPR_PRIC_UNIT	Condition Pricing Unit		PRCT_COND_PRICING_UNIT	DEC	3
NETPR_UOM	Condition Unit		PRCT_COND_UOM	UNIT	6	*
COST_AMOUNT	Cost amount in document currency		CRMT_COST_AMOUNT	CURR	8
LOY_POINTS	Loyalty Point			DEC	6
PAYMENT_AMOUNT	Payment amount in order currency		CRMT_PAYMENT_AMOUNT	CURR	8
.INCLUDE	RECURRING_I			CRMT_RECURRING_CHARGES_I_WRK	0
RECURRING_CHARGE	Periodically charged values		CRMT_RECURRING_CHARGE	CURR	8
RECURRING_TAX	Periodically charged taxes		CRMT_RECURRING_TAX	CURR	8
RECURRING_GROSS	Periodically charged values including taxes		CRMT_RECURRING_GROSS	CURR	8
REC_DURATION	Duration of a recurrence period		CRMT_REC_DURATION	DEC	7
REC_TIME_UNIT	Time unit of a recurrence period		CRMT_REC_TIME_UNIT	CHAR	24	TIMECUUT
REC_MAIN_ITM_CUM	Cumulation of recurring charges on main item level		CRMT_REC_MAIN_ITEM_CUM	CHAR	2
TOTAL_DISCOUNT	Price Determination: Condition Value		PRCT_COND_VALUE	CURR	8