SAP Table FILA_RE_TR_H
Tranche Header: Selection Result for Refinancing
FILA_RE_TR_H (Tranche Header: Selection Result for Refinancing) 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_TR_H to other SAP tables.
FILA_RE_TR_H table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||
| TRNO | Tranche Number | FILA_RE_E_TRNO | CHAR | 10 | 0 | |||||||||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||||||||||
| PRGNO | Refinancing Program Number | FILA_RE_E_PRGNO | FILA_RE_PRG | CHAR | 10 | 0 | ||||||||||
| STAT | Status of Tranche Header Data (Refinancing) | FILA_RE_E_TRH_STAT | CHAR | 2 | 0 |
Possible values
|
||||||||||
| DAT_STATUS | Date of Status | FILA_RE_E_DAT_STATUS | DATS | 8 | 0 | |||||||||||
| DATS | Asset Transfer Date | FILA_RE_E_DATS | DATS | 8 | 0 | |||||||||||
| DDAT | Key Date of Refinancing | FILA_RE_E_DDAT | DATS | 8 | 0 | |||||||||||
| PRESVAL_MIN_TR | Minimum Present Value per Tranche | FILA_RE_E_PRESVAL_MIN_TR | CURR | 17 | 2 | |||||||||||
| PRESVAL_MIN | Minimum Present Value per Contract | FILA_RE_E_PRESVAL_MIN | CURR | 17 | 2 | |||||||||||
| RV_PERC | Percentage Discount from Residual Value | FILA_RE_E_RV_PERC | DEC | 5 | 2 | |||||||||||
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||
| TRTYP | Tranche Type | FILA_RE_E_TRTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| TZNZONE | Time Zone | TZNZONE | TTZZ | CHAR | 6 | 0 | ||||||||||
| RSTATUS | Status of Tranche Header Data (Return Transaction) | FILA_RE_E_TRH_STAT_RET | CHAR | 2 | 0 |
Possible values
|
||||||||||
| 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 | |||||||||||
| TEST | Test Run for Selection | FILA_RE_E_TEST | CHAR | 1 | 0 |
Possible values
|
||||||||||
FILA_RE_TR_H foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FILA_RE_TR_H | CURRENCY | FILA_RE_TR_H | CURRENCY | TCURC | Currency Codes | WAERS |
| FILA_RE_TR_H | CURRENCY | SYST | MANDT | TCURC | Currency Codes | MANDT |
| FILA_RE_TR_H | PRGNO | SYST | MANDT | FILA_RE_PRG | Refinancing Program | .INCLUDE |
| FILA_RE_TR_H | PRGNO | FILA_RE_TR_H | PRGNO | FILA_RE_PRG | Refinancing Program | MANDT |
| FILA_RE_TR_H | TZNZONE | SYST | MANDT | TTZZ | Time zones | CLIENT |
| FILA_RE_TR_H | TZNZONE | FILA_RE_TR_H | TZNZONE | TTZZ | Time zones | TZONE |
