SAP ABAP View CRMV_INDEX_JEST (View for general selection using 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_INDEX_JEST
Short Description	View for general selection using 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	CRM_JEST
3	CRMD_ORDERADM_H

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRM_JEST	OBJNR	JL	EQ				0	0
2	CRMD_ORDER_INDEX	ITEM	JR	EQ			AND	0	0
3	CRM_JEST	MANDT	JL	EQ				0	0
4	CRMD_ORDER_INDEX	CLIENT	JR	EQ			AND	0	0
5	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
6	CRMD_ORDER_INDEX	HEADER	JR	EQ			AND	0	0
7	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
8	CRMD_ORDER_INDEX	CLIENT	JR	EQ				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	STAT	CRM_JEST	STAT		☐	CRM_J_STATUS	☐	Object Status
3	INACT	CRM_JEST	INACT		☐	CRM_J_INACT	☐	Indicator: Status Is Inactive
4	HEADER	CRMD_ORDER_INDEX	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
5	OBJECT_TYPE	CRMD_ORDER_INDEX	OBJECT_TYPE		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
6	ITEM	CRMD_ORDER_INDEX	ITEM		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
7	PARTNER_NO	CRMD_ORDER_INDEX	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
8	DATE_1	CRMD_ORDER_INDEX	DATE_1		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
9	DATE_2	CRMD_ORDER_INDEX	DATE_2		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
10	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction ID
11	PROCESS_TYPE	CRMD_ORDERADM_H	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE_DB	☐	Business Transaction Type
12	PO_NUMBER_UC	CRMD_ORDER_INDEX	PO_NUMBER_UC		☐	CRMT_PO_NUMBER_UC	☐	Sold-to Party's External Reference No. (in Capital Letters)
13	POSTING_DATE	CRMD_ORDERADM_H	POSTING_DATE		☐	CRMT_POSTING_DATE	☐	Posting Date for a Business Transaction
14	CURR_PHASE	CRMD_ORDER_INDEX	CURR_PHASE		☐	CRMT_CURR_PHASE	☐	Sales Stage
15	IMPORTANCE	CRMD_ORDER_INDEX	IMPORTANCE		☐	CRMT_IMPORTANCE	☐	Opportunity/Lead Priority
16	PFT_0	CRMD_ORDER_INDEX	PFT_0		☐	CRMT_BOOLEAN	☐	Logical Variable
17	PFT_1	CRMD_ORDER_INDEX	PFT_1		☐	CRMT_BOOLEAN	☐	Logical Variable
18	PFT_2	CRMD_ORDER_INDEX	PFT_2		☐	CRMT_BOOLEAN	☐	Logical Variable
19	PFT_3	CRMD_ORDER_INDEX	PFT_3		☐	CRMT_BOOLEAN	☐	Logical Variable
20	PFT_4	CRMD_ORDER_INDEX	PFT_4		☐	CRMT_BOOLEAN	☐	Logical Variable
21	PFT_5	CRMD_ORDER_INDEX	PFT_5		☐	CRMT_BOOLEAN	☐	Logical Variable
22	PFT_6	CRMD_ORDER_INDEX	PFT_6		☐	CRMT_BOOLEAN	☐	Logical Variable
23	PFT_7	CRMD_ORDER_INDEX	PFT_7		☐	CRMT_BOOLEAN	☐	Logical Variable
24	PFT_8	CRMD_ORDER_INDEX	PFT_8		☐	CRMT_BOOLEAN	☐	Logical Variable
25	PFT_9	CRMD_ORDER_INDEX	PFT_9		☐	CRMT_BOOLEAN	☐	Logical Variable
26	PFT_10	CRMD_ORDER_INDEX	PFT_10		☐	CRMT_BOOLEAN	☐	Logical Variable
27	PFT_11	CRMD_ORDER_INDEX	PFT_11		☐	CRMT_BOOLEAN	☐	Logical Variable
28	PFT_12	CRMD_ORDER_INDEX	PFT_12		☐	CRMT_BOOLEAN	☐	Logical Variable
29	PFT_13	CRMD_ORDER_INDEX	PFT_13		☐	CRMT_BOOLEAN	☐	Logical Variable
30	PFT_14	CRMD_ORDER_INDEX	PFT_14		☐	CRMT_BOOLEAN	☐	Logical Variable
31	PFT_15	CRMD_ORDER_INDEX	PFT_15		☐	CRMT_BOOLEAN	☐	Logical Variable
32	PFT_16	CRMD_ORDER_INDEX	PFT_16		☐	CRMT_BOOLEAN	☐	Logical Variable
33	PRODUCT_ID	CRMD_ORDER_INDEX	PRODUCT_ID		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
34	CATEGORY_ID	CRMD_ORDER_INDEX	CATEGORY_ID		☐	COMT_CATEGORY_ID	☐	Category ID
35	CATALOG_ID	CRMD_ORDER_INDEX	CATALOG_ID		☐	CRMT_CATALOG	☐	Catalog ID from which the line was selected
36	DESCRIPT_PARTNER	CRMD_ORDER_INDEX	DESCRIPT_PARTNER		☐	CRMT_ITEM_DESCR_PARTNER	☐	Product Number of Business Partner
37	PURCH_ORG	CRMD_ORDER_INDEX	PURCH_ORG		☐	CRMT_PURCH_ORG	☐	Purchasing Organization
38	CREATED_BY	CRMD_ORDERADM_H	CREATED_BY		☐	CRMT_CREATED_BY	☐	User that Created the Transaction
39	CREATED_AT	CRMD_ORDERADM_H	CREATED_AT		☐	COMT_CREATED_AT_USR	☐	Created At (Output in User Time Zone)
40	STAT_OPEN	CRMD_ORDER_INDEX	STAT_OPEN		☐	CRMT_STATUS_OPEN	☐	Transaction is Still Open
41	CHANGED_AT	CRMD_ORDERADM_H	CHANGED_AT		☐	COMT_CHANGED_AT_USR	☐	Changed At (Output in User Time Zone)

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