SAP ABAP View CRMV_LEASING_IDX (Leasing: General Selection Using crmd_order_index)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM-BTX (Application Component) Business Transaction Leasing
     ⤷ CRM_LEASING_SRM (Package) Leasing: Connection to SRM

Basic Data

View Type	D	Database View
Database View	CRMV_LEASING_IDX
Short Description	Leasing: 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	CRMD_ORDERADM_H
3	CRMD_ORDERADM_I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
2	CRMD_ORDER_INDEX	HEADER	JR	EQ			AND	0	0
3	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
4	CRMD_ORDER_INDEX	CLIENT	JR	EQ			AND	0	0
5	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
6	CRMD_ORDER_INDEX	ITEM	JR	EQ			AND	0	0
7	CRMD_ORDERADM_I	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	HEADER	CRMD_ORDER_INDEX	HEADER		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	ITEM	CRMD_ORDER_INDEX	ITEM		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	OBJECT_TYPE	CRMD_ORDER_INDEX	OBJECT_TYPE		☐	CRMT_SUBOBJECT_CATEGORY	☐	Business Transaction Category
5	PARTNER_NO	CRMD_ORDER_INDEX	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
6	SALES_ORG	CRMD_ORDER_INDEX	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
7	DIS_CHANNEL	CRMD_ORDER_INDEX	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
8	DIVISION	CRMD_ORDER_INDEX	DIVISION		☐	CRMT_DIVISION	☐	Division
9	SALES_OFFICE	CRMD_ORDER_INDEX	SALES_OFFICE		☐	CRMT_SALES_OFFICE	☐	Sales Office
10	SALES_GROUP	CRMD_ORDER_INDEX	SALES_GROUP		☐	CRMT_SALES_GROUP	☐	Sales Group
11	PURCH_ORG	CRMD_ORDER_INDEX	PURCH_ORG		☐	CRMT_PURCH_ORG	☐	Purchasing Organization
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	PRODUCT_ID	CRMD_ORDER_INDEX	PRODUCT_ID		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
14	CATEGORY_ID	CRMD_ORDER_INDEX	CATEGORY_ID		☐	COMT_CATEGORY_ID	☐	Category ID
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	PFT_19	CRMD_ORDER_INDEX	PFT_19		☐	CRMT_BOOLEAN	☐	Logical Variable
33	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction ID
34	PROCESS_TYPE	CRMD_ORDERADM_H	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE_DB	☐	Business Transaction Type
35	CREATED_AT	CRMD_ORDERADM_H	CREATED_AT		☐	COMT_CREATED_AT_USR	☐	Created At (Output in User Time Zone)
36	CREATED_BY	CRMD_ORDERADM_H	CREATED_BY		☐	CRMT_CREATED_BY	☐	User that Created the Transaction
37	CHANGED_AT	CRMD_ORDERADM_H	CHANGED_AT		☐	COMT_CHANGED_AT_USR	☐	Changed At (Output in User Time Zone)
38	CHANGED_BY	CRMD_ORDERADM_H	CHANGED_BY		☐	CRMT_CHANGED_BY	☐	Transaction Last Changed By
39	DESCRIPTION	CRMD_ORDERADM_H	DESCRIPTION		☐	CRMT_PROCESS_DESCRIPTION	☐	Transaction Description
40	POSTING_DATE	CRMD_ORDERADM_H	POSTING_DATE		☐	CRMT_POSTING_DATE	☐	Posting Date for a Business Transaction
41	ORDERED_PROD	CRMD_ORDERADM_I	ORDERED_PROD		☐	CRMT_ORDERED_PROD_DB	☐	Product Name Entered
42	DESCRIP_ITEM	CRMD_ORDERADM_I	DESCRIPTION		☐	CRMT_PRSHTEXTX_DB	☐	Product Short Text
43	NUMBER_INT	CRMD_ORDERADM_I	NUMBER_INT		☐	CRMT_ITEM_NO	☐	Item Number in Document
44	ITEM_TYPE	CRMD_ORDERADM_I	ITM_TYPE		☐	CRMT_ITEM_TYPE_DB	☐	Item Category

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	500