SAP ABAP View CRMV_SRV_INDEX (View for SRV and CRMD_ORDER_INDEX)

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_SRV_INDEX
Short Description	View for SRV and CRMD_ORDER_INDEX
Root table	CRMD_ORDER_INDEX	Index table for one-order document

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_ORDER_INDEX	CRMD_ORDER_INDEX
2	CRMD_LINK
3	CRMD_SRV_OSSET
4	CRMD_SRV_SUBJECT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_ORDER_INDEX	CLIENT	JL	EQ				0	0
2	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
3	CRMD_ORDER_INDEX	HEADER	JL	EQ				0	0
4	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
5	CRMD_LINK	CLIENT	JL	EQ				0	0
6	CRMD_SRV_OSSET	CLIENT	JR	EQ			AND	0	0
7	CRMD_LINK	GUID_SET	JL	EQ				0	0
8	CRMD_SRV_OSSET	GUID_SET	JR	EQ			AND	0	0
9	CRMD_SRV_OSSET	CLIENT	JL	EQ				0	0
10	CRMD_SRV_SUBJECT	CLIENT	JR	EQ			AND	0	0
11	CRMD_SRV_OSSET	GUID	JL	EQ				0	0
12	CRMD_SRV_SUBJECT	GUID_REF	JR	EQ			AND	0	0
13	CRMD_LINK	OBJTYPE_HI		EQ	'05'		AND	0	0
14	CRMD_LINK	OBJTYPE_SET		EQ	'29'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_ORDER_INDEX	CLIENT		☐	MANDT	☐	Client
2	HEADER	CRMD_ORDER_INDEX	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	OBJECT_TYPE	CRMD_ORDER_INDEX	OBJECT_TYPE		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
4	PARTNER_NO	CRMD_ORDER_INDEX	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
5	DATE_1	CRMD_ORDER_INDEX	DATE_1		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
6	DATE_2	CRMD_ORDER_INDEX	DATE_2		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
7	DATE_3	CRMD_ORDER_INDEX	DATE_3		☐	CRMT_CONTACT_FROM	☐	Time Stamp: Start of Customer Contact
8	DATE_4	CRMD_ORDER_INDEX	DATE_4		☐	CRMT_CONTACT_TO	☐	Time Stamp: End of Customer Contact
9	POSTING_DATE_HD	CRMD_ORDER_INDEX	POSTING_DATE_HD		☐	CRMT_POSTING_DATE	☐	Posting Date for a Business Transaction
10	PRODUCT_ID	CRMD_ORDER_INDEX	PRODUCT_ID		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
11	PURCH_ORG	CRMD_ORDER_INDEX	PURCH_ORG		☐	CRMT_PURCH_ORG	☐	Purchasing Organization
12	SALES_ORG	CRMD_ORDER_INDEX	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
13	SALES_OFFICE	CRMD_ORDER_INDEX	SALES_OFFICE		☐	CRMT_SALES_OFFICE	☐	Sales Office
14	SALES_GROUP	CRMD_ORDER_INDEX	SALES_GROUP		☐	CRMT_SALES_GROUP	☐	Sales Group
15	DIVISION	CRMD_ORDER_INDEX	DIVISION		☐	CRMT_DIVISION	☐	Division
16	DIS_CHANNEL	CRMD_ORDER_INDEX	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
17	SERVICE_ORG	CRMD_ORDER_INDEX	SERVICE_ORG		☐	CRMT_SERVICE_ORG	☐	Service Organization
18	CATEGORY_ID	CRMD_ORDER_INDEX	CATEGORY_ID		☐	COMT_CATEGORY_ID	☐	Category ID
19	DESCRIPT_PARTNER	CRMD_ORDER_INDEX	DESCRIPT_PARTNER		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner
20	CATALOG_ID	CRMD_ORDER_INDEX	CATALOG_ID		☐	CRMT_CATALOG	☐	Catalog ID from which the line was selected
21	PO_NUMBER_UC	CRMD_ORDER_INDEX	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
22	CURRENCY	CRMD_ORDER_INDEX	CURRENCY		☐	CRMT_CURRENCY	☐	Currency
23	STAT_OPEN	CRMD_ORDER_INDEX	STAT_OPEN		☐	CRMT_STATUS_OPEN	☐	Transaction is Still Open
24	STAT_PLANNED	CRMD_ORDER_INDEX	STAT_PLANNED		☐	CRMT_STATUS_PLANNED	☐	Status: Planned
25	STAT_QUOT	CRMD_ORDER_INDEX	STAT_QUOT		☐	CRMT_BOOLEAN	☐	Logical Variable
26	STAT_INQ	CRMD_ORDER_INDEX	STAT_INQ		☐	CRMT_BOOLEAN	☐	Logical Variable
27	PFT_1	CRMD_ORDER_INDEX	PFT_1		☐	CRMT_BOOLEAN	☐	Logical Variable
28	PFT_0	CRMD_ORDER_INDEX	PFT_0		☐	CRMT_BOOLEAN	☐	Logical Variable
29	PFT_2	CRMD_ORDER_INDEX	PFT_2		☐	CRMT_BOOLEAN	☐	Logical Variable
30	PFT_3	CRMD_ORDER_INDEX	PFT_3		☐	CRMT_BOOLEAN	☐	Logical Variable
31	PFT_4	CRMD_ORDER_INDEX	PFT_4		☐	CRMT_BOOLEAN	☐	Logical Variable
32	PFT_5	CRMD_ORDER_INDEX	PFT_5		☐	CRMT_BOOLEAN	☐	Logical Variable
33	PFT_6	CRMD_ORDER_INDEX	PFT_6		☐	CRMT_BOOLEAN	☐	Logical Variable
34	PFT_7	CRMD_ORDER_INDEX	PFT_7		☐	CRMT_BOOLEAN	☐	Logical Variable
35	PFT_8	CRMD_ORDER_INDEX	PFT_8		☐	CRMT_BOOLEAN	☐	Logical Variable
36	PFT_9	CRMD_ORDER_INDEX	PFT_9		☐	CRMT_BOOLEAN	☐	Logical Variable
37	PFT_10	CRMD_ORDER_INDEX	PFT_10		☐	CRMT_BOOLEAN	☐	Logical Variable
38	PFT_11	CRMD_ORDER_INDEX	PFT_11		☐	CRMT_BOOLEAN	☐	Logical Variable
39	PFT_12	CRMD_ORDER_INDEX	PFT_12		☐	CRMT_BOOLEAN	☐	Logical Variable
40	PFT_13	CRMD_ORDER_INDEX	PFT_13		☐	CRMT_BOOLEAN	☐	Logical Variable
41	PFT_14	CRMD_ORDER_INDEX	PFT_14		☐	CRMT_BOOLEAN	☐	Logical Variable
42	PFT_15	CRMD_ORDER_INDEX	PFT_15		☐	CRMT_BOOLEAN	☐	Logical Variable
43	PFT_16	CRMD_ORDER_INDEX	PFT_16		☐	CRMT_BOOLEAN	☐	Logical Variable
44	PFT_17	CRMD_ORDER_INDEX	PFT_17		☐	CRMT_BOOLEAN	☐	Logical Variable
45	PFT_18	CRMD_ORDER_INDEX	PFT_18		☐	CRMT_BOOLEAN	☐	Logical Variable
46	PFT_19	CRMD_ORDER_INDEX	PFT_19		☐	CRMT_BOOLEAN	☐	Logical Variable
47	PFT_20	CRMD_ORDER_INDEX	PFT_20		☐	CRMT_BOOLEAN	☐	Logical Variable
48	PFT_21	CRMD_ORDER_INDEX	PFT_21		☐	CRMT_BOOLEAN	☐	Logical Variable
49	PFT_22	CRMD_ORDER_INDEX	PFT_22		☐	CRMT_BOOLEAN	☐	Logical Variable
50	PFT_23	CRMD_ORDER_INDEX	PFT_23		☐	CRMT_BOOLEAN	☐	Logical Variable
51	PFT_24	CRMD_ORDER_INDEX	PFT_24		☐	CRMT_BOOLEAN	☐	Logical Variable
52	PFT_25	CRMD_ORDER_INDEX	PFT_25		☐	CRMT_BOOLEAN	☐	Logical Variable
53	PFT_26	CRMD_ORDER_INDEX	PFT_26		☐	CRMT_BOOLEAN	☐	Logical Variable
54	PFT_27	CRMD_ORDER_INDEX	PFT_27		☐	CRMT_BOOLEAN	☐	Logical Variable
55	PFT_28	CRMD_ORDER_INDEX	PFT_28		☐	CRMT_BOOLEAN	☐	Logical Variable
56	GUID_SET	CRMD_LINK	GUID_SET		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
57	OBJTYPE_HI	CRMD_LINK	OBJTYPE_HI		☐	CRMT_OBJECT_TYPE	☐	Object Type
58	OBJTYPE_SET	CRMD_LINK	OBJTYPE_SET		☐	CRMT_OBJECT_TYPE	☐	Object Type
59	SUBJECT_PROFILE	CRMD_SRV_OSSET	SUBJECT_PROFILE		☐	CRMT_SUBJECT_PROFILE	☐	Subject Profile
60	PROFILE_TYPE	CRMD_SRV_OSSET	PROFILE_TYPE		☐	CRMT_SUBJECT_PROFILE_TYPE	☐	Subject Profile Category
61	KATALOGART	CRMD_SRV_SUBJECT	KATALOGART		☐	COMT_CATALOG	☐	Catalog
62	CODEGRUPPE	CRMD_SRV_SUBJECT	CODEGRUPPE		☐	QCODEGRP	☐	Code Group
63	CODE	CRMD_SRV_SUBJECT	CODE		☐	QCODE	☐	Code
64	GUID_SUBJECT	CRMD_SRV_SUBJECT	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object

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	350