SAP ABAP View CRMV_LINKSALES_I (For Easy Access to shipping_item Set)

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_LINKSALES_I
Short Description	For Easy Access to shipping_item Set
Root table	CRMD_SALES	Business Transaction - Sales Set

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_SALES	CRMD_SALES
2	CRMD_LINK
3	CRMD_ORDERADM_I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_SALES	CLIENT	JL	EQ				0	0
2	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
3	CRMD_SALES	GUID	JL	EQ				0	0
4	CRMD_LINK	GUID_SET	JR	EQ			AND	0	0
5	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
6	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
7	CRMD_ORDERADM_I	CLIENT	JL	EQ				0	0
8	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
9	CRMD_LINK	OBJTYPE_HI		EQ	'06'		AND	0	0
10	CRMD_LINK	OBJTYPE_SET		EQ	'11'			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	HEADER	CRMD_ORDERADM_I	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	PO_NUMBER_UC	CRMD_SALES	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
5	REGION	CRMD_SALES	REGION		☐	CRMT_REGION	☐	Region (State, Province, County)
6	INDUSTRY	CRMD_SALES	INDUSTRY		☐	CRMT_INDUSTRY	☐	Industry Sector
7	PCAT_HDR_GUID	CRMD_SALES	PCAT_HDR_GUID		☐	COMT_PCAT_HDR_GUID	☐	Product Catalog GUID (Header)
8	PCAT_VRT_GUID	CRMD_SALES	PCAT_VRT_GUID		☐	COMT_PCAT_VRT_GUID	☐	Product Catalog Variant GUID
9	PCAT_CTY_GUID	CRMD_SALES	PCAT_CTY_GUID		☐	COMT_PCAT_CTY_GUID	☐	GUID of a Product Catalog Area
10	CUST_GROUP1	CRMD_SALES	CUST_GROUP1		☐	CRMT_CUST_GROUP1	☐	Customer Group 1
11	CUST_GROUP2	CRMD_SALES	CUST_GROUP2		☐	CRMT_CUST_GROUP2	☐	Customer Group 2
12	CUST_GROUP3	CRMD_SALES	CUST_GROUP3		☐	CRMT_CUST_GROUP3	☐	Customer Group 3
13	CUST_GROUP4	CRMD_SALES	CUST_GROUP4		☐	CRMT_CUST_GROUP4	☐	Customer Group 4
14	CUST_GROUP5	CRMD_SALES	CUST_GROUP5		☐	CRMT_CUST_GROUP5	☐	Customer Group 5
15	PO_NUMBER_SOLD	CRMD_SALES	PO_NUMBER_SOLD		☐	CRMT_PO_NUMBER_SOLD	☐	Sold-To Party's External Reference Number
16	PO_DATE_SOLD	CRMD_SALES	PO_DATE_SOLD		☐	CRMT_PO_DATE_SOLD	☐	Reference Document Date
17	YOUR_REF_SOLD	CRMD_SALES	YOUR_REF_SOLD		☐	CRMT_YOUR_REFERENCE_SOLD	☐	Sold-to Party Reference
18	PO_NUMBER_SHIP	CRMD_SALES	PO_NUMBER_SHIP		☐	CRMT_PO_NUMBER_SHIP	☐	Ship-To Party's External Reference Number
19	PO_DATE_SHIP	CRMD_SALES	PO_DATE_SHIP		☐	CRMT_PO_DATE_SHIP	☐	Ship-To Party's Reference Document Date
20	YOUR_REF_SHIP	CRMD_SALES	YOUR_REF_SHIP		☐	CRMT_YOUR_REFERENCE_SHIP	☐	Ship-To Party Reference
21	USAGE_TYPE	CRMD_SALES	USAGE_TYPE		☐	CRMT_USAGE	☐	Usage Indicator
22	SUBMISSION	CRMD_SALES	SUBMISSION		☐	CRMT_SUBMISSION	☐	Collective Number for Quotations
23	REJECTION	CRMD_SALES	REJECTION		☐	CRMT_REJECTION_CODE	☐	Cancellation Reason Code
24	PROBABILITY	CRMD_SALES	PROBABILITY		☐	CRMT_ORDER_PROBABILITY	☐	Order Probability

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