FILA_RE_TR_I SAP table for – Tranche Item: Selection Result for Refinancing

Here we would like to draw your attention to FILA_RE_TR_I table in SAP. As we know it is being mainly used with the SAP FI-LA (Lease Accounting in FI) component which is coming under FI module (Financial Accounting). FILA_RE_TR_I is a SAP standard transp table used for storing Tranche Item: Selection Result for Refinancing related data in SAP. It comes under the package FI_LA_RE_APPL.

SAP FILA_RE_TR_I table

Table FILA_RE_TR_I technical data

TableFILA_RE_TR_I
Data storingTranche Item: Selection Result for Refinancing
ModuleFI
Sub ModuleFI-LA
SAP PackageFI_LA_RE_APPL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP FILA_RE_TR_I Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FILA_RE_TR_I table.

  • .INCLUDE : Key: Tranche Item Structure: Selection Result for Refin.
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TRNO : Tranche Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OBJID : Object Number
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • SUBID : Subobject Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • TMSTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Tranche Item Structure: Result of Selection for Refinancing
  • VTYPE : Partner Contract Type of Source Document
    Its data type is CHAR (Character String) with field length 1
  • OBJECTID : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • ITEMNO : Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • STATUS_TR_I : Status of Tranche Item Data (Refinancing)
    Its data type is CHAR (Character String) with field length 2
  • DAT_STATUS : Date of Status
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Structure Result Fields per Tranche Item for Refinancing
  • PRESVAL : Present Value
    Its data type is CURR (Currency Field) with field length 17
  • RESVAL_S : Residual Value of Source Document
    Its data type is CURR (Currency Field) with field length 17
  • RESVAL_T : Residual Value of Target Document
    Its data type is CURR (Currency Field) with field length 17
  • ADD_AMOUNT : Additional Amount
    Its data type is CURR (Currency Field) with field length 17
  • DP_AMOUNT : Leasing Special Payment
    Its data type is CURR (Currency Field) with field length 17
  • SALES_PRICE : Sales Price
    Its data type is CURR (Currency Field) with field length 17
  • RESIDUALTERM : Remaining Term
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • INTEREST : Interest Rate for Refinancing
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INTEREST_INSTAL : Interest Rate for Present Value Calculation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • OUTSTAND_PAY : Total of Outstanding Payments
    Its data type is CURR (Currency Field) with field length 17
  • .INCLUDE : Structure Result Fieldcs per Tranche Item for Return Trans.
  • PRGNO : Refinancing Program Number
    Its data type is CHAR (Character String) with field length 10
  • DUE : Due Date of Return Transaction (Lease Refinancing)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CLUSTER_TYP : Cluster Type in Refinancing
    Its data type is CHAR (Character String) with field length 2
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RSTATUS_TR_I : Status of Tranche Item Data (Return Transaction)
    Its data type is CHAR (Character String) with field length 2
  • CANCEL_REASON : Cancellation Reason
    Its data type is CHAR (Character String) with field length 4
  • RESVAL_MAN : Market Value at End of Refinancing
    Its data type is CURR (Currency Field) with field length 17
  • SELMODE : Selection Mode for Return Transaction Report
    Its data type is CHAR (Character String) with field length 1
  • PVTYPE : Partner Contract Type of Target Document
    Its data type is CHAR (Character String) with field length 1
  • PBUKRS : Company code of partner
    Its data type is CHAR (Character String) with field length 4
  • POBJID : Object Number of Reference Object
    Its data type is RAW (Byte string) with field length 16
  • PSUBID : Reference Sub-Object Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • PTMSTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • POBJECTID : Contract Number of Reference Object
    Its data type is CHAR (Character String) with field length 10
  • PITEMNO : Item Number of Reference Object
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Time and User of Last Transaction Processing
  • CREATED_AT : Created On
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CREATED_BY : Created By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Changed On
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Changed By
    Its data type is CHAR (Character String) with field length 12