SAP ABAP Table V_FILA_LDB_ITEMS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_FILA_LDB_ITEMS	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_FILA_LDB_ITEMS	CUSTGROUP	T151	KDGRP	REF	1	CN
2	V_FILA_LDB_ITEMS	DIS_CHANNEL	TVTW	VTWEG	REF	1	CN
3	V_FILA_LDB_ITEMS	SALESORG	TVKO	VKORG	REF	1	CN
4	V_FILA_LDB_ITEMS	SOLDTO	KNA1	KUNNR	REF	1	CN