SAP ABAP Table FILA_RE_S_TR_I_ALV_CELL (Structure: Result of Selection for Refin. (ALV List Output))

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ FI-LA (Application Component) Lease Accounting
     ⤷ FI_LA_RE_UI (Package) User Interface for Refinancing Solution

Basic Data

Table Category	INTTAB	Structure
Structure	FILA_RE_S_TR_I_ALV_CELL	Table Relationship Diagram
Short Description	Structure: Result of Selection for Refin. (ALV List Output)

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	Structure: Result of Selection for Refin. (ALV List Output)
2	.INCLUDE	☐				0	0	Key: Tranche Item Structure: Selection Result for Refin.
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	TRNO	☐	FILA_RE_E_TRNO	FILA_RE_TRNO	CHAR	10	0	Tranche Number	FILA_RE_TR_H
5	OBJID	☐	FILA_OBJID		RAW	16	0	Object Number	LAE_CRM_ITEMS
6	SUBID	☐	FILA_SUBID		NUMC	5	0	Subobject Number	LAE_CRM_ITEMS
7	TMSTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	LAE_CRM_ITEMS
8	.INCLUDE	☐				0	0	Tranche Item Structure: Result of Selection for Refinancing
9	VTYPE	☐	FILA_RE_E_VTYPE	FILA_RE_VTYPE	CHAR	1	0	Partner Contract Type of Source Document
10	OBJECTID	☐	FILA_REFOBJ	FILA_REFOBJ	CHAR	10	0	Contract Number	*
11	ITEMNO	☐	FILA_ITEMNO		NUMC	10	0	Item Number
12	STATUS_TR_I	☐	FILA_RE_E_TRI_STAT	FILA_RE_TRI_STAT	CHAR	2	0	Status of Tranche Item Data (Refinancing)
13	DAT_STATUS	☐	FILA_RE_E_DAT_STATUS	DDAT	DATS	8	0	Date of Status
14	.INCLUDE	☐				0	0	Structure Result Fields per Tranche Item for Refinancing
15	PRESVAL	☐	FILA_RE_E_PRESVAL	T_PRESVAL	CURR	17	2	Present Value
16	RESVAL_S	☐	FILA_RE_E_RESVAL_S	T_PRESVAL	CURR	17	2	Residual Value of Source Document
17	RESVAL_T	☐	FILA_RE_E_RESVAL_T	T_PRESVAL	CURR	17	2	Residual Value of Target Document
18	ADD_AMOUNT	☐	FILA_RE_E_ADD_AMOUNT	T_PRESVAL	CURR	17	2	Additional Amount
19	DP_AMOUNT	☐	FILA_RE_E_DP_AMOUNT	T_PRESVAL	CURR	17	2	Leasing Special Payment
20	SALES_PRICE	☐	FILA_RE_E_SALES_PRICE	T_PRESVAL	CURR	17	2	Sales Price
21	RESIDUALTERM	☐	FILA_RE_E_RESIDUALTERM	NUMC3	NUMC	3	0	Remaining Term
22	INTEREST	☐	FILA_RE_E_INTEREST	DEC3_7	DEC	10	7	Interest Rate for Refinancing
23	INTEREST_INSTAL	☐	FILA_RE_E_INTEREST_INSTAL	DEC3_7	DEC	10	7	Interest Rate for Present Value Calculation
24	OUTSTAND_PAY	☐	FILA_RE_E_OUTSTAND_PAY	T_PRESVAL	CURR	17	2	Total of Outstanding Payments
25	.INCLUDE	☐				0	0	Structure Result Fieldcs per Tranche Item for Return Trans.
26	PRGNO	☐	FILA_RE_E_PRGNO	FILA_RE_PRGNO	CHAR	10	0	Refinancing Program Number	FILA_RE_PRG
27	DUE	☐	FILA_RE_E_DUE	FILA_RE_DUE	NUMC	1	0	Due Date of Return Transaction (Lease Refinancing)
28	CLUSTER_TYP	☐	FILA_RE_E_CLUSTER_TYP	FILA_RE_CLUSTER_TYP	CHAR	2	0	Cluster Type in Refinancing
29	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
30	RSTATUS_TR_I	☐	FILA_RE_E_TRI_STAT_RET	FILA_RE_TRI_STAT_RET	CHAR	2	0	Status of Tranche Item Data (Return Transaction)
31	CANCEL_REASON	☐	FILA_RE_E_CANCEL_REASON	FILA_RE_CANCEL_REASON	CHAR	4	0	Cancellation Reason
32	RESVAL_MAN	☐	FILA_RE_E_RESVAL_MAN	T_PRESVAL	CURR	17	2	Market Value at End of Refinancing
33	SELMODE	☐	FILA_RE_E_SELMODE	FILA_RE_SELMODE	CHAR	1	0	Selection Mode for Return Transaction Report
34	PVTYPE	☐	FILA_RE_E_PVTYPE	FILA_RE_VTYPE	CHAR	1	0	Partner Contract Type of Target Document
35	PBUKRS	☐	PBUKRS	BUKRS	CHAR	4	0	Company code of partner	T001
36	POBJID	☐	FILA_OBJID_REF		RAW	16	0	Object Number of Reference Object
37	PSUBID	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
38	PTMSTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
39	POBJECTID	☐	FILA_RE_E_FILA_REFOBJ_REF	FILA_REFOBJ	CHAR	10	0	Contract Number of Reference Object	*
40	PITEMNO	☐	FILA_RE_E_FILA_ITEMNO_REF		NUMC	10	0	Item Number of Reference Object
41	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
42	CREATED_AT	☐	FILA_RE_E_CREATED_AT	BCOS_TSTMP	DEC	15	0	Created On
43	CREATED_BY	☐	FILA_RE_E_CREATED_BY	UNAME	CHAR	12	0	Created By
44	CHANGED_AT	☐	FILA_RE_E_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Changed On
45	CHANGED_BY	☐	FILA_RE_E_CHANGED_BY	UNAME	CHAR	12	0	Changed By
46	.INCLUDE	☐				0	0	Structure: Refinancing Category
47	REFITYP	☐	FILA_RE_E_REFITYP	FILA_RE_REFITYP	CHAR	4	0	Refinancing Type
48	TIMEUNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
49	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
50	CREATED_AT_UI	☐	FILA_RE_E_CREATED_AT_UI	DDAT	DATS	8	0	Created On
51	CHANGED_AT_UI	☐	FILA_RE_E_CHANGED_AT_UI	DDAT	DATS	8	0	Changed on
52	.INCLUDE	☐				0	0	Log. DB: Contract Items for Refin. w/o FILA_GF_KEY
53	.INCLUDE	☐				0	0	LAE: Contract Item Substructure: Gen. Data w/o ITEMNO, CURR
54	EVENT	☐	FILA_EVENT	FILA_EVENT	CHAR	20	0	Process	TFILA_GF_000P
55	STATUS	☐	FILA_STATUS	FILA_STATUS	NUMC	1	0	Processing Status
56	ITEMTXT	☐	FILA_ITEMTXT	TEXT50	CHAR	50	0	Item Description
57	EXCHG_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
58	QUANTITY	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
59	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
60	BUKRS_REF	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
61	OBJID_REF	☐	FILA_OBJID_REF		RAW	16	0	Object Number of Reference Object
62	SUBID_REF	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
63	.INCLUDE	☐				0	0	LAE: Substructure Contract Item Dates/Term
64	CONTSTARTDT	☐	FILA_CONTSTARTDT	DATUM	DATS	8	0	Start Date of Contract for Contract Item
65	CONTENDDT	☐	FILA_CONTENDDT	DATUM	DATS	8	0	End Date of Contract for Contract Item
66	LEASTARTDT	☐	FILA_LEASTARTDT	DATUM	DATS	8	0	Date on Which Contract Processes Are Active(Lease Start Date
67	LEASOPTEXEDT	☐	FILA_LEASOPTEXEDT	DATUM	DATS	8	0	Option Exercise Date
68	TERM	☐	FILA_TERM	NUMC3	NUMC	3	0	Contract Term (in Months)
69	REM_USEFUL_LIFE	☐	FILA_REMAINING_USEFUL_LIFE		NUMC	3	0	Remaining Useful Life
70	.INCLUDE	☐				0	0	LAE: Substructure Contract Item Sales Data
71	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
72	USEDPRODUCT	☐	FILA_USEDPRODUCT	XFELD	CHAR	1	0	Used Goods
73	CUSTGROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
74	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
75	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
76	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
77	INSTAT	☐	FILA_INSTAT	KUNNR	CHAR	10	0	Installation Location	*
78	FINPROD	☐	FILA_FINPROD	MATNR	CHAR	18	0	Financing Product	*
79	FINCLAS	☐	FILA_FINCLASSIFICATION	FILA_FINCLASSIFICATION	CHAR	2	0	Classification of Financing Type
80	BP_USAGE	☐	FILA_BP_USAGE	FILA_BP_USAGE	CHAR	1	0	Use of Billing Plan
81	DEVICECLASS	☐	FILA_DEVICECLASS		CHAR	10	0	Device Class
82	OPTIONID	☐	FILA_OPTIONID	FILA_OPTIONID	CHAR	2	0	Option ID	*
83	CLASSIF_LOCAL	☐	FILA_CLASSLO		CHAR	2	0	Tax Financing Classification - Local
84	CLASSIF_GROUP	☐	FILA_CLASSGR		CHAR	2	0	Tax Financing Classification - Group
85	CLASSIF_LO_FLAG	☐	FILA_CLASSLO_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
86	CLASSIF_GR_FLAG	☐	FILA_CLASSGR_FLAG	XFELD	CHAR	1	0	Forced Classification
87	CLAS_CUSTOMER	☐	FILA_CLASSCU		CHAR	2	0	Classification - Customer
88	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
89	CLASSIF_LOCALBK	☐	FILA_CLASSLOCBK		CHAR	2	0	Book Financing Classification - Local
90	CLASSIF_GROUPBK	☐	FILA_CLASSGRPBK		CHAR	2	0	Book Financing Classification - Group
91	CLASSIF_LOBK_FL	☐	FILA_CLASSLOCBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
92	CLASSIF_GRBK_FL	☐	FILA_CLASSGRPBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
93	INTRATE	☐	FILA_INTRATE	AFPROZ	DEC	7	4	Annual Interest Rate
94	PROC_INDICATOR	☐	FILA_PROC_CNTRL_INDICATOR	FILA_PROC_CNTRL_INDICATOR	NUMC	1	0	Process Indicator for Leveraged Debt Cost
95	BU_ID_NUMBER	☐	FILA_BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
96	BU_ID_TYPE	☐	FILA_BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
97	BU_PARTNER	☐	FILA_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
98	BEMOT	☐	FILA_BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
99	BUAG_ID	☐	FILA_BUAG_ID	CHAR12	CHAR	12	0	Business Agreement Number
100	.INCLUDE	☐				0	0	Dates Relevant for Accrual Engine/OTP
101	DATE_FROM	☐	FILA_ACE_DATEFROM	DATS	DATS	8	0	From Date of an Entry
102	VALITY_FROM	☐	FILA_ACE_VALDATE_FROM		DATS	8	0	Start of Life of an Accrual Subobject
103	VALITY_TO	☐	FILA_ACE_VALDATE_TO		DATS	8	0	End of Life of an Accrual Subobject
104	EFFDATE	☐			DATS	8	0
105	EFFDATE_ORIG	☐			DATS	8	0
106	.INCLUDE	☐				0	0	Dates for Posting to Accounting (FI-AA)
107	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
108	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
109	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
110	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
111	UBZDT	☐	UBZDT	DATUM	DATS	8	0	Original value date of transaction
112	.INCLUDE	☐				0	0	Data for Entering Asset Transactions
113	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
114	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
115	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
116	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
117	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
118	ANBTR	☐	ANBTR	ANLKWERT	CURR	13	2	Amount posted
119	PROZS	☐	FILA_PROZS		DEC	16	13	Retirement Percentage Rate
120	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
121	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
122	XANEU	☐	XANEU	XFELD	CHAR	1	0	Indicator: Transaction relates to curr.-yr acquisition
123	XVABG	☐	XVABG	XFELD	CHAR	1	0	Indicator: Post complete retirement
124	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
125	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number
126	.INCLUDE	☐				0	0	* Original Date Entries
127	BUDAT_ORIG	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
128	BZDAT_ORIG	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
129	GJAHR_ORIG	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
130	MONAT_ORIG	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
131	DATE_FROM_ORIG	☐	FILA_ACE_DATEFROM	DATS	DATS	8	0	From Date of an Entry
132	.INCLUDE	☐				0	0	Log. DB: Parameter
133	CLASS	☐	FILA_CLASS	FILA_CLASS	CHAR	8	0	Financing Classification	*
134	IIR	☐	FILA_IIR	FILA_DECV4_5	DEC	9	5	Internal Rate of Return
135	VALUEID	☐	FILA_VALUEID	FILA_VALUEID	CHAR	10	0	Value ID
136	TMSTAMPESP	☐	FILA_TMSTAMPESP	TZNTSTMPS	DEC	15	0	Time Stamp - Processed Successfully (BW Delta Extraction)
137	ALLOCATION_ID	☐	FILA_ALLOCATION_ID	CHAR16	CHAR	16	0	External Assignment Indicator
138	CELL	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FILA_RE_S_TR_I_ALV_CELL	BUKRS	T001	BUKRS
2	FILA_RE_S_TR_I_ALV_CELL	BUKRS_REF	T001	BUKRS
3	FILA_RE_S_TR_I_ALV_CELL	CUSTGROUP	T151	KDGRP	REF	1	CN
4	FILA_RE_S_TR_I_ALV_CELL	DIS_CHANNEL	TVTW	VTWEG	REF	1	CN
5	FILA_RE_S_TR_I_ALV_CELL	EVENT	TFILA_GF_000P	EVENT
6	FILA_RE_S_TR_I_ALV_CELL	MANDT	T000	MANDT
7	FILA_RE_S_TR_I_ALV_CELL	OBJID	LAE_CRM_ITEMS	OBJID
8	FILA_RE_S_TR_I_ALV_CELL	PBUKRS	T001	BUKRS
9	FILA_RE_S_TR_I_ALV_CELL	PRGNO	FILA_RE_PRG	MANDT
10	FILA_RE_S_TR_I_ALV_CELL	SALESORG	TVKO	VKORG	REF	1	CN
11	FILA_RE_S_TR_I_ALV_CELL	SOLDTO	KNA1	KUNNR	REF	1	CN
12	FILA_RE_S_TR_I_ALV_CELL	SUBID	LAE_CRM_ITEMS	SUBID
13	FILA_RE_S_TR_I_ALV_CELL	TMSTAMP	LAE_CRM_ITEMS	TMSTAMP
14	FILA_RE_S_TR_I_ALV_CELL	TRNO	FILA_RE_TR_H	MANDT
15	FILA_RE_S_TR_I_ALV_CELL	UNIT	T006	MSEHI

History

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