SAP ABAP View V_FILA_LDB_ITEMS (Selection of Contract Item Data via Logical DB)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_FILA_LDB_ITEMS
Short Description	Selection of Contract Item Data via Logical DB
Root table	LAE_CRM_ITEMS	LAE: Contract Items

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LAE_CRM_ITEMS	MANDT	JL	EQ				0	0
2	FILA_GF_ITEMDATA	MANDT	JR	EQ			AND	0	0
3	LAE_CRM_ITEMS	BUKRS	JL	EQ				0	0
4	FILA_GF_ITEMDATA	BUKRS	JR	EQ			AND	0	0
5	LAE_CRM_ITEMS	OBJID	JL	EQ				0	0
6	FILA_GF_ITEMDATA	OBJID	JR	EQ			AND	0	0
7	LAE_CRM_ITEMS	SUBID	JL	EQ				0	0
8	FILA_GF_ITEMDATA	SUBID	JR	EQ			AND	0	0
9	LAE_CRM_ITEMS	TMSTAMP	JL	EQ				0	0
10	FILA_GF_ITEMDATA	TMSTAMP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	FILA_GF_ITEMDATA	*		☐		☐
2	MANDT	FILA_GF_ITEMDATA	MANDT		☐	MANDT	☐	Client
3	COMPONENT	FILA_GF_ITEMDATA	COMPONENT		☐	FILA_COMPONENT	☐	Application Component
4	BUKRS	FILA_GF_ITEMDATA	BUKRS		☐	BUKRS	☐	Company Code
5	OBJID	FILA_GF_ITEMDATA	OBJID		☐	FILA_OBJID	☐	Object Number
6	SUBID	FILA_GF_ITEMDATA	SUBID		☐	FILA_SUBID	☐	Subobject Number
7	TMSTAMP	FILA_GF_ITEMDATA	TMSTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	-	FILA_GF_ITEMDATA	EVENT		☐	FILA_EVENT	☐	Process
9	-	FILA_GF_ITEMDATA	STATUS		☐	FILA_STATUS	☐	Processing Status
10	-	FILA_GF_ITEMDATA	ITEMNO		☐	FILA_ITEMNO	☐	Item Number
11	-	FILA_GF_ITEMDATA	ITEMNO_EXT		☐	FILA_ITEMNO_EXT	☐	External Item Number
12	-	FILA_GF_ITEMDATA	ITEMTXT		☐	FILA_ITEMTXT	☐	Item Description
13	-	FILA_GF_ITEMDATA	CURRENCY		☐	WAERS	☐	Currency Key
14	-	FILA_GF_ITEMDATA	EXCHG_RATE		☐	KURSF	☐	Exchange rate
15	-	FILA_GF_ITEMDATA	QUANTITY		☐	AM_MENGE	☐	Quantity
16	-	FILA_GF_ITEMDATA	UNIT		☐	MEINS	☐	Base Unit of Measure
17	-	FILA_GF_ITEMDATA	BUKRS_REF		☐	BUKRS	☐	Company Code
18	-	FILA_GF_ITEMDATA	OBJID_REF		☐	FILA_OBJID_REF	☐	Object Number of Reference Object
19	-	FILA_GF_ITEMDATA	SUBID_REF		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
20	-	FILA_GF_ITEMDATA	SUBID_STG		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
21	-	FILA_GF_ITEMDATA	UIID		☐	FILA_UIID	☐	Unique Item ID in Life Cycle
22	-	FILA_GF_ITEMDATA	EXT_POS_REF		☐	FILA_EXT_ITEM_REF	☐	External Item Reference
23	-	FILA_GF_ITEMDATA	FREE_POS_REF		☐	FILA_FREE_EXT_ITEM_REF	☐	Custom External Item Reference
24	DATE_FROM	FILA_GF_ITEMDATA	DATE_FROM		☐	FILA_DATEFROM	☐	From Date of an Entry
25	VALITY_FROM	FILA_GF_ITEMDATA	VALITY_FROM		☐	FILA_VALDATE_FROM	☐	Start of Life of an Accrual Subobject
26	VALITY_TO	FILA_GF_ITEMDATA	VALITY_TO		☐	FILA_VALDATE_TO	☐	End of Life of an Accrual Subobject
27	EFFDATE	FILA_GF_ITEMDATA	EFFDATE		☐	FILA_EFFDATE	☐	Effective Date of Event
28	BUDAT	FILA_GF_ITEMDATA	BUDAT		☐	BUDAT	☐	Posting Date in the Document
29	BLDAT	FILA_GF_ITEMDATA	BLDAT		☐	BLDAT	☐	Document Date in Document
30	WWERT	FILA_GF_ITEMDATA	WWERT		☐	WWERT_D	☐	Translation date
31	BZDAT	FILA_GF_ITEMDATA	BZDAT		☐	BZDAT	☐	Asset Value Date
32	UBZDT	FILA_GF_ITEMDATA	UBZDT		☐	UBZDT	☐	Original value date of transaction
33	ADATU	FILA_GF_ITEMDATA	ADATU		☐	ADATU	☐	Date for beginning of validity
34	BDOTP	FILA_GF_ITEMDATA	BDOTP		☐	FILA_BDOTP	☐	Posting Date for One-Time Postings LAE
35	BDOTP_ORIG	FILA_GF_ITEMDATA	BDOTP_ORIG		☐	FILA_BDOTP_ORIG	☐	Original Posting Date for One-Time Postings LAE
36	BUDAT_ORIG	FILA_GF_ITEMDATA	BUDAT_ORIG		☐	FILA_BUDAT_ORIG	☐	Original Posting Date
37	BZDAT_ORIG	FILA_GF_ITEMDATA	BZDAT_ORIG		☐	FILA_BZDAT_ORIG	☐	Original Asset Value Date
38	GJAHR_ORIG	FILA_GF_ITEMDATA	GJAHR_ORIG		☐	FILA_GJAHR_ORIG	☐	Original Fiscal Year
39	MONAT_ORIG	FILA_GF_ITEMDATA	MONAT_ORIG		☐	FILA_MONAT_ORIG	☐	Original Fiscal Month
40	DATE_FROM_ORIG	FILA_GF_ITEMDATA	DATE_FROM_ORIG		☐	FILA_ACE_DATEFROM_ORIG	☐	Original From-Date of Accrual Item
41	EFFDATE_ORIG	FILA_GF_ITEMDATA	EFFDATE_ORIG		☐	FILA_EFFDATE_ORIG	☐	Original Effective Date of Event
42	BLART	FILA_GF_ITEMDATA	BLART		☐	BLART	☐	Document type
43	WAERS	FILA_GF_ITEMDATA	WAERS		☐	WAERS	☐	Currency Key
44	KURSF	FILA_GF_ITEMDATA	KURSF		☐	KURSF	☐	Exchange rate
45	GJAHR	FILA_GF_ITEMDATA	GJAHR		☐	GJAHR	☐	Fiscal Year
46	MONAT	FILA_GF_ITEMDATA	MONAT		☐	MONAT	☐	Fiscal period
47	ANBTR	FILA_GF_ITEMDATA	ANBTR		☐	ANBTR	☐	Amount posted
48	PROZS	FILA_GF_ITEMDATA	PROZS		☐	FILA_PROZS	☐	Retirement Percentage Rate
49	MENGE	FILA_GF_ITEMDATA	MENGE		☐	MENGE_D	☐	Quantity
50	MEINS	FILA_GF_ITEMDATA	MEINS		☐	MEINS	☐	Base Unit of Measure
51	XANEU	FILA_GF_ITEMDATA	XANEU		☐	XANEU	☐	Indicator: Transaction relates to curr.-yr acquisition
52	XVABG	FILA_GF_ITEMDATA	XVABG		☐	XVABG	☐	Indicator: Post complete retirement
53	ZUONR	FILA_GF_ITEMDATA	ZUONR		☐	DZUONR	☐	Assignment number
54	GKONT	FILA_GF_ITEMDATA	GKONT		☐	GKONT	☐	Offsetting Account Number
55	-	FILA_GF_ITEMDATA	TMSTAMPADJ		☐	FILA_TMSTAMPADJ	☐	Time Stamp of Last Business Transaction from CRM
56	-	FILA_GF_ITEMDATA	PROCMODE		☐	FILA_PROCMODE	☐	Processing Mode of Process
57	-	FILA_GF_ITEMDATA	LOGHANDLE		☐	BALLOGHNDL	☐	Application Log: Log Handle
58	UNAME	FILA_GF_ITEMDATA	UNAME		☐	UNAME	☐	User Name
59	CPUDT	FILA_GF_ITEMDATA	CPUDT		☐	CPUDT	☐	Accounting document entry date
60	CPUTM	FILA_GF_ITEMDATA	CPUTM		☐	CPUTM	☐	Time of data entry
61	SEIDENT	FILA_GF_ITEMDATA	SEIDENT		☐	FILA_SEIDENT	☐	Subprocess Identifier
62	*	LAE_CRM_ITEMS	*		☐		☐
63	-	LAE_CRM_ITEMS	MANDT		☐	MANDT	☐	Client
64	-	LAE_CRM_ITEMS	BUKRS		☐	BUKRS	☐	Company Code
65	-	LAE_CRM_ITEMS	OBJID		☐	FILA_OBJID	☐	Object Number
66	-	LAE_CRM_ITEMS	SUBID		☐	FILA_SUBID	☐	Subobject Number
67	-	LAE_CRM_ITEMS	TMSTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
68	EVENT	LAE_CRM_ITEMS	EVENT		☐	FILA_EVENT	☐	Process
69	STATUS	LAE_CRM_ITEMS	STATUS		☐	FILA_STATUS	☐	Processing Status
70	ITEMNO	LAE_CRM_ITEMS	ITEMNO		☐	FILA_ITEMNO	☐	Item Number
71	ITEMNO_EXT	LAE_CRM_ITEMS	ITEMNO_EXT		☐	FILA_ITEMNO_EXT	☐	External Item Number
72	ITEMTXT	LAE_CRM_ITEMS	ITEMTXT		☐	FILA_ITEMTXT	☐	Item Description
73	CURRENCY	LAE_CRM_ITEMS	CURRENCY		☐	WAERS	☐	Currency Key
74	EXCHG_RATE	LAE_CRM_ITEMS	EXCHG_RATE		☐	KURSF	☐	Exchange rate
75	QUANTITY	LAE_CRM_ITEMS	QUANTITY		☐	AM_MENGE	☐	Quantity
76	UNIT	LAE_CRM_ITEMS	UNIT		☐	MEINS	☐	Base Unit of Measure
77	BUKRS_REF	LAE_CRM_ITEMS	BUKRS_REF		☐	BUKRS	☐	Company Code
78	OBJID_REF	LAE_CRM_ITEMS	OBJID_REF		☐	FILA_OBJID_REF	☐	Object Number of Reference Object
79	SUBID_REF	LAE_CRM_ITEMS	SUBID_REF		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
80	SUBID_STG	LAE_CRM_ITEMS	SUBID_STG		☐	FILA_SUBID_REF	☐	Reference Sub-Object Number
81	UIID	LAE_CRM_ITEMS	UIID		☐	FILA_UIID	☐	Unique Item ID in Life Cycle
82	EXT_POS_REF	LAE_CRM_ITEMS	EXT_POS_REF		☐	FILA_EXT_ITEM_REF	☐	External Item Reference
83	FREE_POS_REF	LAE_CRM_ITEMS	FREE_POS_REF		☐	FILA_FREE_EXT_ITEM_REF	☐	Custom External Item Reference
84	CONTSTARTDT	LAE_CRM_ITEMS	CONTSTARTDT		☐	FILA_CONTSTARTDT	☐	Start Date of Contract for Contract Item
85	CONTENDDT	LAE_CRM_ITEMS	CONTENDDT		☐	FILA_CONTENDDT	☐	End Date of Contract for Contract Item
86	LEASTARTDT	LAE_CRM_ITEMS	LEASTARTDT		☐	FILA_LEASTARTDT	☐	Date on Which Contract Processes Are Active(Lease Start Date
87	LEASOPTEXEDT	LAE_CRM_ITEMS	LEASOPTEXEDT		☐	FILA_LEASOPTEXEDT	☐	Option Exercise Date
88	TERM	LAE_CRM_ITEMS	TERM		☐	FILA_TERM	☐	Contract Term (in Months)
89	REM_USEFUL_LIFE	LAE_CRM_ITEMS	REM_USEFUL_LIFE		☐	FILA_REMAINING_USEFUL_LIFE	☐	Remaining Useful Life
90	PRODUCT	LAE_CRM_ITEMS	PRODUCT		☐	MATNR	☐	Material Number
91	USEDPRODUCT	LAE_CRM_ITEMS	USEDPRODUCT		☐	FILA_USEDPRODUCT	☐	Used Goods
92	CUSTGROUP	LAE_CRM_ITEMS	CUSTGROUP		☐	KDGRP	☐	Customer group
93	SALESORG	LAE_CRM_ITEMS	SALESORG		☐	VKORG	☐	Sales Organization
94	DIS_CHANNEL	LAE_CRM_ITEMS	DIS_CHANNEL		☐	VTWEG	☐	Distribution Channel
95	SOLDTO	LAE_CRM_ITEMS	SOLDTO		☐	KUNAG	☐	Sold-to party
96	INSTAT	LAE_CRM_ITEMS	INSTAT		☐	FILA_INSTAT	☐	Installation Location
97	FINPROD	LAE_CRM_ITEMS	FINPROD		☐	FILA_FINPROD	☐	Financing Product
98	FINCLAS	LAE_CRM_ITEMS	FINCLAS		☐	FILA_FINCLASSIFICATION	☐	Classification of Financing Type
99	BP_USAGE	LAE_CRM_ITEMS	BP_USAGE		☐	FILA_BP_USAGE	☐	Use of Billing Plan
100	DEVICECLASS	LAE_CRM_ITEMS	DEVICECLASS		☐	FILA_DEVICECLASS	☐	Device Class
101	OPTIONID	LAE_CRM_ITEMS	OPTIONID		☐	FILA_OPTIONID	☐	Option ID
102	CLASSIF_LOCAL	LAE_CRM_ITEMS	CLASSIF_LOCAL		☐	FILA_CLASSLO	☐	Tax Financing Classification - Local
103	CLASSIF_GROUP	LAE_CRM_ITEMS	CLASSIF_GROUP		☐	FILA_CLASSGR	☐	Tax Financing Classification - Group
104	CLASSIF_LO_FLAG	LAE_CRM_ITEMS	CLASSIF_LO_FLAG		☐	FILA_CLASSLO_FLAG	☐	Forced Classification Indicator
105	CLASSIF_GR_FLAG	LAE_CRM_ITEMS	CLASSIF_GR_FLAG		☐	FILA_CLASSGR_FLAG	☐	Forced Classification
106	CLAS_CUSTOMER	LAE_CRM_ITEMS	CLAS_CUSTOMER		☐	FILA_CLASSCU	☐	Classification - Customer
107	BUS_AREA	LAE_CRM_ITEMS	BUS_AREA		☐	GSBER	☐	Business Area
108	CLASSIF_LOCALBK	LAE_CRM_ITEMS	CLASSIF_LOCALBK		☐	FILA_CLASSLOCBK	☐	Book Financing Classification - Local
109	CLASSIF_GROUPBK	LAE_CRM_ITEMS	CLASSIF_GROUPBK		☐	FILA_CLASSGRPBK	☐	Book Financing Classification - Group
110	CLASSIF_LOBK_FL	LAE_CRM_ITEMS	CLASSIF_LOBK_FL		☐	FILA_CLASSLOCBK_FLAG	☐	Forced Classification Indicator
111	CLASSIF_GRBK_FL	LAE_CRM_ITEMS	CLASSIF_GRBK_FL		☐	FILA_CLASSGRPBK_FLAG	☐	Forced Classification Indicator
112	INTRATE	LAE_CRM_ITEMS	INTRATE		☐	FILA_INTRATE	☐	Annual Interest Rate
113	PROC_INDICATOR	LAE_CRM_ITEMS	PROC_INDICATOR		☐	FILA_PROC_CNTRL_INDICATOR	☐	Process Indicator for Leveraged Debt Cost
114	BU_ID_NUMBER	LAE_CRM_ITEMS	BU_ID_NUMBER		☐	FILA_BU_ID_NUMBER	☐	Identification Number
115	BU_ID_TYPE	LAE_CRM_ITEMS	BU_ID_TYPE		☐	FILA_BU_ID_TYPE	☐	Identification Type
116	BU_PARTNER	LAE_CRM_ITEMS	BU_PARTNER		☐	FILA_BU_PARTNER	☐	Business Partner Number
117	BEMOT	LAE_CRM_ITEMS	BEMOT		☐	FILA_BEMOT	☐	Accounting Indicator
118	BUAG_ID	LAE_CRM_ITEMS	BUAG_ID		☐	FILA_BUAG_ID	☐	Business Agreement Number
119	TMSTAMPADJ	LAE_CRM_ITEMS	TMSTAMPADJ		☐	FILA_TMSTAMPADJ	☐	Time Stamp of Last Business Transaction from CRM
120	-	LAE_CRM_ITEMS	PROCMODE		☐	FILA_PROCMODE	☐	Processing Mode of Process
121	-	LAE_CRM_ITEMS	LOGHANDLE		☐	BALLOGHNDL	☐	Application Log: Log Handle
122	TMSTAMPREV	LAE_CRM_ITEMS	TMSTAMPREV		☐	FILA_TMSTAMPREV	☐	Time Stamp of Business Transaction to be Reversed
123	ALLOCATION_ID	LAE_CRM_ITEMS	ALLOCATION_ID		☐	FILA_ALLOCATION_ID	☐	External Assignment Indicator
124	TMSTAMPESP	LAE_CRM_ITEMS	TMSTAMPESP		☐	FILA_TMSTAMPESP	☐	Time Stamp - Processed Successfully (BW Delta Extraction)
125	RUNID	LAE_CRM_ITEMS	RUNID		☐	FILA_RUNID_MIG	☐	Migration Run Number
126	BUS_SCENARIO_ID	LAE_CRM_ITEMS	BUS_SCENARIO_ID		☐	FILA_BS_IDENTIFICATION	☐	Business Scenario for Which Controlling Is Performed
127	FIELD01	LAE_CRM_ITEMS	FIELD01		☐	FILA_FIELD01	☐	Field for Customer-Specific Data
128	FIELD02	LAE_CRM_ITEMS	FIELD02		☐	FILA_FIELD02	☐	Field for Customer-Specific Data
129	FIELD03	LAE_CRM_ITEMS	FIELD03		☐	FILA_FIELD03	☐	Field for Customer-Specific Data
130	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