SAP ABAP View V_LAECRM_ITEMS (View LAE_CRM_ITEMS for LDB)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ FI-LA (Application Component) Lease Accounting
     ⤷ FI_LA_ACE (Package) Leasing Accounting - Accruals

Basic Data

View Type	D	Database View
Database View	V_LAECRM_ITEMS
Short Description	View LAE_CRM_ITEMS for LDB
Root table	LAE_CRM_ITEMS	LAE: Contract Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LAE_CRM_ITEMS	LAE_CRM_ITEMS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LAE_CRM_ITEMS	MANDT		☐	MANDT	☐	Client
2	BUKRS	LAE_CRM_ITEMS	BUKRS		☐	BUKRS	☐	Company Code
3	OBJID	LAE_CRM_ITEMS	OBJID		☐	FILA_OBJID	☐	Object Number
4	REF_SUBKEY	LAE_CRM_ITEMS	SUBID		☐	FILA_SUBID	☐	Subobject Number
5	*	LAE_CRM_ITEMS	*		☐		☐
6	TMSTAMP	LAE_CRM_ITEMS	TMSTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	EVENT	LAE_CRM_ITEMS	EVENT		☐	FILA_EVENT	☐	Process
8	STATUS	LAE_CRM_ITEMS	STATUS		☐	FILA_STATUS	☐	Processing Status
9	ITEMNO	LAE_CRM_ITEMS	ITEMNO		☐	FILA_ITEMNO	☐	Item Number
10	ITEMNO_EXT	LAE_CRM_ITEMS	ITEMNO_EXT		☐	FILA_ITEMNO_EXT	☐	External Item Number
11	ITEMTXT	LAE_CRM_ITEMS	ITEMTXT		☐	FILA_ITEMTXT	☐	Item Description
12	CURRENCY	LAE_CRM_ITEMS	CURRENCY		☐	WAERS	☐	Currency Key
13	EXCHG_RATE	LAE_CRM_ITEMS	EXCHG_RATE		☐	KURSF	☐	Exchange rate
14	QUANTITY	LAE_CRM_ITEMS	QUANTITY		☐	AM_MENGE	☐	Quantity
15	UNIT	LAE_CRM_ITEMS	UNIT		☐	MEINS	☐	Base Unit of Measure
16	BUKRS_REF	LAE_CRM_ITEMS	BUKRS_REF		☐	BUKRS	☐	Company Code
17	OBJID_REF	LAE_CRM_ITEMS	OBJID_REF		☐	FILA_OBJID_REF	☐	Object Number of Reference Object
18	SUBID_REF	LAE_CRM_ITEMS	SUBID_REF		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
19	SUBID_STG	LAE_CRM_ITEMS	SUBID_STG		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
20	UIID	LAE_CRM_ITEMS	UIID		☐	FILA_UIID	☐	Unique Item ID in Life Cycle
21	EXT_POS_REF	LAE_CRM_ITEMS	EXT_POS_REF		☐	FILA_EXT_ITEM_REF	☐	External Item Reference
22	FREE_POS_REF	LAE_CRM_ITEMS	FREE_POS_REF		☐	FILA_FREE_EXT_ITEM_REF	☐	Custom External Item Reference
23	CONTSTARTDT	LAE_CRM_ITEMS	CONTSTARTDT		☐	FILA_CONTSTARTDT	☐	Start Date of Contract for Contract Item
24	CONTENDDT	LAE_CRM_ITEMS	CONTENDDT		☐	FILA_CONTENDDT	☐	End Date of Contract for Contract Item
25	LEASTARTDT	LAE_CRM_ITEMS	LEASTARTDT		☐	FILA_LEASTARTDT	☐	Date on Which Contract Processes Are Active(Lease Start Date
26	LEASOPTEXEDT	LAE_CRM_ITEMS	LEASOPTEXEDT		☐	FILA_LEASOPTEXEDT	☐	Option Exercise Date
27	TERM	LAE_CRM_ITEMS	TERM		☐	FILA_TERM	☐	Contract Term (in Months)
28	REM_USEFUL_LIFE	LAE_CRM_ITEMS	REM_USEFUL_LIFE		☐	FILA_REMAINING_USEFUL_LIFE	☐	Remaining Useful Life
29	PRODUCT	LAE_CRM_ITEMS	PRODUCT		☐	MATNR	☐	Material Number
30	USEDPRODUCT	LAE_CRM_ITEMS	USEDPRODUCT		☐	FILA_USEDPRODUCT	☐	Used Goods
31	CUSTGROUP	LAE_CRM_ITEMS	CUSTGROUP		☐	KDGRP	☐	Customer group
32	SALESORG	LAE_CRM_ITEMS	SALESORG		☐	VKORG	☐	Sales Organization
33	DIS_CHANNEL	LAE_CRM_ITEMS	DIS_CHANNEL		☐	VTWEG	☐	Distribution Channel
34	SOLDTO	LAE_CRM_ITEMS	SOLDTO		☐	KUNAG	☐	Sold-to party
35	INSTAT	LAE_CRM_ITEMS	INSTAT		☐	FILA_INSTAT	☐	Installation Location
36	FINPROD	LAE_CRM_ITEMS	FINPROD		☐	FILA_FINPROD	☐	Financing Product
37	FINCLAS	LAE_CRM_ITEMS	FINCLAS		☐	FILA_FINCLASSIFICATION	☐	Classification of Financing Type
38	BP_USAGE	LAE_CRM_ITEMS	BP_USAGE		☐	FILA_BP_USAGE	☐	Use of Billing Plan
39	DEVICECLASS	LAE_CRM_ITEMS	DEVICECLASS		☐	FILA_DEVICECLASS	☐	Device Class
40	OPTIONID	LAE_CRM_ITEMS	OPTIONID		☐	FILA_OPTIONID	☐	Option ID
41	CLASSIF_LOCAL	LAE_CRM_ITEMS	CLASSIF_LOCAL		☐	FILA_CLASSLO	☐	Tax Financing Classification - Local
42	CLASSIF_GROUP	LAE_CRM_ITEMS	CLASSIF_GROUP		☐	FILA_CLASSGR	☐	Tax Financing Classification - Group
43	CLASSIF_LO_FLAG	LAE_CRM_ITEMS	CLASSIF_LO_FLAG		☐	FILA_CLASSLO_FLAG	☐	Forced Classification Indicator
44	CLASSIF_GR_FLAG	LAE_CRM_ITEMS	CLASSIF_GR_FLAG		☐	FILA_CLASSGR_FLAG	☐	Forced Classification
45	CLAS_CUSTOMER	LAE_CRM_ITEMS	CLAS_CUSTOMER		☐	FILA_CLASSCU	☐	Classification - Customer
46	BUS_AREA	LAE_CRM_ITEMS	BUS_AREA		☐	GSBER	☐	Business Area
47	CLASSIF_LOCALBK	LAE_CRM_ITEMS	CLASSIF_LOCALBK		☐	FILA_CLASSLOCBK	☐	Book Financing Classification - Local
48	CLASSIF_GROUPBK	LAE_CRM_ITEMS	CLASSIF_GROUPBK		☐	FILA_CLASSGRPBK	☐	Book Financing Classification - Group
49	CLASSIF_LOBK_FL	LAE_CRM_ITEMS	CLASSIF_LOBK_FL		☐	FILA_CLASSLOCBK_FLAG	☐	Forced Classification Indicator
50	CLASSIF_GRBK_FL	LAE_CRM_ITEMS	CLASSIF_GRBK_FL		☐	FILA_CLASSGRPBK_FLAG	☐	Forced Classification Indicator
51	INTRATE	LAE_CRM_ITEMS	INTRATE		☐	FILA_INTRATE	☐	Annual Interest Rate
52	PROC_INDICATOR	LAE_CRM_ITEMS	PROC_INDICATOR		☐	FILA_PROC_CNTRL_INDICATOR	☐	Process Indicator for Leveraged Debt Cost
53	BU_ID_NUMBER	LAE_CRM_ITEMS	BU_ID_NUMBER		☐	FILA_BU_ID_NUMBER	☐	Identification Number
54	BU_ID_TYPE	LAE_CRM_ITEMS	BU_ID_TYPE		☐	FILA_BU_ID_TYPE	☐	Identification Type
55	BU_PARTNER	LAE_CRM_ITEMS	BU_PARTNER		☐	FILA_BU_PARTNER	☐	Business Partner Number
56	BEMOT	LAE_CRM_ITEMS	BEMOT		☐	FILA_BEMOT	☐	Accounting Indicator
57	BUAG_ID	LAE_CRM_ITEMS	BUAG_ID		☐	FILA_BUAG_ID	☐	Business Agreement Number
58	TMSTAMPADJ	LAE_CRM_ITEMS	TMSTAMPADJ		☐	FILA_TMSTAMPADJ	☐	Time Stamp of Last Business Transaction from CRM
59	PROCMODE	LAE_CRM_ITEMS	PROCMODE		☐	FILA_PROCMODE	☐	Processing Mode of Process
60	LOGHANDLE	LAE_CRM_ITEMS	LOGHANDLE		☐	BALLOGHNDL	☐	Application Log: Log Handle
61	TMSTAMPREV	LAE_CRM_ITEMS	TMSTAMPREV		☐	FILA_TMSTAMPREV	☐	Time Stamp of Business Transaction to be Reversed
62	ALLOCATION_ID	LAE_CRM_ITEMS	ALLOCATION_ID		☐	FILA_ALLOCATION_ID	☐	External Assignment Indicator
63	TMSTAMPESP	LAE_CRM_ITEMS	TMSTAMPESP		☐	FILA_TMSTAMPESP	☐	Time Stamp - Processed Successfully (BW Delta Extraction)
64	RUNID	LAE_CRM_ITEMS	RUNID		☐	FILA_RUNID_MIG	☐	Migration Run Number
65	BUS_SCENARIO_ID	LAE_CRM_ITEMS	BUS_SCENARIO_ID		☐	FILA_BS_IDENTIFICATION	☐	Business Scenario for Which Controlling Is Performed
66	FIELD01	LAE_CRM_ITEMS	FIELD01		☐	FILA_FIELD01	☐	Field for Customer-Specific Data
67	FIELD02	LAE_CRM_ITEMS	FIELD02		☐	FILA_FIELD02	☐	Field for Customer-Specific Data
68	FIELD03	LAE_CRM_ITEMS	FIELD03		☐	FILA_FIELD03	☐	Field for Customer-Specific Data
69	LESSOR	LAE_CRM_ITEMS	LESSOR		☐	LIFNR	☐	Account Number of Vendor or Creditor

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	20130529
SAP Release Created in	461