SAP ABAP Table CRMT_PRICING_REVS_WRK (Pricing Set: Time-Related Structure for Workarea)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_PRICING (Package) Pricing-Relevant Data from CRM Document (Pricing Set)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRICING_REVS_WRK	Table Relationship Diagram
Short Description	Pricing Set: Time-Related Structure for Workarea

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Data for Pricing
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	REF_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	.INCLUDE	☐				0	0	One Contract : Time Dependency
7	VALID_FROM	☐	CRMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Time Dependency: Validity Start Date
8	VALID_TO	☐	CRMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Time Dependency: Validity End Date
9	TRANS_TIME	☐	CRMT_TRANS_TIME	BCOS_TSTMP	DEC	15	0	Time Last Change was Made
10	.INCLUDE	☐				0	0	Pricing: Only Internally Determined Fields
11	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
12	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
13	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
14	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	*
15	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	TCURC
16	ENT_STRATEGY	☐	CRMT_ENT_STRATEGY	CRM_ENT_STRATEGY	CHAR	1	0	Entitlement Strategy
17	.INCLUDE	☐				0	0	Pricing: Externally Changeable Fields
18	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
19	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
20	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
21	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
22	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
23	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
24	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
25	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
26	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
27	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
28	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	*
29	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	*
30	SCORE	☐	CRMT_SCORE	CRM_SCORE	CHAR	10	0	Result Value of an Internal Creditworthiness Check
31	GRADE	☐	BP_GRADE	BP_GRADE	CHAR	10	0	Rating	*
32	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	CRMC_AC_IND
33	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
34	.INCLUDE	☐				0	0	Pricing Set: Country-specific fields
35	CFOP_CODE	☐	ITL_CFOP	ITL_CFOP	CHAR	10	0	CFOP Code and Extension	COMC_CFOP_CODE
36	ICMS_TAXLAW	☐	ITL_TAXLAW1	ITL_TAXLAW1	CHAR	3	0	ICMS Tax Law ID	COMC_TAX_LAW_1
37	IPI_TAXLAW	☐	ITL_TAXLAW2	ITL_TAXLAW2	CHAR	3	0	IPI Tax Law ID	COMC_TAX_LAW_2
38	TAX_MAT_USAGE	☐	TAX_MAT_USAGE	TAX_MAT_USAGE	CHAR	1	0	Material Usage	*
39	LOC_TAXCAT	☐	LOC_TAXCAT	LOC_TAXCAT	CHAR	2	0	Tax Category	CRMC_TAXCAT
40	LOC_ZEROVAT	☐	LOC_ZEROVAT	LOC_ZEROVAT	CHAR	1	0	Reason for Zero-Rated VAT	CRMC_ZEROVAT
41	LOC_ACTCODE	☐	LOC_ACTCODE	LOC_ACTCODE	CHAR	2	0	Activity Code for Gross Income Tax	CRMC_ACTCODE
42	LOC_DISTTYPE	☐	LOC_DISTTYPE	LOC_DISTTYPE	CHAR	2	0	Distribution Type for Employment Tax	CRMC_DISTTYPE
43	LOC_TXRELCLAS	☐	LOC_TXRELCLAS	LOC_TXRELCLAS	CHAR	10	0	Tax Relevance Classification	CRMC_TXRELCLAS
44	ISS_TAXLAW	☐	LOC_TAX_LAW3	LOC_TAX_LAW3	CHAR	3	0	ISS Tax Law
45	COFINS_TAXLAW	☐	LOC_TAX_LAW4	LOC_TAX_LAW4	CHAR	3	0	COFINS Tax Law
46	PIS_TAXLAW	☐	LOC_TAX_LAW5	LOC_TAX_LAW5	CHAR	3	0	PIS Tax Law
47	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
48	SCRAP_VALUE	☐	CRMT_SPL_SCRAP_VALUE		CURR	10	2	Threshold for Further Action for New Parts
49	SCRAP_CURRENCY	☐	CRMT_SPL_SCRAP_CUKY	WAERS	CUKY	5	0	Currency Key for Reuse Threshold Value	*
50	SCRAP_INSTR_LOW	☐	CRMT_SPL_SCRAP_INSTR_LOW	CRM_SPL_SCRAP_INSTRUCTION	CHAR	1	0	Procedure for Values under Threshold
51	SCRAP_INSTR_HIGH	☐	CRMT_SPL_SCRAP_INSTR_HIGH	CRM_SPL_SCRAP_INSTRUCTION	CHAR	1	0	Procedure for Values over Threshold
52	LOY_MEMS_ID	☐	CRM_LOY_MEMS_ID	CRM_LOY_MEMS_ID	CHAR	10	0	Membership ID
53	LOY_PSH_ID	☐	CRM_LOY_PSH_ID	CRM_LOY_PSH_ID	CHAR	10	0	Partnership ID
54	.INCLUDE	☐				0	0	Fund Exchange attributes
55	FUND_EXCHG_TYPE	☐	CRMT_FUND_EXCHG_TYPE	KURST	CHAR	4	0	Fund Exchange Rate Type	*
56	FUND_EXCHG_DATE	☐	CRMT_FUND_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Fund Exchange Date
57	FUND_EXCHG_RATE	☐	CRMT_FUND_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Fund Exchange Rate
58	FUND_EXCHG_R_TG	☐	CRMT_FUND_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Fund Exchange Rate
59	.INCLUDE	☐				0	0	EEW Include
60	PRICING_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
61	.INCLUDE	☐				0	0
62	TAX_EXEMPT_GUID	☐	CRM_TAX_EXEMPT_HEADER_GUID	SYSUUID	RAW	16	0	Object Header GUID
63	TAX_EXEMPT_ID	☐	CRM_TAX_EXEMPT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	Customer Tax Exemption Certificate ID
64	POINT_PMT_INDIC	☐	CRMT_LOY_POINT_PAYMENT	CRM_LOY_POINT_PAYMENT	CHAR	1	0	Point Payment Option
65	POINT_PMT_AMT	☐	CRMT_LOY_PMT_AMT		DEC	10	2	Point Payment Amount - Header
66	POINT_PMT_PTYPE	☐	CRMT_LOY_PMT_PTTYPE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	Payment Point Type
67	LINKED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRICING_REVS_WRK	AC_INDICATOR	CRMC_AC_IND	AC_INDICATOR		1	CN
2	CRMT_PRICING_REVS_WRK	CFOP_CODE	COMC_CFOP_CODE	CFOP_CODE
3	CRMT_PRICING_REVS_WRK	CURRENCY	TCURC	WAERS
4	CRMT_PRICING_REVS_WRK	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	C	CN
5	CRMT_PRICING_REVS_WRK	EXCHG_TYPE	TCURV	KURST
6	CRMT_PRICING_REVS_WRK	ICMS_TAXLAW	COMC_TAX_LAW_1	TAX_LAW
7	CRMT_PRICING_REVS_WRK	IPI_TAXLAW	COMC_TAX_LAW_2	TAX_LAW
8	CRMT_PRICING_REVS_WRK	LOC_ACTCODE	CRMC_ACTCODE	LOC_ACTCODE
9	CRMT_PRICING_REVS_WRK	LOC_DISTTYPE	CRMC_DISTTYPE	LOC_DISTTYPE
10	CRMT_PRICING_REVS_WRK	LOC_TAXCAT	CRMC_TAXCAT	LOC_TAXCAT
11	CRMT_PRICING_REVS_WRK	LOC_TXRELCLAS	CRMC_TXRELCLAS	LOC_TXRELCLAS
12	CRMT_PRICING_REVS_WRK	LOC_ZEROVAT	CRMC_ZEROVAT	LOC_ZEROVAT
13	CRMT_PRICING_REVS_WRK	PRICE_GRP	CRMC_PRICEGRP	PRICE_GROUP
14	CRMT_PRICING_REVS_WRK	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST	REF	C	CN
15	CRMT_PRICING_REVS_WRK	REF_CURRENCY	TCURC	WAERS
16	CRMT_PRICING_REVS_WRK	TAX_DEST_CTY	T005	LAND1

History

Last changed by/on	SAP	20140117
SAP Release Created in	12A