SAP ABAP View CRMV_ITEM_INDEX (Database view: Product 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_ITEM_INDEX
Short Description	Database view: Product 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_ORDERADM_H
3	CRM_JEST

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_ORDERADM_H	CLIENT	JR	EQ			AND	0	0
3	CRMD_ORDER_INDEX	CLIENT	JL	EQ				0	0
4	CRM_JEST	MANDT	JR	EQ			AND	0	0
5	CRMD_ORDER_INDEX	HEADER	JL	EQ				0	0
6	CRMD_ORDERADM_H	GUID	JR	EQ			AND	0	0
7	CRMD_ORDER_INDEX	HEADER	JL	EQ				0	0
8	CRM_JEST	OBJNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CRM_JEST	MANDT		☐	MANDT	☐	Client
2	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction ID
3	PARTNER_NO	CRMD_ORDER_INDEX	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
4	PO_NUMBER_UC	CRMD_ORDER_INDEX	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
5	STAT	CRM_JEST	STAT		☐	CRM_J_STATUS	☐	Object Status
6	INACT	CRM_JEST	INACT		☐	CRM_J_INACT	☐	Indicator: Status Is Inactive
7	HEADER	CRMD_ORDER_INDEX	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
8	CLIENT	CRMD_ORDERADM_H	CLIENT		☐	MANDT	☐	Client
9	PROCESS_TYPE	CRMD_ORDERADM_H	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE_DB	☐	Business Transaction Type
10	POSTING_DATE	CRMD_ORDERADM_H	POSTING_DATE		☐	CRMT_POSTING_DATE	☐	Posting Date for a Business Transaction
11	ITEM	CRMD_ORDER_INDEX	ITEM		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
12	OBJECT_TYPE	CRMD_ORDER_INDEX	OBJECT_TYPE		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
13	DATE_1	CRMD_ORDER_INDEX	DATE_1		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
14	DATE_2	CRMD_ORDER_INDEX	DATE_2		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
15	PFT_0	CRMD_ORDER_INDEX	PFT_0		☐	CRMT_BOOLEAN	☐	Logical Variable
16	PFT_1	CRMD_ORDER_INDEX	PFT_1		☐	CRMT_BOOLEAN	☐	Logical Variable
17	PFT_2	CRMD_ORDER_INDEX	PFT_2		☐	CRMT_BOOLEAN	☐	Logical Variable
18	PFT_3	CRMD_ORDER_INDEX	PFT_3		☐	CRMT_BOOLEAN	☐	Logical Variable
19	PFT_4	CRMD_ORDER_INDEX	PFT_4		☐	CRMT_BOOLEAN	☐	Logical Variable
20	PFT_5	CRMD_ORDER_INDEX	PFT_5		☐	CRMT_BOOLEAN	☐	Logical Variable
21	PFT_6	CRMD_ORDER_INDEX	PFT_6		☐	CRMT_BOOLEAN	☐	Logical Variable
22	PFT_7	CRMD_ORDER_INDEX	PFT_7		☐	CRMT_BOOLEAN	☐	Logical Variable
23	PFT_8	CRMD_ORDER_INDEX	PFT_8		☐	CRMT_BOOLEAN	☐	Logical Variable
24	PFT_9	CRMD_ORDER_INDEX	PFT_9		☐	CRMT_BOOLEAN	☐	Logical Variable
25	PFT_10	CRMD_ORDER_INDEX	PFT_10		☐	CRMT_BOOLEAN	☐	Logical Variable
26	PFT_11	CRMD_ORDER_INDEX	PFT_11		☐	CRMT_BOOLEAN	☐	Logical Variable
27	PFT_12	CRMD_ORDER_INDEX	PFT_12		☐	CRMT_BOOLEAN	☐	Logical Variable
28	PFT_13	CRMD_ORDER_INDEX	PFT_13		☐	CRMT_BOOLEAN	☐	Logical Variable
29	PFT_14	CRMD_ORDER_INDEX	PFT_14		☐	CRMT_BOOLEAN	☐	Logical Variable
30	PFT_15	CRMD_ORDER_INDEX	PFT_15		☐	CRMT_BOOLEAN	☐	Logical Variable
31	PFT_16	CRMD_ORDER_INDEX	PFT_16		☐	CRMT_BOOLEAN	☐	Logical Variable
32	PRODUCT_ID	CRMD_ORDER_INDEX	PRODUCT_ID		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
33	CATEGORY_ID	CRMD_ORDER_INDEX	CATEGORY_ID		☐	COMT_CATEGORY_ID	☐	Category ID
34	CATALOG_ID	CRMD_ORDER_INDEX	CATALOG_ID		☐	CRMT_CATALOG	☐	Catalog ID from which the line was selected
35	DESCRIPT_PARTNER	CRMD_ORDER_INDEX	DESCRIPT_PARTNER		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner

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	20C