1. Home
  2. Resources
  3. SAP Tables
  4. FILA_RE_S_TR_I_ALV - Structure: Result of Selection for Refin. (ALV List Output)

SAP Table FILA_RE_S_TR_I_ALV

Structure: Result of Selection for Refin. (ALV List Output)

FILA_RE_S_TR_I_ALV (Structure: Result of Selection for Refin. (ALV List Output)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FILA_RE_S_TR_I_ALV to other SAP tables.

FILA_RE_S_TR_I_ALV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TRNO Tranche Number FILA_RE_E_TRNO FILA_RE_TR_H CHAR 10 0
OBJID Object Number FILA_OBJID LAE_CRM_ITEMS RAW 16 0
SUBID Subobject Number FILA_SUBID LAE_CRM_ITEMS NUMC 5 0
TMSTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP LAE_CRM_ITEMS DEC 15 0
VTYPE Partner Contract Type of Source Document FILA_RE_E_VTYPE CHAR 1 0
1 Consumer Contract
2 SALB Active Contract
3 SALB Passive Contract
4 RFF Contract
5 LRV Contract
S Contract Reserved for SALB
R Contract Reserved for RFF
L Contract Reserved for LRV
OBJECTID Contract Number FILA_REFOBJ CHAR 10 0
ITEMNO Item Number FILA_ITEMNO NUMC 10 0
STATUS_TR_I Status of Tranche Item Data (Refinancing) FILA_RE_E_TRI_STAT CHAR 2 0
01 Reserved
02 Externally Deselected
03 Manually Deselected
04 Refinanced
10 Rejected
DAT_STATUS Date of Status FILA_RE_E_DAT_STATUS DATS 8 0
PRESVAL Present Value FILA_RE_E_PRESVAL CURR 17 2
RESVAL_S Residual Value of Source Document FILA_RE_E_RESVAL_S CURR 17 2
RESVAL_T Residual Value of Target Document FILA_RE_E_RESVAL_T CURR 17 2
ADD_AMOUNT Additional Amount FILA_RE_E_ADD_AMOUNT CURR 17 2
DP_AMOUNT Leasing Special Payment FILA_RE_E_DP_AMOUNT CURR 17 2
SALES_PRICE Sales Price FILA_RE_E_SALES_PRICE CURR 17 2
RESIDUALTERM Remaining Term FILA_RE_E_RESIDUALTERM NUMC 3 0
INTEREST Interest Rate for Refinancing FILA_RE_E_INTEREST DEC 10 7
INTEREST_INSTAL Interest Rate for Present Value Calculation FILA_RE_E_INTEREST_INSTAL DEC 10 7
OUTSTAND_PAY Total of Outstanding Payments FILA_RE_E_OUTSTAND_PAY CURR 17 2
PRGNO Refinancing Program Number FILA_RE_E_PRGNO FILA_RE_PRG CHAR 10 0
DUE Due Date of Return Transaction (Lease Refinancing) FILA_RE_E_DUE NUMC 1 0
1 Before Due Date
2 Final Due Date
CLUSTER_TYP Cluster Type in Refinancing FILA_RE_E_CLUSTER_TYP CHAR 2 0
01 Terminating Change Process with Remarketing
02 Terminating Change Process w/Return Delivery w/o Remarketing
03 Terminating Change Process w/o Return Delivery
04 Terminating Change Process (No Buyback Obligation)
05 Continuing Change Process (Buyback Obligation)
06 Continuing Change Process (No Buyback Obligation)
07 Refinancing Possible
08 Final Due Date, Buyback-Relevant
BUKRS Company Code BUKRS T001 CHAR 4 0
RSTATUS_TR_I Status of Tranche Item Data (Return Transaction) FILA_RE_E_TRI_STAT_RET CHAR 2 0
01 Reserved
02 Return Transaction Processed
10 Rejected
CANCEL_REASON Cancellation Reason FILA_RE_E_CANCEL_REASON CHAR 4 0
K01 Notice Given
K02 Bankruptcy
K03 Total Loss
K04 Theft
K05 No Automobile Insurance
K06 Payment Delay
K07 Standard
K08 Early; Amicably
K09 APC Reduction
K10 Early Replacement
RESVAL_MAN Market Value at End of Refinancing FILA_RE_E_RESVAL_MAN CURR 17 2
SELMODE Selection Mode for Return Transaction Report FILA_RE_E_SELMODE CHAR 1 0
1 Selection of Contracts with Final Due Date
2 Selection of Changed, Buyback-Relevant Contracts
3 Selection of Manually Determined Contracts
PVTYPE Partner Contract Type of Target Document FILA_RE_E_PVTYPE CHAR 1 0
1 Consumer Contract
2 SALB Active Contract
3 SALB Passive Contract
4 RFF Contract
5 LRV Contract
S Contract Reserved for SALB
R Contract Reserved for RFF
L Contract Reserved for LRV
PBUKRS Company code of partner PBUKRS T001 CHAR 4 0
POBJID Object Number of Reference Object FILA_OBJID_REF RAW 16 0
PSUBID Reference Sub-Object Number FILA_SUBID_REF NUMC 5 0
PTMSTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
POBJECTID Contract Number of Reference Object FILA_RE_E_FILA_REFOBJ_REF CHAR 10 0
PITEMNO Item Number of Reference Object FILA_RE_E_FILA_ITEMNO_REF NUMC 10 0
CREATED_AT Created On FILA_RE_E_CREATED_AT DEC 15 0
CREATED_BY Created By FILA_RE_E_CREATED_BY CHAR 12 0
CHANGED_AT Changed On FILA_RE_E_CHANGED_AT DEC 15 0
CHANGED_BY Changed By FILA_RE_E_CHANGED_BY CHAR 12 0
REFITYP Refinancing Type FILA_RE_E_REFITYP CHAR 4 0
SALB Sale and Leaseback
LRV Residual Value Loan
RFF Installment Forfaiting
TIMEUNIT Default Value for Time Unit TIMEUNITDU CHAR 12 0
CURRENCY Currency Key WAERS CUKY 5 0
CREATED_AT_UI Created On FILA_RE_E_CREATED_AT_UI DATS 8 0
CHANGED_AT_UI Changed on FILA_RE_E_CHANGED_AT_UI DATS 8 0
EVENT Process FILA_EVENT TFILA_GF_000P CHAR 20 0
STATUS Processing Status FILA_STATUS NUMC 1 0
0 Not to be processed
1 Waiting for Processing
2 Error occurred during processing, restart necessary
3 Locked to Processing Due to Changed Data
4 Adjustment Deactivated
5 Prior Process Not Yet Processed
6 Check Assignment of Processing Process
7 Leave Subprocess
8 Process Is Not Processible
9 Processed Successfully
ITEMTXT Item Description FILA_ITEMTXT CHAR 50 0
EXCHG_RATE Exchange rate KURSF DEC 9 5
QUANTITY Quantity AM_MENGE QUAN 13 3
UNIT Base Unit of Measure MEINS T006 UNIT 3 0
BUKRS_REF Company Code BUKRS T001 CHAR 4 0
OBJID_REF Object Number of Reference Object FILA_OBJID_REF RAW 16 0
SUBID_REF Reference Sub-Object Number FILA_SUBID_REF NUMC 5 0
CONTSTARTDT Start Date of Contract for Contract Item FILA_CONTSTARTDT DATS 8 0
CONTENDDT End Date of Contract for Contract Item FILA_CONTENDDT DATS 8 0
LEASTARTDT Date on Which Contract Processes Are Active(Lease Start Date FILA_LEASTARTDT DATS 8 0
LEASOPTEXEDT Option Exercise Date FILA_LEASOPTEXEDT DATS 8 0
TERM Contract Term (in Months) FILA_TERM NUMC 3 0
REM_USEFUL_LIFE Remaining Useful Life FILA_REMAINING_USEFUL_LIFE NUMC 3 0
PRODUCT Material Number MATNR CHAR 18 0
USEDPRODUCT Used Goods FILA_USEDPRODUCT CHAR 1 0
X Yes
NULL No
CUSTGROUP Customer group KDGRP T151 CHAR 2 0
SALESORG Sales Organization VKORG TVKO CHAR 4 0
DIS_CHANNEL Distribution Channel VTWEG TVTW CHAR 2 0
SOLDTO Sold-to party KUNAG KNA1 CHAR 10 0
INSTAT Installation Location FILA_INSTAT CHAR 10 0
FINPROD Financing Product FILA_FINPROD CHAR 18 0
FINCLAS Classification of Financing Type FILA_FINCLASSIFICATION CHAR 2 0
01 Leasing
02 Loan
03 Rent
04 Maintenance
05 Service Financing
06 Traders
07 Product
10 Service
11 Rent with Fixed Asset
12 Pool
13 Rent Without Fixed Asset
14 Demonstration
20 Sale and Leaseback Active Contract
21 Sale and Leaseback Passive Contract
22 Residual Value Loan
23 Installment Forfaiting
51 Inception, Debit-Side
52 Inception, Debit-Side
53 After Incoming Customer Payment, Debit-Side
61 Inception, Credit-Side
62 Termination, Credit-Side
63 After Incoming Customer Payment, Credit-Side
90 Tax Financing
BP_USAGE Use of Billing Plan FILA_BP_USAGE CHAR 1 0
NULL Periodic Billing
A Revenue Plan
B Milestone Billing
U UBB Periodic Billing
1 UBB Service
2 UBB Leasing
3 UBB Usage
4 UBB Usage Aggregate Contract
5 UBB Usage Single Pool Contract
6 UBB Included
7 UBB Pool Distribution
8 UBB Usage with Asset
DEVICECLASS Device Class FILA_DEVICECLASS CHAR 10 0
OPTIONID Option ID FILA_OPTIONID CHAR 2 0
CLASSIF_LOCAL Tax Financing Classification - Local FILA_CLASSLO CHAR 2 0
CLASSIF_GROUP Tax Financing Classification - Group FILA_CLASSGR CHAR 2 0
CLASSIF_LO_FLAG Forced Classification Indicator FILA_CLASSLO_FLAG CHAR 1 0
X Yes
NULL No
CLASSIF_GR_FLAG Forced Classification FILA_CLASSGR_FLAG CHAR 1 0
X Yes
NULL No
CLAS_CUSTOMER Classification - Customer FILA_CLASSCU CHAR 2 0
BUS_AREA Business Area GSBER CHAR 4 0
CLASSIF_LOCALBK Book Financing Classification - Local FILA_CLASSLOCBK CHAR 2 0
CLASSIF_GROUPBK Book Financing Classification - Group FILA_CLASSGRPBK CHAR 2 0
CLASSIF_LOBK_FL Forced Classification Indicator FILA_CLASSLOCBK_FLAG CHAR 1 0
X Yes
NULL No
CLASSIF_GRBK_FL Forced Classification Indicator FILA_CLASSGRPBK_FLAG CHAR 1 0
X Yes
NULL No
INTRATE Annual Interest Rate FILA_INTRATE DEC 7 4
PROC_INDICATOR Process Indicator for Leveraged Debt Cost FILA_PROC_CNTRL_INDICATOR NUMC 1 0
0 Not Refinanced
1 Refinanced and Asset Sold
2 Refinanced and Asset Not Sold
BU_ID_NUMBER Identification Number FILA_BU_ID_NUMBER CHAR 60 0
BU_ID_TYPE Identification Type FILA_BU_ID_TYPE CHAR 6 0
BU_PARTNER Business Partner Number FILA_BU_PARTNER CHAR 10 0
BEMOT Accounting Indicator FILA_BEMOT CHAR 2 0
BUAG_ID Business Agreement Number FILA_BUAG_ID CHAR 12 0
DATE_FROM From Date of an Entry FILA_ACE_DATEFROM DATS 8 0
VALITY_FROM Start of Life of an Accrual Subobject FILA_ACE_VALDATE_FROM DATS 8 0
VALITY_TO End of Life of an Accrual Subobject FILA_ACE_VALDATE_TO DATS 8 0
EFFDATE DATS 8 0
EFFDATE_ORIG DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
WWERT Translation Date WWERT_D DATS 8 0
BZDAT Asset value date BZDAT DATS 8 0
UBZDT Original value date of transaction UBZDT DATS 8 0
BLART Document Type BLART CHAR 2 0
WAERS Currency Key WAERS CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
GJAHR Fiscal Year GJAHR NUMC 4 0
MONAT Fiscal Period MONAT NUMC 2 0
ANBTR Amount posted ANBTR CURR 13 2
PROZS Retirement Percentage Rate FILA_PROZS DEC 16 13
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
XANEU Indicator: Transaction relates to curr.-yr acquisition XANEU CHAR 1 0
X Yes
NULL No
XVABG Indicator: Post complete retirement XVABG CHAR 1 0
X Yes
NULL No
ZUONR Assignment Number DZUONR CHAR 18 0
GKONT Offsetting Account Number GKONT CHAR 10 0
BUDAT_ORIG Posting Date in the Document BUDAT DATS 8 0
BZDAT_ORIG Asset value date BZDAT DATS 8 0
GJAHR_ORIG Fiscal Year GJAHR NUMC 4 0
MONAT_ORIG Fiscal Period MONAT NUMC 2 0
DATE_FROM_ORIG From Date of an Entry FILA_ACE_DATEFROM DATS 8 0
CLASS Financing Classification FILA_CLASS CHAR 8 0
IIR Internal Rate of Return FILA_IIR DEC 9 5
VALUEID Value ID FILA_VALUEID CHAR 10 0
TMSTAMPESP Time Stamp - Processed Successfully (BW Delta Extraction) FILA_TMSTAMPESP DEC 15 0
ALLOCATION_ID External Assignment Indicator FILA_ALLOCATION_ID CHAR 16 0

FILA_RE_S_TR_I_ALV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FILA_RE_S_TR_I_ALV BUKRS SYST MANDT T001 Company Codes MANDT
FILA_RE_S_TR_I_ALV BUKRS FILA_RE_S_TR_I_ALV BUKRS T001 Company Codes BUKRS
FILA_RE_S_TR_I_ALV BUKRS_REF SYST MANDT T001 Company Codes MANDT
FILA_RE_S_TR_I_ALV BUKRS_REF FILA_RE_S_TR_I_ALV BUKRS_REF T001 Company Codes BUKRS
FILA_RE_S_TR_I_ALV CUSTGROUP SYST MANDT T151 Customers: Customer Groups MANDT
FILA_RE_S_TR_I_ALV CUSTGROUP FILA_RE_S_TR_I_ALV CUSTGROUP T151 Customers: Customer Groups KDGRP
FILA_RE_S_TR_I_ALV DIS_CHANNEL SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
FILA_RE_S_TR_I_ALV DIS_CHANNEL FILA_RE_S_TR_I_ALV DIS_CHANNEL TVTW Organizational Unit: Distribution Channels VTWEG
FILA_RE_S_TR_I_ALV EVENT SYST MANDT TFILA_GF_000P Processes MANDT
FILA_RE_S_TR_I_ALV EVENT * TFILA_GF_000P Processes COMPONENT
FILA_RE_S_TR_I_ALV EVENT FILA_RE_S_TR_I_ALV EVENT TFILA_GF_000P Processes EVENT
FILA_RE_S_TR_I_ALV MANDT FILA_RE_S_TR_I_ALV MANDT T000 Clients MANDT
FILA_RE_S_TR_I_ALV OBJID FILA_RE_S_TR_I_ALV OBJID LAE_CRM_ITEMS LAE: Contract Items OBJID
FILA_RE_S_TR_I_ALV OBJID FILA_RE_S_TR_I_ALV SUBID LAE_CRM_ITEMS LAE: Contract Items SUBID
FILA_RE_S_TR_I_ALV OBJID FILA_RE_S_TR_I_ALV TMSTAMP LAE_CRM_ITEMS LAE: Contract Items TMSTAMP
FILA_RE_S_TR_I_ALV OBJID FILA_RE_S_TR_I_ALV MANDT LAE_CRM_ITEMS LAE: Contract Items MANDT
FILA_RE_S_TR_I_ALV OBJID * LAE_CRM_ITEMS LAE: Contract Items BUKRS
FILA_RE_S_TR_I_ALV PBUKRS SYST MANDT T001 Company Codes MANDT
FILA_RE_S_TR_I_ALV PBUKRS FILA_RE_S_TR_I_ALV PBUKRS T001 Company Codes BUKRS
FILA_RE_S_TR_I_ALV PRGNO SYST MANDT FILA_RE_PRG Refinancing Program .INCLUDE
FILA_RE_S_TR_I_ALV PRGNO FILA_RE_S_TR_I_ALV PRGNO FILA_RE_PRG Refinancing Program MANDT
FILA_RE_S_TR_I_ALV SALESORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
FILA_RE_S_TR_I_ALV SALESORG FILA_RE_S_TR_I_ALV SALESORG TVKO Organizational Unit: Sales Organizations VKORG
FILA_RE_S_TR_I_ALV SOLDTO SYST MANDT KNA1 General Data in Customer Master MANDT
FILA_RE_S_TR_I_ALV SOLDTO FILA_RE_S_TR_I_ALV SOLDTO KNA1 General Data in Customer Master KUNNR
FILA_RE_S_TR_I_ALV SUBID FILA_RE_S_TR_I_ALV SUBID LAE_CRM_ITEMS LAE: Contract Items SUBID
FILA_RE_S_TR_I_ALV SUBID FILA_RE_S_TR_I_ALV TMSTAMP LAE_CRM_ITEMS LAE: Contract Items TMSTAMP
FILA_RE_S_TR_I_ALV SUBID FILA_RE_S_TR_I_ALV MANDT LAE_CRM_ITEMS LAE: Contract Items MANDT
FILA_RE_S_TR_I_ALV SUBID * LAE_CRM_ITEMS LAE: Contract Items BUKRS
FILA_RE_S_TR_I_ALV SUBID FILA_RE_S_TR_I_ALV OBJID LAE_CRM_ITEMS LAE: Contract Items OBJID
FILA_RE_S_TR_I_ALV TMSTAMP FILA_RE_S_TR_I_ALV SUBID LAE_CRM_ITEMS LAE: Contract Items SUBID
FILA_RE_S_TR_I_ALV TMSTAMP FILA_RE_S_TR_I_ALV TMSTAMP LAE_CRM_ITEMS LAE: Contract Items TMSTAMP
FILA_RE_S_TR_I_ALV TMSTAMP FILA_RE_S_TR_I_ALV MANDT LAE_CRM_ITEMS LAE: Contract Items MANDT
FILA_RE_S_TR_I_ALV TMSTAMP * LAE_CRM_ITEMS LAE: Contract Items BUKRS
FILA_RE_S_TR_I_ALV TMSTAMP FILA_RE_S_TR_I_ALV OBJID LAE_CRM_ITEMS LAE: Contract Items OBJID
FILA_RE_S_TR_I_ALV TRNO FILA_RE_S_TR_I_ALV TRNO FILA_RE_TR_H Tranche Header: Selection Result for Refinancing MANDT
FILA_RE_S_TR_I_ALV TRNO FILA_RE_S_TR_I_ALV MANDT FILA_RE_TR_H Tranche Header: Selection Result for Refinancing .INCLUDE
FILA_RE_S_TR_I_ALV UNIT SYST MANDT T006 Units of Measurement MANDT
FILA_RE_S_TR_I_ALV UNIT FILA_RE_S_TR_I_ALV UNIT T006 Units of Measurement MSEHI