SAP ABAP View CRMV_LINKSALES (For Easy Access to the Partner 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
Short Description	For Easy Access to the Partner 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

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_LINK	OBJTYPE_HI		EQ	'05'		AND	0	0
6	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_LINK	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_LINK	GUID_HI		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	GUID_SET	CRMD_SALES	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	*	CRMD_SALES	*		☐		☐
5	-	CRMD_SALES	CLIENT		☐	MANDT	☐	Client
6	-	CRMD_SALES	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
7	PO_NUMBER_UC	CRMD_SALES	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
8	REGION	CRMD_SALES	REGION		☐	CRMT_REGION	☐	Region (State, Province, County)
9	INDUSTRY	CRMD_SALES	INDUSTRY		☐	CRMT_INDUSTRY	☐	Industry Sector
10	PCAT_HDR_GUID	CRMD_SALES	PCAT_HDR_GUID		☐	COMT_PCAT_HDR_GUID	☐	Product Catalog GUID (Header)
11	PCAT_VRT_GUID	CRMD_SALES	PCAT_VRT_GUID		☐	COMT_PCAT_VRT_GUID	☐	Product Catalog Variant GUID
12	PCAT_CTY_GUID	CRMD_SALES	PCAT_CTY_GUID		☐	COMT_PCAT_CTY_GUID	☐	GUID of a Product Catalog Area
13	CUST_GROUP1	CRMD_SALES	CUST_GROUP1		☐	CRMT_CUST_GROUP1	☐	Customer Group 1
14	CUST_GROUP2	CRMD_SALES	CUST_GROUP2		☐	CRMT_CUST_GROUP2	☐	Customer Group 2
15	CUST_GROUP3	CRMD_SALES	CUST_GROUP3		☐	CRMT_CUST_GROUP3	☐	Customer Group 3
16	CUST_GROUP4	CRMD_SALES	CUST_GROUP4		☐	CRMT_CUST_GROUP4	☐	Customer Group 4
17	CUST_GROUP5	CRMD_SALES	CUST_GROUP5		☐	CRMT_CUST_GROUP5	☐	Customer Group 5
18	PO_NUMBER_SOLD	CRMD_SALES	PO_NUMBER_SOLD		☐	CRMT_PO_NUMBER_SOLD	☐	Sold-To Party's External Reference Number
19	PO_DATE_SOLD	CRMD_SALES	PO_DATE_SOLD		☐	CRMT_PO_DATE_SOLD	☐	Reference Document Date
20	YOUR_REF_SOLD	CRMD_SALES	YOUR_REF_SOLD		☐	CRMT_YOUR_REFERENCE_SOLD	☐	Sold-to Party Reference
21	PO_NUMBER_SHIP	CRMD_SALES	PO_NUMBER_SHIP		☐	CRMT_PO_NUMBER_SHIP	☐	Ship-To Party's External Reference Number
22	PO_DATE_SHIP	CRMD_SALES	PO_DATE_SHIP		☐	CRMT_PO_DATE_SHIP	☐	Ship-To Party's Reference Document Date
23	YOUR_REF_SHIP	CRMD_SALES	YOUR_REF_SHIP		☐	CRMT_YOUR_REFERENCE_SHIP	☐	Ship-To Party Reference
24	USAGE_TYPE	CRMD_SALES	USAGE_TYPE		☐	CRMT_USAGE	☐	Usage Indicator
25	SUBMISSION	CRMD_SALES	SUBMISSION		☐	CRMT_SUBMISSION	☐	Collective Number for Quotations
26	REJECTION	CRMD_SALES	REJECTION		☐	CRMT_REJECTION_CODE	☐	Cancellation Reason Code
27	PROBABILITY	CRMD_SALES	PROBABILITY		☐	CRMT_ORDER_PROBABILITY	☐	Order Probability
28	DATE_QTY_FIXED	CRMD_SALES	DATE_QTY_FIXED		☐	CRMT_DATE_QTY_FIXED	☐	Fixed Date and Quantity
29	REQ_DLV_DATE	CRMD_SALES	REQ_DLV_DATE		☐	CRMT_REQ_DLV_DATE	☐	Requested Delivery Date Header
30	REQ_TIMEZONE	CRMD_SALES	REQ_TIMEZONE		☐	CRMT_REQ_DATE_TIMEZONE	☐	Time Zone Requested Delivery Date Header
31	RULE_REQ_DATE	CRMD_SALES	RULE_REQ_DATE		☐	CRMT_RULE_REQ_DATE	☐	Rule Reqested Delivery Date Header
32	ROUNDING	CRMD_SALES	ROUNDING		☐	CRMT_ROUNDING	☐	Round Requirement Quantity
33	PAR_ATP_SSTOCK	CRMD_SALES	PAR_ATP_SSTOCK		☐	CRMT_PAR_ATP_SSTOCK	☐	Parameter-Dependent ATP Safety Stock
34	CONF_RULE	CRMD_SALES	CONF_RULE		☐	CRMT_CONF_RULE	☐	Confirmation Rule
35	SUBST_EXCL	CRMD_SALES	SUBST_EXCL		☐	CRMT_ATP_SUBST_EXCL	☐	Rule Criterion 1
36	SEARCH_PATTERN	CRMD_SALES	SEARCH_PATTERN		☐	CRMT_SEARCH_PATTERN	☐	Rule Criterion 2
37	REASSIGN_ABILITY	CRMD_SALES	REASSIGN_ABILITY		☐	CRMT_REASSIGN_ABILITY	☐	Reassignment of Order Confirmations
38	ABNORMAL_DEMAND	CRMD_SALES	ABNORMAL_DEMAND		☐	CRMT_ABNORMAL_DEMAND	☐	Abnormal Demand
39	MAX_LOC	CRMD_SALES	MAX_LOC		☐	CRMT_MAX_LOC	☐	Maximum Number of Locations
40	CUST_PROFILE	CRMD_SALES	CUST_PROFILE		☐	CRMT_CUST_PROFILE	☐	ID of Profile of Sold-To Party
41	SALES_DUMMY	CRMD_SALES	SALES_DUMMY		☐	DUMMY	☐	Dummy function in length 1

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