SAP ABAP View V_FILA_LDB_VALS (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_VALS
Short Description	Selection of Contract Item Data via Logical DB
Root table	LAE_CRM_HEADER	LAE: CRM Contract Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LAE_CRM_HEADER	LAE_CRM_HEADER
2	LAE_CRM_ITEMS	LAE_CRM_ITEMS
3	FILA_GF_ITEMDATA
4	FILA_GF_ITEMVALS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LAE_CRM_HEADER	MANDT	JL	EQ				0	0
2	LAE_CRM_ITEMS	MANDT	JR	EQ			AND	0	0
3	LAE_CRM_HEADER	BUKRS	JL	EQ				0	0
4	LAE_CRM_ITEMS	BUKRS	JR	EQ			AND	0	0
5	LAE_CRM_HEADER	OBJID	JL	EQ				0	0
6	LAE_CRM_ITEMS	OBJID	JR	EQ			AND	0	0
7	LAE_CRM_HEADER	TMSTAMP	JL	EQ				0	0
8	LAE_CRM_ITEMS	TMSTAMP	JR	EQ			AND	0	0
9	LAE_CRM_ITEMS	MANDT	JL	EQ				0	0
10	FILA_GF_ITEMDATA	MANDT	JR	EQ			AND	0	0
11	LAE_CRM_ITEMS	BUKRS	JL	EQ				0	0
12	FILA_GF_ITEMDATA	BUKRS	JR	EQ			AND	0	0
13	LAE_CRM_ITEMS	OBJID	JL	EQ				0	0
14	FILA_GF_ITEMDATA	OBJID	JR	EQ			AND	0	0
15	LAE_CRM_ITEMS	SUBID	JL	EQ				0	0
16	FILA_GF_ITEMDATA	SUBID	JR	EQ			AND	0	0
17	LAE_CRM_ITEMS	TMSTAMP	JL	EQ				0	0
18	FILA_GF_ITEMDATA	TMSTAMP	JR	EQ			AND	0	0
19	FILA_GF_ITEMDATA	MANDT	JL	EQ				0	0
20	FILA_GF_ITEMVALS	MANDT	JR	EQ			AND	0	0
21	FILA_GF_ITEMDATA	COMPONENT	JL	EQ				0	0
22	FILA_GF_ITEMVALS	COMPONENT	JR	EQ			AND	0	0
23	FILA_GF_ITEMDATA	BUKRS	JL	EQ				0	0
24	FILA_GF_ITEMVALS	BUKRS	JR	EQ			AND	0	0
25	FILA_GF_ITEMDATA	OBJID	JL	EQ				0	0
26	FILA_GF_ITEMVALS	OBJID	JR	EQ			AND	0	0
27	FILA_GF_ITEMDATA	SUBID	JL	EQ				0	0
28	FILA_GF_ITEMVALS	SUBID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LAE_CRM_HEADER	MANDT		☐	MANDT	☐	Client
2	COMPONENT	FILA_GF_ITEMDATA	COMPONENT		☐	FILA_COMPONENT	☐	Application Component
3	BUKRS	LAE_CRM_HEADER	BUKRS		☐	BUKRS	☐	Company Code
4	OBJID	LAE_CRM_HEADER	OBJID		☐	FILA_OBJID	☐	Object Number
5	SUBID	LAE_CRM_ITEMS	SUBID		☐	FILA_SUBID	☐	Subobject Number
6	TMSTAMP	LAE_CRM_HEADER	TMSTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	VALUEID	FILA_GF_ITEMVALS	VALUEID		☐	FILA_VALUEID	☐	Value ID
8	OBJECTID	LAE_CRM_HEADER	OBJECTID		☐	FILA_REFOBJ	☐	Contract Number
9	ITEMNO	LAE_CRM_ITEMS	ITEMNO		☐	FILA_ITEMNO	☐	Item Number
10	EVENT	LAE_CRM_ITEMS	EVENT		☐	FILA_EVENT	☐	Process
11	STATUS	LAE_CRM_ITEMS	STATUS		☐	FILA_STATUS	☐	Processing Status
12	CONTSTARTDT	LAE_CRM_ITEMS	CONTSTARTDT		☐	FILA_CONTSTARTDT	☐	Start Date of Contract for Contract Item
13	CONTENDDT	LAE_CRM_ITEMS	CONTENDDT		☐	FILA_CONTENDDT	☐	End Date of Contract for Contract Item
14	LEASTARTDT	LAE_CRM_ITEMS	LEASTARTDT		☐	FILA_LEASTARTDT	☐	Date on Which Contract Processes Are Active(Lease Start Date
15	LEASOPTEXEDT	LAE_CRM_ITEMS	LEASOPTEXEDT		☐	FILA_LEASOPTEXEDT	☐	Option Exercise Date
16	TERM	LAE_CRM_ITEMS	TERM		☐	FILA_TERM	☐	Contract Term (in Months)
17	PRODUCT	LAE_CRM_ITEMS	PRODUCT		☐	MATNR	☐	Material Number
18	USEDPRODUCT	LAE_CRM_ITEMS	USEDPRODUCT		☐	FILA_USEDPRODUCT	☐	Used Goods
19	CUSTGROUP	LAE_CRM_ITEMS	CUSTGROUP		☐	KDGRP	☐	Customer group
20	SALESORG	LAE_CRM_ITEMS	SALESORG		☐	VKORG	☐	Sales Organization
21	DIS_CHANNEL	LAE_CRM_ITEMS	DIS_CHANNEL		☐	VTWEG	☐	Distribution Channel
22	SOLDTO	LAE_CRM_ITEMS	SOLDTO		☐	KUNAG	☐	Sold-to party
23	FINPROD	LAE_CRM_ITEMS	FINPROD		☐	FILA_FINPROD	☐	Financing Product
24	FINCLAS	LAE_CRM_ITEMS	FINCLAS		☐	FILA_FINCLASSIFICATION	☐	Classification of Financing Type
25	DEVICECLASS	LAE_CRM_ITEMS	DEVICECLASS		☐	FILA_DEVICECLASS	☐	Device Class
26	OPTIONID	LAE_CRM_ITEMS	OPTIONID		☐	FILA_OPTIONID	☐	Option ID
27	CLASSIF_LOCAL	LAE_CRM_ITEMS	CLASSIF_LOCAL		☐	FILA_CLASSLO	☐	Tax Financing Classification - Local
28	CLASSIF_GROUP	LAE_CRM_ITEMS	CLASSIF_GROUP		☐	FILA_CLASSGR	☐	Tax Financing Classification - Group
29	CLASSIF_LO_FLAG	LAE_CRM_ITEMS	CLASSIF_LO_FLAG		☐	FILA_CLASSLO_FLAG	☐	Forced Classification Indicator
30	CLASSIF_GR_FLAG	LAE_CRM_ITEMS	CLASSIF_GR_FLAG		☐	FILA_CLASSGR_FLAG	☐	Forced Classification
31	CLAS_CUSTOMER	LAE_CRM_ITEMS	CLAS_CUSTOMER		☐	FILA_CLASSCU	☐	Classification - Customer
32	BUS_AREA	LAE_CRM_ITEMS	BUS_AREA		☐	GSBER	☐	Business Area
33	BZDAT	FILA_GF_ITEMDATA	BZDAT		☐	BZDAT	☐	Asset Value Date
34	UBZDT	FILA_GF_ITEMDATA	UBZDT		☐	UBZDT	☐	Original value date of transaction
35	BLART	FILA_GF_ITEMDATA	BLART		☐	BLART	☐	Document type
36	GJAHR	FILA_GF_ITEMDATA	GJAHR		☐	GJAHR	☐	Fiscal Year
37	MONAT	FILA_GF_ITEMDATA	MONAT		☐	MONAT	☐	Fiscal period
38	ANBTR	FILA_GF_ITEMDATA	ANBTR		☐	ANBTR	☐	Amount posted
39	PROZS	FILA_GF_ITEMDATA	PROZS		☐	FILA_PROZS	☐	Retirement Percentage Rate
40	XANEU	FILA_GF_ITEMDATA	XANEU		☐	XANEU	☐	Indicator: Transaction relates to curr.-yr acquisition
41	XVABG	FILA_GF_ITEMDATA	XVABG		☐	XVABG	☐	Indicator: Post complete retirement
42	BUDAT_ORIG	FILA_GF_ITEMDATA	BUDAT_ORIG		☐	FILA_BUDAT_ORIG	☐	Original Posting Date
43	BZDAT_ORIG	FILA_GF_ITEMDATA	BZDAT_ORIG		☐	FILA_BZDAT_ORIG	☐	Original Asset Value Date
44	GJAHR_ORIG	FILA_GF_ITEMDATA	GJAHR_ORIG		☐	FILA_GJAHR_ORIG	☐	Original Fiscal Year
45	MONAT_ORIG	FILA_GF_ITEMDATA	MONAT_ORIG		☐	FILA_MONAT_ORIG	☐	Original Fiscal Month
46	VALUE	FILA_GF_ITEMVALS	VALUE		☐	FILA_VALUE	☐	Value/Contents of Value ID
47	SUPPLYID	FILA_GF_ITEMVALS	SUPPLYID		☐	FILA_SUPPLYID	☐	Origin Indicator for Value/Content of Value ID

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