FILA_RE_TR_I

Tranche Item: Selection Result for Refinancing | #masterdata | Component: Lease Accounting
Column Name Description
MANDT FK Client
TRNO FK Tranche Number
OBJID FK Object Number
SUBID FK Subobject Number
TMSTAMP FK UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
PRESVAL Present Value
RESVAL_S Residual Value of Source Document
RESVAL_T Residual Value of Target Document
ADD_AMOUNT Additional Amount
DP_AMOUNT Leasing Special Payment
SALES_PRICE Sales Price
OUTSTAND_PAY Total of Outstanding Payments
RESVAL_MAN Market Value at End of Refinancing
Column Name Description
Column Name Description
DAT_STATUS Date of Status
Column Name Description
VTYPE Partner Contract Type of Source Document Show values
STATUS_TR_I Status of Tranche Item Data (Refinancing) Show values
DUE Due Date of Return Transaction (Lease Refinancing) Show values
CLUSTER_TYP Cluster Type in Refinancing Show values
RSTATUS_TR_I Status of Tranche Item Data (Return Transaction) Show values
CANCEL_REASON Cancellation Reason Show values
SELMODE Selection Mode for Return Transaction Report Show values
PVTYPE Partner Contract Type of Target Document Show values
Column Name Description Domain name
OBJECTID Contract Number FILA_REFOBJ
ITEMNO Item Number
RESIDUALTERM Remaining Term NUMC3
INTEREST Interest Rate for Refinancing DEC3_7
INTEREST_INSTAL Interest Rate for Present Value Calculation DEC3_7
POBJID Object Number of Reference Object
PSUBID Reference Sub-Object Number
PTMSTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
POBJECTID Contract Number of Reference Object FILA_REFOBJ
PITEMNO Item Number of Reference Object
CREATED_AT Created On BCOS_TSTMP
CREATED_BY Created By UNAME
CHANGED_AT Changed On BCOS_TSTMP
CHANGED_BY Changed By UNAME
Master Data Relations Join Conditions
Company Code
  • FILA_RE_TR_I.MANDT == T001.MANDT
  • FILA_RE_TR_I.BUKRS == T001.BUKRS
Client FILA_RE_TR_I.MANDT == T000.MANDT
Object Number
  • ?
  • Subobject Number
  • Object Number
  • UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Company Code of Partner
  • FILA_RE_TR_I.MANDT == T001.MANDT
  • FILA_RE_TR_I.PBUKRS == T001.BUKRS
Refinancing Program Number FILA_RE_TR_I.PRGNO == FILA_RE_PRG.MANDT
Subobject Number
  • ?
  • Subobject Number
  • Object Number
  • UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
  • ?
  • Subobject Number
  • Object Number
  • UTC Time Stamp in Short Form (YYYYMMDDhhmmss)