SAP ABAP View CRMV_LINKPRIC_I (For Easy Access to the Pricing_i Ext.)

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_LINKPRIC_I
Short Description	For Easy Access to the Pricing_i Ext.
Root table	CRMD_PRICING_I	Transaction Item Price

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_PRICING_I	CRMD_PRICING_I
2	CRMD_ORDERADM_I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_PRICING_I	CLIENT	JL	EQ				0	0
2	CRMD_ORDERADM_I	CLIENT	JR	EQ			AND	0	0
3	CRMD_PRICING_I	GUID	JL	EQ				0	0
4	CRMD_ORDERADM_I	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_ORDERADM_I	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_ORDERADM_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	REF_GUID	CRMD_ORDERADM_I	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	*	CRMD_PRICING_I	*		☐		☐
5	-	CRMD_PRICING_I	CLIENT		☐	MANDT	☐	Client
6	-	CRMD_PRICING_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
7	NET_VALUE_MAN	CRMD_PRICING_I	NET_VALUE_MAN		☐	CRMT_NET_VALUE_MAN	☐	Total Expected Net Value Products in Document Currency
8	TARGET_VALUE	CRMD_PRICING_I	TARGET_VALUE		☐	CRMT_TARGET_VALUE	☐	Target Value for Contracts
9	COST_AMOUNT_MAN	CRMD_PRICING_I	COST_AMOUNT_MAN		☐	CRMT_COST_AMOUNT_MAN	☐	Total Expected Cost Amount in Document Currency
10	CASHFLOW_TYPE	CRMD_PRICING_I	CASHFLOW_TYPE		☐	CRMT_CASHFLOW_TYPE	☐	Flow Category
11	TAX_GROUP_P	CRMD_PRICING_I	TAX_GROUP_P		☐	CRMT_TAX_GROUP	☐	Product Tax Group
12	TAX_GROUP_P_CTY	CRMD_PRICING_I	TAX_GROUP_P_CTY		☐	CRMT_TAX_LAND	☐	Tax Country
13	TAX_GROUP_P_REG	CRMD_PRICING_I	TAX_GROUP_P_REG		☐	CRMT_TAX_REGION	☐	Tax Region
14	TAX_GROUP_P_TTP	CRMD_PRICING_I	TAX_GROUP_P_TTP		☐	CRMT_TAX_TYPE	☐	Tax Type
15	EXPENSE_TYPE	CRMD_PRICING_I	EXPENSE_TYPE		☐	CRM_FM_FU_EXPENSE_TYPE	☐	Expense Type
16	REASON	CRMD_PRICING_I	REASON		☐	CRMT_CLA_REASON	☐	Claim Reason
17	LOY_POINT_TYPE	CRMD_PRICING_I	LOY_POINT_TYPE		☐	CRMT_MKTPL_LOY_POINT_CODE	☐	ID of Point Type
18	POINTS_SPENT	CRMD_PRICING_I	POINTS_SPENT		☐	CRMT_LOY_POINTS_SPENT	☐	Loyalty Points Spent
19	PRICING_I_DUMMY	CRMD_PRICING_I	PRICING_I_DUMMY		☐	DUMMY	☐	Dummy function in length 1
20	INV_VER_TAX_CTY	CRMD_PRICING_I	INV_VER_TAX_CTY		☐	CRMT_INV_VERIF_TAX_CTY	☐	Invoice Verficitaion Tax Code Country
21	INV_VER_TAX_DIR	CRMD_PRICING_I	INV_VER_TAX_DIR		☐	CRMT_INV_VERIF_TAX_DIR	☐	Invoice Verification Tax Code Direction
22	INV_VER_TAX_CODE	CRMD_PRICING_I	INV_VER_TAX_CODE		☐	CRMT_INV_VERIF_TAX_CODE	☐	Invoice Verification Tax Code
23	INV_VER_JUR_CODE	CRMD_PRICING_I	INV_VER_JUR_CODE		☐	CRMT_INV_VERIF_TAX_JUR_CODE	☐	Invoice Verification Tax Jurisdiction Code
24	TAX_DEPART_CTY	CRMD_PRICING_I	TAX_DEPART_CTY		☐	CRMT_TAX_DEPART_CTY	☐	Tax Departure Country
25	TAX_DEPART_REG	CRMD_PRICING_I	TAX_DEPART_REG		☐	CRMT_TAX_DEPART_REG	☐	Departure Region for Tax
26	TAXJURCODE_FROM	CRMD_PRICING_I	TAXJURCODE_FROM		☐	CRMT_TAXJURCODE	☐	Tax Jurisdiction Code (Structure for tax calculation)
27	TAX_TARIFF_CODE	CRMD_PRICING_I	TAX_TARIFF_CODE		☐	CRMT_TAX_TARIFF_CODE	☐	Tax Tariff Code
28	STATISTICAL	CRMD_PRICING_I	STATISTICAL		☐	CRMT_STATISTICAL	☐	Statistical values
29	PRC_INDICATOR	CRMD_PRICING_I	PRC_INDICATOR		☐	CRMT_PRICING_INDICATOR	☐	Pricing indicator
30	NET_VALUE	CRMD_PRICING_I	NET_VALUE		☐	CRMT_NET_VALUE	☐	Net Value
31	NET_PRICE	CRMD_PRICING_I	NET_PRICE		☐	CRMT_NET_PRICE	☐	Net Price
32	TAX_AMOUNT	CRMD_PRICING_I	TAX_AMOUNT		☐	CRMT_TAX_AMOUNT	☐	Tax amount in document currency
33	FREIGHT	CRMD_PRICING_I	FREIGHT		☐	CRMT_FREIGHT	☐	Shipment costs in document currency
34	GROSS_VALUE	CRMD_PRICING_I	GROSS_VALUE		☐	CRMT_GROSS_VALUE	☐	Gross Order Value in PO Currency
35	NET_WO_FREIGHT	CRMD_PRICING_I	NET_WO_FREIGHT		☐	PRCT_NET_VALUE_WITHOUT_FREIGHT	☐	Item Net Value Exclusive Shipment
36	SUBTOTAL1	CRMD_PRICING_I	SUBTOTAL1		☐	CRMT_SUBTOTAL1	☐	Subtotal 1 from pricing procedure for condition
37	SUBTOTAL2	CRMD_PRICING_I	SUBTOTAL2		☐	CRMT_SUBTOTAL2	☐	Subtotal 2 from pricing procedure for condition
38	SUBTOTAL3	CRMD_PRICING_I	SUBTOTAL3		☐	CRMT_SUBTOTAL3	☐	Subtotal 3 from pricing procedure for condition
39	SUBTOTAL4	CRMD_PRICING_I	SUBTOTAL4		☐	CRMT_SUBTOTAL4	☐	Subtotal 4 from pricing procedure for condition
40	SUBTOTAL5	CRMD_PRICING_I	SUBTOTAL5		☐	CRMT_SUBTOTAL5	☐	Subtotal 5 from pricing procedure for condition
41	SUBTOTAL6	CRMD_PRICING_I	SUBTOTAL6		☐	CRMT_SUBTOTAL6	☐	Subtotal 6 from pricing procedure for condition
42	CREDIT_INDICATOR	CRMD_PRICING_I	CREDIT_INDICATOR		☐	CRMT_CREDIT_INDICATOR	☐	Credit Debit Indicator
43	NETPR_PRIC_UNIT	CRMD_PRICING_I	NETPR_PRIC_UNIT		☐	PRCT_COND_PRICING_UNIT	☐	Condition Pricing Unit
44	NETPR_UOM	CRMD_PRICING_I	NETPR_UOM		☐	PRCT_COND_UOM	☐	Condition Unit
45	COST_AMOUNT	CRMD_PRICING_I	COST_AMOUNT		☐	CRMT_COST_AMOUNT	☐	Cost amount in document currency
46	LOY_POINTS	CRMD_PRICING_I	LOY_POINTS		☐	CRM_LOY_PT_POINT	☐	Loyalty Point
47	PAYMENT_AMOUNT	CRMD_PRICING_I	PAYMENT_AMOUNT		☐	CRMT_PAYMENT_AMOUNT	☐	Payment amount in order currency
48	RECURRING_CHARGE	CRMD_PRICING_I	RECURRING_CHARGE		☐	CRMT_RECURRING_CHARGE	☐	Periodically charged values
49	RECURRING_TAX	CRMD_PRICING_I	RECURRING_TAX		☐	CRMT_RECURRING_TAX	☐	Periodically charged taxes
50	RECURRING_GROSS	CRMD_PRICING_I	RECURRING_GROSS		☐	CRMT_RECURRING_GROSS	☐	Periodically charged values including taxes
51	REC_DURATION	CRMD_PRICING_I	REC_DURATION		☐	CRMT_REC_DURATION	☐	Duration of a recurrence period
52	REC_TIME_UNIT	CRMD_PRICING_I	REC_TIME_UNIT		☐	CRMT_REC_TIME_UNIT	☐	Time unit of a recurrence period
53	REC_MAIN_ITM_CUM	CRMD_PRICING_I	REC_MAIN_ITM_CUM		☐	CRMT_REC_MAIN_ITEM_CUM	☐	Cumulation of recurring charges on main item level
54	TOTAL_DISCOUNT	CRMD_PRICING_I	TOTAL_DISCOUNT		☐	PRCT_COND_VALUE	☐	Price Determination: Condition Value

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	20130604
SAP Release Created in	30A