CRMR_PRICING - Data for Pricing

Data for Pricing information is stored in SAP table CRMR_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 CRMR_PRICING

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
REF_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_TIME_DEP	0
VALID_FROM	Time Dependency: Validity Start Date		CRMT_VALID_FROM	DEC	8
VALID_TO	Time Dependency: Validity End Date		CRMT_VALID_TO	DEC	8
TRANS_TIME	Time Last Change was Made		CRMT_TRANS_TIME	DEC	8
.INCLUDE				CRMT_PRICING_INT	0
EXCHG_TYPE	Exchange Rate Type		CRMT_EXCHG_TYPE	CHAR	8	TCURV
EXCHG_DATE	Exchange Rate Date		CRMT_EXCHG_DATE	DATS	16
TAXJURCODE	Tax Jurisdiction Code (Structure for tax calculation)		CRMT_TAXJURCODE	CHAR	30	*
CUST_PRIC_PROC	Customer Pricing Procedure		CRMT_CUST_PRIC_PROC	CHAR	4	*
REF_CURRENCY	Reference Currency		CRMT_REF_CURRENCY	CUKY	10	TCURC
ENT_STRATEGY	Entitlement Strategy		CRMT_ENT_STRATEGY	CHAR	2
.INCLUDE				CRMT_PRICING_EXT	0
CURRENCY	Currency		CRMT_CURRENCY	CUKY	10	TCURC
PRICE_DATE	Pricing Date		CRMT_PRICE_DATE	DATS	16
PMNTTRMS	Terms of Payment		CRMT_PMNTTRMS	CHAR	8
PRICE_GRP	Customer Price Group		CRMT_PRICE_GRP	CHAR	4	T188
PRICE_LIST	Price List Type		CRMT_PRICE_LIST	CHAR	4	T189
CUST_GROUP	Customer Group		CRMT_CUST_GROUP	CHAR	4	T151
EXCHG_RATE	Exchange Rate		CRMT_EXCHG_RATE	DEC	5
TAX_DEST_CTY	Tax Destination Country/Region		CRMT_TAX_DEST_CTY	CHAR	6	T005
TAX_DEST_REG	Region (State, Province, County)		CRMT_REGION	CHAR	6	*
VAT_REG_NO	Sales tax registration number		CRMT_VAT_REG_NO	CHAR	40
ETAX_HAND_TYPE	Excise Tax Handling Type (Denotes Use of Material)		CRMT_ETAX_HAND_TYPE	CHAR	4	*
ETAX_SOURCE	Source of Excise Tax Rates		CRMT_ETAX_SOURCE	CHAR	4	*
SCORE	Result Value of an Internal Creditworthiness Check		CRMT_SCORE	CHAR	20
GRADE	Rating		BP_GRADE	CHAR	20	*
AC_INDICATOR	Accounting Indicator		CRMT_AC_INDICATOR	CHAR	4	TBMOT
CUSTOMER_TYPE	Business Partner Type		CRMT_CUSTOMER_TYPE	CHAR	8	*
.INCLUDE				CRMT_PRICING_LOC	0
CFOP_CODE	Text (10 Characters)		TEXT10	CHAR	20	*
ICMS_TAXLAW	ICMS Tax Law ID			CHAR	6
IPI_TAXLAW	IPI Tax Law ID			CHAR	6
TAX_MAT_USAGE	Material Usage			CHAR	2
LOC_TAXCAT	Tax Category		LOC_TAXCAT	CHAR	4	*
LOC_ZEROVAT	Reason for Zero-Rated VAT		LOC_ZEROVAT	CHAR	2	*
LOC_ACTCODE	Activity Code for Gross Income Tax			CHAR	4
LOC_DISTTYPE	Distribution Type for Employment Tax			CHAR	4
LOC_TXRELCLAS	Tax Relevance Classification		LOC_TXRELCLAS	CHAR	20	*
ISS_TAXLAW	ISS Tax Law			CHAR	6
COFINS_TAXLAW	COFINS Tax Law			CHAR	6
PIS_TAXLAW	PIS Tax Law			CHAR	6
PAYMENT_METHOD	Payment Method		CRMT_BUAG_PAYMETH	CHAR	2	*
SCRAP_VALUE	Obsolete (Threshold for Further Action for New Parts)			CURR	6
SCRAP_CURRENCY	Obsolete (Currency Key for Reuse Threshold Value)			CUKY	10
SCRAP_INSTR_LOW	Obsolete (Procedure for Values under Threshold)			CHAR	2
SCRAP_INSTR_HIGH	Obsolete (Procedure for Values over Threshold)			CHAR	2
LOY_MEMS_ID	Membership ID			CHAR	20
LOY_PSH_ID	Partnership ID			CHAR	20
FUND_EXCHG_TYPE	Fund Exchange Rate Type (OBSOLETE)			CHAR	8
FUND_EXCHG_DATE	Fund Exchange Date (OBSOLETE)			DATS	16
FUND_EXCHG_RATE	Fund Exchange Date (OBSOLETE)			DEC	5
FUND_EXCHG_R_TG	Fund Exchange Date (OBSOLETE)			DEC	5
.INCLUDE				INCL_EEW_PRICING	0
PRICING_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_EEW_PRICING	0
TAX_EXEMPT_GUID	Object Header GUID			RAW	16
TAX_EXEMPT_ID	Customer Tax Exemption Certificate ID			CHAR	60
POINT_PMT_INDIC				CHAR	2
POINT_PMT_AMT				DEC	6
POINT_PMT_PTYPE				CHAR	20
PRICING_CONTROL	Pricing Control		CRMS4_PRICING_CONTROL	CHAR	2