SAP ABAP View CRMV_LINKPRICING (Link with Pricing set at Header Level)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

View Type	D	Database View
Database View	CRMV_LINKPRICING
Short Description	Link with Pricing set at Header Level
Root table	CRMD_LINK	Transaction - Set - Link

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_LINK	CRMD_LINK
2	CRMD_PRICING

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_PRICING	CLIENT	JL	EQ				0	0
2	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
3	CRMD_PRICING	GUID	JL	EQ				0	0
4	CRMD_LINK	GUID_SET	JR	EQ			AND	0	0
5	CRMD_LINK	OBJTYPE_HI		EQ	'05'		AND	0	0
6	CRMD_LINK	OBJTYPE_SET		EQ	'09'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_LINK	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_LINK	GUID_HI		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	GUID_SET	CRMD_PRICING	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	*	CRMD_PRICING	*		☐		☐
5	-	CRMD_PRICING	CLIENT		☐	MANDT	☐	Client
6	-	CRMD_PRICING	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
7	EXCHG_TYPE	CRMD_PRICING	EXCHG_TYPE		☐	CRMT_EXCHG_TYPE	☐	Exchange Rate Type
8	EXCHG_DATE	CRMD_PRICING	EXCHG_DATE		☐	CRMT_EXCHG_DATE	☐	Exchange Rate Date
9	TAXJURCODE	CRMD_PRICING	TAXJURCODE		☐	CRMT_TAXJURCODE	☐	Tax Jurisdiction Code (Structure for tax calculation)
10	CUST_PRIC_PROC	CRMD_PRICING	CUST_PRIC_PROC		☐	CRMT_CUST_PRIC_PROC	☐	Customer Pricing Procedure
11	REF_CURRENCY	CRMD_PRICING	REF_CURRENCY		☐	CRMT_REF_CURRENCY	☐	Reference Currency
12	ENT_STRATEGY	CRMD_PRICING	ENT_STRATEGY		☐	CRMT_ENT_STRATEGY	☐	Entitlement Strategy
13	CURRENCY	CRMD_PRICING	CURRENCY		☐	CRMT_CURRENCY	☐	Currency
14	PRICE_DATE	CRMD_PRICING	PRICE_DATE		☐	CRMT_PRICE_DATE	☐	Pricing Date
15	PMNTTRMS	CRMD_PRICING	PMNTTRMS		☐	CRMT_PMNTTRMS	☐	Terms of Payment
16	PRICE_GRP	CRMD_PRICING	PRICE_GRP		☐	CRMT_PRICE_GRP	☐	Customer Price Group
17	PRICE_LIST	CRMD_PRICING	PRICE_LIST		☐	CRMT_PRICE_LIST	☐	Price List Type
18	CUST_GROUP	CRMD_PRICING	CUST_GROUP		☐	CRMT_CUST_GROUP	☐	Customer Group
19	EXCHG_RATE	CRMD_PRICING	EXCHG_RATE		☐	CRMT_EXCHG_RATE	☐	Exchange Rate
20	TAX_DEST_CTY	CRMD_PRICING	TAX_DEST_CTY		☐	CRMT_TAX_DEST_CTY	☐	Tax Destination Country
21	TAX_DEST_REG	CRMD_PRICING	TAX_DEST_REG		☐	CRMT_REGION	☐	Region (State, Province, County)
22	VAT_REG_NO	CRMD_PRICING	VAT_REG_NO		☐	CRMT_VAT_REG_NO	☐	Sales tax registration number
23	ETAX_HAND_TYPE	CRMD_PRICING	ETAX_HAND_TYPE		☐	CRMT_ETAX_HAND_TYPE	☐	Excise Tax Handling Type (Denotes Use of Material)
24	ETAX_SOURCE	CRMD_PRICING	ETAX_SOURCE		☐	CRMT_ETAX_SOURCE	☐	Source of Excise Tax Rates
25	SCORE	CRMD_PRICING	SCORE		☐	CRMT_SCORE	☐	Result Value of an Internal Creditworthiness Check
26	GRADE	CRMD_PRICING	GRADE		☐	BP_GRADE	☐	Rating
27	AC_INDICATOR	CRMD_PRICING	AC_INDICATOR		☐	CRMT_AC_INDICATOR	☐	Accounting Indicator
28	CUSTOMER_TYPE	CRMD_PRICING	CUSTOMER_TYPE		☐	CRMT_CUSTOMER_TYPE	☐	Business Partner Type
29	CFOP_CODE	CRMD_PRICING	CFOP_CODE		☐	ITL_CFOP	☐	CFOP Code and Extension
30	ICMS_TAXLAW	CRMD_PRICING	ICMS_TAXLAW		☐	ITL_TAXLAW1	☐	ICMS Tax Law ID
31	IPI_TAXLAW	CRMD_PRICING	IPI_TAXLAW		☐	ITL_TAXLAW2	☐	IPI Tax Law ID
32	TAX_MAT_USAGE	CRMD_PRICING	TAX_MAT_USAGE		☐	TAX_MAT_USAGE	☐	Material Usage
33	LOC_TAXCAT	CRMD_PRICING	LOC_TAXCAT		☐	LOC_TAXCAT	☐	Tax Category
34	LOC_ZEROVAT	CRMD_PRICING	LOC_ZEROVAT		☐	LOC_ZEROVAT	☐	Reason for Zero-Rated VAT
35	LOC_ACTCODE	CRMD_PRICING	LOC_ACTCODE		☐	LOC_ACTCODE	☐	Activity Code for Gross Income Tax
36	LOC_DISTTYPE	CRMD_PRICING	LOC_DISTTYPE		☐	LOC_DISTTYPE	☐	Distribution Type for Employment Tax
37	LOC_TXRELCLAS	CRMD_PRICING	LOC_TXRELCLAS		☐	LOC_TXRELCLAS	☐	Tax Relevance Classification
38	ISS_TAXLAW	CRMD_PRICING	ISS_TAXLAW		☐	LOC_TAX_LAW3	☐	ISS Tax Law
39	COFINS_TAXLAW	CRMD_PRICING	COFINS_TAXLAW		☐	LOC_TAX_LAW4	☐	COFINS Tax Law
40	PIS_TAXLAW	CRMD_PRICING	PIS_TAXLAW		☐	LOC_TAX_LAW5	☐	PIS Tax Law
41	PAYMENT_METHOD	CRMD_PRICING	PAYMENT_METHOD		☐	CRMT_BUAG_PAYMETH	☐	Payment Method
42	SCRAP_VALUE	CRMD_PRICING	SCRAP_VALUE		☐	CRMT_SPL_SCRAP_VALUE	☐	Threshold for Further Action for New Parts
43	SCRAP_CURRENCY	CRMD_PRICING	SCRAP_CURRENCY		☐	CRMT_SPL_SCRAP_CUKY	☐	Currency Key for Reuse Threshold Value
44	SCRAP_INSTR_LOW	CRMD_PRICING	SCRAP_INSTR_LOW		☐	CRMT_SPL_SCRAP_INSTR_LOW	☐	Procedure for Values under Threshold
45	SCRAP_INSTR_HIGH	CRMD_PRICING	SCRAP_INSTR_HIGH		☐	CRMT_SPL_SCRAP_INSTR_HIGH	☐	Procedure for Values over Threshold
46	LOY_MEMS_ID	CRMD_PRICING	LOY_MEMS_ID		☐	CRM_LOY_MEMS_ID	☐	Membership ID
47	LOY_PSH_ID	CRMD_PRICING	LOY_PSH_ID		☐	CRM_LOY_PSH_ID	☐	Partnership ID
48	FUND_EXCHG_TYPE	CRMD_PRICING	FUND_EXCHG_TYPE		☐	CRMT_FUND_EXCHG_TYPE	☐	Fund Exchange Rate Type
49	FUND_EXCHG_DATE	CRMD_PRICING	FUND_EXCHG_DATE		☐	CRMT_FUND_EXCHG_DATE	☐	Fund Exchange Date
50	FUND_EXCHG_RATE	CRMD_PRICING	FUND_EXCHG_RATE		☐	CRMT_FUND_EXCHG_RATE	☐	Fund Exchange Rate
51	FUND_EXCHG_R_TG	CRMD_PRICING	FUND_EXCHG_R_TG		☐	CRMT_FUND_EXCHG_RATE	☐	Fund Exchange Rate
52	PRICING_DUMMY	CRMD_PRICING	PRICING_DUMMY		☐	DUMMY	☐	Dummy function in length 1
53	TAX_EXEMPT_GUID	CRMD_PRICING	TAX_EXEMPT_GUID		☐	CRM_TAX_EXEMPT_HEADER_GUID	☐	Object Header GUID
54	TAX_EXEMPT_ID	CRMD_PRICING	TAX_EXEMPT_ID		☐	CRM_TAX_EXEMPT_ID	☐	Customer Tax Exemption Certificate ID
55	POINT_PMT_INDIC	CRMD_PRICING	POINT_PMT_INDIC		☐	CRMT_LOY_POINT_PAYMENT	☐	Point Payment Option
56	POINT_PMT_AMT	CRMD_PRICING	POINT_PMT_AMT		☐	CRMT_LOY_PMT_AMT	☐	Point Payment Amount - Header
57	POINT_PMT_PTYPE	CRMD_PRICING	POINT_PMT_PTYPE		☐	CRMT_LOY_PMT_PTTYPE	☐	Payment Point Type
58	VALID_FROM	CRMD_PRICING	VALID_FROM		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
59	VALID_TO	CRMD_PRICING	VALID_TO		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
60	TRANS_TIME	CRMD_PRICING	TRANS_TIME		☐	CRMT_TRANS_TIME	☐	Time Last Change was Made

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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