SAP Table FILA_RE_PRG

Refinancing Program

FILA_RE_PRG (Refinancing Program) 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_PRG to other SAP tables.

FILA_RE_PRG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PRGNO Refinancing Program Number FILA_RE_E_PRGNO CHAR 10 0
REFICAT Refinancing Category FILA_RE_E_REFICAT TFILA_RE_CAT CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PBUKRS Company code of partner PBUKRS T001 CHAR 4 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
GP_DEB_FIN Customer Number of Financing Party for Refinancing FILA_RE_E_GP_DEB_FIN KNA1 CHAR 10 0
GP_CRED_FIN Vendor Number of Financing Party for Refinancing FILA_RE_E_GP_CRED_FIN LFA1 CHAR 10 0
GP_DEB_SALB Customer Number of Sales Company for Object Company FILA_RE_E_GP_DEB_SALB KNA1 CHAR 10 0
GP_CRED_SALB Vendor Number of Sales Company for Object Company FILA_RE_E_GP_CRED_SALB LFA1 CHAR 10 0
FROMDATE Valid-from date FROMDATE DATS 8 0
TODATE Valid to Date TODATE DATS 8 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
PRESVAL_MIN Minimum Present Value per Contract FILA_RE_E_PRESVAL_MIN CURR 17 2
PRESVAL_MIN_TR Minimum Present Value per Tranche FILA_RE_E_PRESVAL_MIN_TR CURR 17 2
PRESVAL_MAX_PRG Maximum Present Value per Refinancing Program FILA_RE_E_PRESVAL_MAX_PRG CURR 17 2
PAYMENT_FORM Payment Form (Period Start, Mid-Period, Period End, Other) TFM_SZAWS NUMC 1 0
1 At Start of Period
2 Mid-Period
3 At End of Period
4 Individual
TFM_PERIODICITY Periods TFM_PERIODICITY NUMC 2 0
01 Months
03 Quarters
06 Half-Years
12 Years
VVSINCL Inclusive indicator for beginning and end of a period VVSINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
TB_JZINSRE Exponential Interest Calculation TB_JZINSRE CHAR 1 0
X Yes
NULL No
TFM_AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZV NUMC 2 0
00 Annual Interest Settlement
06 Interest Settlement Every Six Months
03 Quarterly Interest Settlement
01 Monthly Interest Settlement
52 Weekly Interest Settlement
97 Daily Interest Settlement (360)
98 Daily Interest Settlement (365)
99 Continuous Interest Settlement
SZBMETH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified

FILA_RE_PRG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FILA_RE_PRG BUKRS SYST MANDT T001 Company Codes MANDT
FILA_RE_PRG BUKRS FILA_RE_PRG BUKRS T001 Company Codes BUKRS
FILA_RE_PRG CURRENCY SYST MANDT TCURC Currency Codes MANDT
FILA_RE_PRG CURRENCY FILA_RE_PRG CURRENCY TCURC Currency Codes WAERS
FILA_RE_PRG GP_CRED_FIN SYST MANDT LFA1 Vendor Master (General Section) MANDT
FILA_RE_PRG GP_CRED_FIN FILA_RE_PRG GP_CRED_FIN LFA1 Vendor Master (General Section) LIFNR
FILA_RE_PRG GP_CRED_SALB SYST MANDT LFA1 Vendor Master (General Section) MANDT
FILA_RE_PRG GP_CRED_SALB FILA_RE_PRG GP_CRED_SALB LFA1 Vendor Master (General Section) LIFNR
FILA_RE_PRG GP_DEB_FIN SYST MANDT KNA1 General Data in Customer Master MANDT
FILA_RE_PRG GP_DEB_FIN FILA_RE_PRG GP_DEB_FIN KNA1 General Data in Customer Master KUNNR
FILA_RE_PRG GP_DEB_SALB SYST MANDT KNA1 General Data in Customer Master MANDT
FILA_RE_PRG GP_DEB_SALB FILA_RE_PRG GP_DEB_SALB KNA1 General Data in Customer Master KUNNR
FILA_RE_PRG PBUKRS FILA_RE_PRG PBUKRS T001 Company Codes BUKRS
FILA_RE_PRG PBUKRS SYST MANDT T001 Company Codes MANDT
FILA_RE_PRG REFICAT SYST MANDT TFILA_RE_CAT Define Refinancing Category MANDT
FILA_RE_PRG REFICAT FILA_RE_PRG REFICAT TFILA_RE_CAT Define Refinancing Category REFICAT