SAP ABAP View CRMV_LINKPROD_I (For Simple Access to CRMD_PRODUCT_I)

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_LINKPROD_I
Short Description	For Simple Access to CRMD_PRODUCT_I
Root table	CRMD_PRODUCT_I	Transaction Item - Product

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_PRODUCT_I	CRMD_PRODUCT_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_PRODUCT_I	CLIENT	JL	EQ				0	0
2	CRMD_ORDERADM_I	CLIENT	JR	EQ			AND	0	0
3	CRMD_PRODUCT_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_PRODUCT_I	*		☐		☐
5	-	CRMD_PRODUCT_I	CLIENT		☐	MANDT	☐	Client
6	-	CRMD_PRODUCT_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
7	GROSS_WEIGHT	CRMD_PRODUCT_I	GROSS_WEIGHT		☐	CRMT_GROSS_WEIGHT	☐	Gross Weight
8	NET_WEIGHT	CRMD_PRODUCT_I	NET_WEIGHT		☐	CRMT_NET_WEIGHT	☐	Net Weight
9	WEIGHT_UNIT	CRMD_PRODUCT_I	WEIGHT_UNIT		☐	COMT_WEIGHT_UNIT	☐	Weight Unit
10	VOLUME	CRMD_PRODUCT_I	VOLUME		☐	CRMT_VOLUME	☐	Volume Occupied by the Product per Volume Unit
11	VOLUME_UNIT	CRMD_PRODUCT_I	VOLUME_UNIT		☐	COMT_VOLUME_UNIT	☐	Unit for the Volume of a Product
12	PRICE_PRODUCT	CRMD_PRODUCT_I	PRICE_PRODUCT		☐	CRMT_PRICE_PRODUCT	☐	Pricing Reference Product Globally Unique Identifier
13	PROCESS_QTY_NUM	CRMD_PRODUCT_I	PROCESS_QTY_NUM		☐	CRMT_PROCESS_QTY_NUM	☐	Numerator (factor) for conversion trans. quantity in BME
14	PROCESS_QTY_DEN	CRMD_PRODUCT_I	PROCESS_QTY_DEN		☐	CRMT_PROCESS_QTY_DEN	☐	Denominator (factor) for conversion trans. quantity in BME
15	EXPONENT10	CRMD_PRODUCT_I	EXPONENT10		☐	CRMT_EXPONENT10	☐	10 Exponent for Quantity Conversion
16	PROCESS_QTY_UNIT	CRMD_PRODUCT_I	PROCESS_QTY_UNIT		☐	CRMT_PROCESS_QTY_UNIT	☐	Unit of Measure in Which the Product Is Sold
17	COMM_GROUP	CRMD_PRODUCT_I	COMM_GROUP		☐	CRMT_COMM_GROUP	☐	Commission Group
18	REBATE_GROUP	CRMD_PRODUCT_I	REBATE_GROUP		☐	CRMT_REBATE_GROUP	☐	Volume Rebate Group
19	CASH_DISC	CRMD_PRODUCT_I	CASH_DISC		☐	CRMT_CASH_DISC	☐	Specifies Whether a Cash Discount Can Be Given for the Prod.
20	PROD_PR_GROUP	CRMD_PRODUCT_I	PROD_PR_GROUP		☐	CRMT_PROD_PR_GROUP	☐	Product Group
21	PRC_GROUP1	CRMD_PRODUCT_I	PRC_GROUP1		☐	CRMT_PRC_GROUP1	☐	Product Group 1
22	PRC_GROUP2	CRMD_PRODUCT_I	PRC_GROUP2		☐	CRMT_PRC_GROUP2	☐	Product Group 2
23	PRC_GROUP3	CRMD_PRODUCT_I	PRC_GROUP3		☐	CRMT_PRC_GROUP3	☐	Product Group 3
24	PRC_GROUP4	CRMD_PRODUCT_I	PRC_GROUP4		☐	CRMT_PRC_GROUP4	☐	Product Group 4
25	PRC_GROUP5	CRMD_PRODUCT_I	PRC_GROUP5		☐	CRMT_PRC_GROUP5	☐	Product Group 5
26	PRODUCT_SEGMENT	CRMD_PRODUCT_I	PRODUCT_SEGMENT		☐	CRMT_MKTTG_PRSEG_GUID	☐	GUID of a Product Segment
27	PROD_HIERARCHY	CRMD_PRODUCT_I	PROD_HIERARCHY		☐	CRMT_PROD_HIERARCHY	☐	Product Category
28	RESID_VALUE_ST	CRMD_PRODUCT_I	RESID_VALUE_ST		☐	CRMT_RESID_VALUE_ST	☐	Residual Value Strategy
29	RESID_VALUE_GRP	CRMD_PRODUCT_I	RESID_VALUE_GRP		☐	CRMT_RESID_VALUE_GRP	☐	Residual Value Curve
30	BATCH_ID	CRMD_PRODUCT_I	BATCH_ID		☐	CRMT_BATCH_ID	☐	Batch Number
31	INT_INSPECTION	CRMD_PRODUCT_I	INT_INSPECTION		☐	CRMT_INT_INSPECTION	☐	Internal Quality Inspection
32	RET_PROC_IND	CRMD_PRODUCT_I	RET_PROC_IND		☐	PROCESS_INDICATOR	☐	Process Indicator
33	PRODUCT_I_DUMMY	CRMD_PRODUCT_I	PRODUCT_I_DUMMY		☐	DUMMY	☐	Dummy function in length 1
34	BASE_QTY_UNIT	CRMD_PRODUCT_I	BASE_QTY_UNIT		☐	COMT_PRODUCT_BASE_UOM	☐	Base Unit of Measure of Product
35	INT_OBJ_NO_BT	CRMD_PRODUCT_I	INT_OBJ_NO_BT		☐	CRMT_INT_OBJ_NO_BT	☐	Internal Object Number for Batch Properties
36	EXCH_BUSINESS	CRMD_PRODUCT_I	EXCH_BUSINESS		☐	CRMT_EXCH_BUSINESS_REL	☐	Core Entitlements
37	IS_GIFTCARD	CRMD_PRODUCT_I	IS_GIFTCARD		☐	CRMT_BOOLEAN	☐	Logical Variable
38	GC_SEND_TYPE	CRMD_PRODUCT_I	GC_SEND_TYPE		☐	CRM_GC_SEND_TYPE	☐	Gift Card Send Type

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	300