SAP ABAP Table FILA_LDB_ITEMS (Log. DB: Contract Items)

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

Table Category	INTTAB	Structure
Structure	FILA_LDB_ITEMS	Table Relationship Diagram
Short Description	Log. DB: Contract Items

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Object Key
2	.INCLUDE	☐				0	0	Object Key
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	COMPONENT	☐	FILA_COMPONENT	FILA_COMPONENT	CHAR	4	0	Application Component	*
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	OBJID	☐	FILA_OBJID		RAW	16	0	Object Number	*
7	SUBID	☐	FILA_SUBID		NUMC	5	0	Subobject Number
8	TMSTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	.INCLUDE	☐				0	0	LAE: Substructure for Contract Items Gen. Data
10	EVENT	☐	FILA_EVENT	FILA_EVENT	CHAR	20	0	Process	*
11	STATUS	☐	FILA_STATUS	FILA_STATUS	NUMC	1	0	Processing Status
12	ITEMNO	☐	FILA_ITEMNO		NUMC	10	0	Item Number
13	ITEMNO_EXT	☐	FILA_ITEMNO_EXT		NUMC	10	0	External Item Number
14	ITEMTXT	☐	FILA_ITEMTXT	TEXT50	CHAR	50	0	Item Description
15	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
16	EXCHG_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
17	QUANTITY	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
18	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
19	BUKRS_REF	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
20	OBJID_REF	☐	FILA_OBJID_REF		RAW	16	0	Object Number of Reference Object
21	SUBID_REF	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
22	SUBID_STG	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
23	UIID	☐	FILA_UIID	FILA_UIID	CHAR	12	0	Unique Item ID in Life Cycle
24	EXT_POS_REF	☐	FILA_EXT_ITEM_REF	FILA_EXT_ITEM_REF	CHAR	35	0	External Item Reference
25	FREE_POS_REF	☐	FILA_FREE_EXT_ITEM_REF	FILA_EXT_ITEM_REF	CHAR	35	0	Custom External Item Reference
26	.INCLUDE	☐				0	0	LAE: Substructure Contract Item Dates/Term
27	CONTSTARTDT	☐	FILA_CONTSTARTDT	DATUM	DATS	8	0	Start Date of Contract for Contract Item
28	CONTENDDT	☐	FILA_CONTENDDT	DATUM	DATS	8	0	End Date of Contract for Contract Item
29	LEASTARTDT	☐	FILA_LEASTARTDT	DATUM	DATS	8	0	Date on Which Contract Processes Are Active(Lease Start Date
30	LEASOPTEXEDT	☐	FILA_LEASOPTEXEDT	DATUM	DATS	8	0	Option Exercise Date
31	TERM	☐	FILA_TERM	NUMC3	NUMC	3	0	Contract Term (in Months)
32	REM_USEFUL_LIFE	☐	FILA_REMAINING_USEFUL_LIFE		NUMC	3	0	Remaining Useful Life
33	.INCLUDE	☐				0	0	LAE: Substructure Contract Item Sales Data
34	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
35	USEDPRODUCT	☐	FILA_USEDPRODUCT	XFELD	CHAR	1	0	Used Goods
36	CUSTGROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
37	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
38	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
39	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
40	INSTAT	☐	FILA_INSTAT	KUNNR	CHAR	10	0	Installation Location	*
41	FINPROD	☐	FILA_FINPROD	MATNR	CHAR	18	0	Financing Product	*
42	FINCLAS	☐	FILA_FINCLASSIFICATION	FILA_FINCLASSIFICATION	CHAR	2	0	Classification of Financing Type
43	BP_USAGE	☐	FILA_BP_USAGE	FILA_BP_USAGE	CHAR	1	0	Use of Billing Plan
44	DEVICECLASS	☐	FILA_DEVICECLASS		CHAR	10	0	Device Class
45	OPTIONID	☐	FILA_OPTIONID	FILA_OPTIONID	CHAR	2	0	Option ID	*
46	CLASSIF_LOCAL	☐	FILA_CLASSLO		CHAR	2	0	Tax Financing Classification - Local
47	CLASSIF_GROUP	☐	FILA_CLASSGR		CHAR	2	0	Tax Financing Classification - Group
48	CLASSIF_LO_FLAG	☐	FILA_CLASSLO_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
49	CLASSIF_GR_FLAG	☐	FILA_CLASSGR_FLAG	XFELD	CHAR	1	0	Forced Classification
50	CLAS_CUSTOMER	☐	FILA_CLASSCU		CHAR	2	0	Classification - Customer
51	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
52	CLASSIF_LOCALBK	☐	FILA_CLASSLOCBK		CHAR	2	0	Book Financing Classification - Local
53	CLASSIF_GROUPBK	☐	FILA_CLASSGRPBK		CHAR	2	0	Book Financing Classification - Group
54	CLASSIF_LOBK_FL	☐	FILA_CLASSLOCBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
55	CLASSIF_GRBK_FL	☐	FILA_CLASSGRPBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
56	INTRATE	☐	FILA_INTRATE	AFPROZ	DEC	7	4	Annual Interest Rate
57	PROC_INDICATOR	☐	FILA_PROC_CNTRL_INDICATOR	FILA_PROC_CNTRL_INDICATOR	NUMC	1	0	Process Indicator for Leveraged Debt Cost
58	BU_ID_NUMBER	☐	FILA_BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
59	BU_ID_TYPE	☐	FILA_BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
60	BU_PARTNER	☐	FILA_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
61	BEMOT	☐	FILA_BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
62	BUAG_ID	☐	FILA_BUAG_ID	CHAR12	CHAR	12	0	Business Agreement Number
63	.INCLUDE	☐				0	0	Dates Relevant for Accrual Engine/OTP
64	DATE_FROM	☐	FILA_ACE_DATEFROM	DATS	DATS	8	0	From Date of an Entry
65	VALITY_FROM	☐	FILA_ACE_VALDATE_FROM		DATS	8	0	Start of Life of an Accrual Subobject
66	VALITY_TO	☐	FILA_ACE_VALDATE_TO		DATS	8	0	End of Life of an Accrual Subobject
67	EFFDATE	☐			DATS	8	0
68	EFFDATE_ORIG	☐			DATS	8	0
69	.INCLUDE	☐				0	0	Dates for Posting to Accounting (FI-AA)
70	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
71	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
72	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
73	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
74	UBZDT	☐	UBZDT	DATUM	DATS	8	0	Original value date of transaction
75	.INCLUDE	☐				0	0	Data for Entering Asset Transactions
76	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
77	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
78	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
79	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
80	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
81	ANBTR	☐	ANBTR	ANLKWERT	CURR	13	2	Amount posted
82	PROZS	☐	FILA_PROZS		DEC	16	13	Retirement Percentage Rate
83	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
84	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
85	XANEU	☐	XANEU	XFELD	CHAR	1	0	Indicator: Transaction relates to curr.-yr acquisition
86	XVABG	☐	XVABG	XFELD	CHAR	1	0	Indicator: Post complete retirement
87	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
88	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number
89	.INCLUDE	☐				0	0	* Original Date Entries
90	BUDAT_ORIG	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
91	BZDAT_ORIG	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
92	GJAHR_ORIG	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
93	MONAT_ORIG	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
94	DATE_FROM_ORIG	☐	FILA_ACE_DATEFROM	DATS	DATS	8	0	From Date of an Entry
95	.INCLUDE	☐				0	0	Log. DB: Parameter
96	CLASS	☐	FILA_CLASS	FILA_CLASS	CHAR	8	0	Financing Classification	*
97	IIR	☐	FILA_IIR	FILA_DECV4_5	DEC	9	5	Internal Rate of Return
98	VALUEID	☐	FILA_VALUEID	FILA_VALUEID	CHAR	10	0	Value ID
99	TMSTAMPESP	☐	FILA_TMSTAMPESP	TZNTSTMPS	DEC	15	0	Time Stamp - Processed Successfully (BW Delta Extraction)
100	ALLOCATION_ID	☐	FILA_ALLOCATION_ID	CHAR16	CHAR	16	0	External Assignment Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FILA_LDB_ITEMS	CUSTGROUP	T151	KDGRP	REF	1	CN
2	FILA_LDB_ITEMS	DIS_CHANNEL	TVTW	VTWEG	REF	1	CN
3	FILA_LDB_ITEMS	SALESORG	TVKO	VKORG	REF	1	CN
4	FILA_LDB_ITEMS	SOLDTO	KNA1	KUNNR	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	461