FTI_LDB_TR_HM_HEDGE_REL_DATA SAP (RAPI Hedge: Hedging Relationship with Anchor Data) Structure details
Description: RAPI Hedge: Hedging Relationship with Anchor Data
Related tables to FTI_LDB_TR_HM_HEDGE_REL_DATA
Access table FTI_LDB_TR_HM_HEDGE_REL_DATA
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_HM_HEDGE_REL_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "RAPI Hedge: Hedging Relationship with Anchor Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FTI_LDB_TR_HM_HEDGE_REL_DATA TYPE FTI_LDB_TR_HM_HEDGE_REL_DATA.
The FTI_LDB_TR_HM_HEDGE_REL_DATA table consists of various fields, each holding specific information or linking keys about RAPI Hedge: Hedging Relationship with Anchor Data data available in SAP. These include HR_RFHA (Hedging Instrument), HEDGE_ID (Identification Number of Hedge Item), VALUATION_AREA (Valuation Area), HR_VERSION (Version of the hedging relationship).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP FTI_LDB_TR_HM_HEDGE_REL_DATA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
HR_RFHA | Hedging Instrument | FTI_HR_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
HR_VERSION | Version of the hedging relationship | THM_HR_VERSION | NUMC | 3 | THM_HR_VERSION | ||||
HR_COMP_KEY | Key for hr | THM_HR_COMP_KEY | NUMC | 10 | THM_HR_COMP_KEY | ||||
HR_DATE | Inception date of the current hedge relationship version | THM_HR_DATE | DATS | 8 | DATUM | ||||
HR_CR_DATE | System date when hr is written | THM_HR_AUDIT | DATS | 8 | DATUM | ||||
HR_TIME | Time when hedge relationship is written | THM_HR_TIME | TIMS | 6 | TIME | ||||
HR_CRUSER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
HR_UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
VOL_DERIVATIVE | Designated volume of the derivative | THM_DES_VOL_DER | CURR | 17(2) | WERTV9 | ||||
CURR_DERIVATIVE | Currency of the designated volume of the derivative | THM_CURR_DER | CUKY | 5 | Assigned to domain | WAERS | |||
VOL_HEDGE_ITEM | Designated volume of the hedge item | THM_DES_VOL_HEDGE | CURR | 17(2) | WERTV9 | ||||
CURR_HEDGE_ITEM | Currency of the hedge item | THM_HEDGE_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
MEAS_EXISTS | Indicator that HR has an associated measurement | THM_HR_VALUED | INT1 | 3 | THM_HR_VALUED | ||||
NOT_DELETABLE | Is hedging relationship deletable? | THM_HR_NOT_DELETABLE | INT1 | 3 | THM_HR_NOT_DELETABLE | ||||
STATUS | Hedging relationship status | THM_HR_STATUS | INT1 | 3 | THM_HR_STATUS | ||||
STATUS_CHANGE | Reason for a status change on the hedging relationship | THM_HR_STATUS_CHANGE | INT1 | 3 | THM_HR_STATUS_CHANGE | ||||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | Assigned to domain | T_SFGTYP | |||
SGSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
HR_RATE_CAT | Rates for the hr | THM_RATE_CAT | INT1 | 3 | THM_RATE_CAT | ||||
HR_INT_FIX | Planned interest hedge rate for an hedging relationship | THM_HEDGE_RATE_INT | DEC | 10(7) | DECV3_7 | ||||
HR_INT_VAR | Planned interest reference hedge rate for an hedging rel. | THM_HEDGE_RATE_INT_REF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
HR_FX_RATE | Planned FX hedge rate for a hedging relationship | THM_HEDGE_RATE | DEC | 13(9) | TB_KKURS | ||||
HR_STARTVAL | Determine hedged item's value at inception date | THM_STARTVALUE_SET | NUMC | 1 | THM_STARTVALUE_SET | ||||
BENCHMARK | Benchmark interest reference for an hedging relationship | THM_HR_BENCHMARK | CHAR | 10 | Assigned to domain | ZIREFKU | |||
FIX_BENCHMARK | Fixed benchmark interest rate of an hedging relationship | THM_HR_FIX_BENCHMARK | DEC | 10(7) | DECV3_7 | ||||
H_RFHA | Hypothetical transaction (hedge accounting) | GE_HYPTRANS | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
HR_SPREAD | Interest Rate Spread to Risk Free Market Interest Rate | THA_SPREAD | DEC | 10(7) | DECV3_7 | ||||
PMAX | Strike price upper limit | TB_PMAX | DEC | 10(7) | DECV3_7 | ||||
PMIN | Strike Price Lower Limit | TB_PMIN | DEC | 10(7) | DECV3_7 | ||||
REFTYP | Reference Category (Unit Category) | KL_TYP | CHAR | 3 | Assigned to domain | KL_TYP | T31 | ||
REFNR | Reference number (unit no.) | KL_NR | CHAR | 10 | Assigned to domain | ALPHA | KL_NR | T30 | |
HR_BEGIN_DATE | Hedging Relationship Start Date | THA_HR_BEGIN_DATE | DATS | 8 | DATUM | ||||
HR_STRATEGY | E-HA: Hedge Strategy | THM_HRSTRATEGY | NUMC | 4 | Assigned to domain | THM_HRSTRATEGY | |||
ASSESS_TYPE | Assessment type | THM_ASSESSMENT_TYPE | NUMC | 2 | Assigned to domain | THM_ASSESSMENT_TYPE | |||
ASS_CALC_TYPE | Calculation Type: Effectiveness Assessment | FTI_ASS_CALC_TYPE | CHAR | 3 | Assigned to domain | THM_CALC_TYPE | |||
ASS_CALC_CAT | Calc. Category: Effectiveness Assessment | FTI_ASS_CALC_CATEGORY | NUMC | 3 | Assigned to domain | THM_CALC_CATEGORY | |||
ASS_OFF_CLC_CAT | Offset Calculation Category: Effectiveness Assessment | FTI_ASS_OFFSET_CALC_CAT | NUMC | 2 | THM_OFFSET_CALC_CAT | ||||
ASS_AUSWT | Evaluation Type: Effectiveness Assessment | FTI_ASS_TV_AUSWT | CHAR | 4 | Assigned to domain | JBREVAL | |||
ASS_NPV_TYPE | Rate/NPV Type: Effectiveness Assessment | FTI_ASS_TV_OKUART | CHAR | 3 | Assigned to domain | T_OKUART | |||
ASS_KORART | Correlation Type: Effectiveness Assessment | FTI_ASS_TV_KORART | CHAR | 3 | Assigned to domain | T_KORART | |||
ASS_NPV_FIX | Read NPV? (Effectiveness Assessment) | FTI_ASS_THA_NPV_FIX | CHAR | 1 | XFELD | ||||
ASS_NPV_RATE_CAT | Read NPV Rate Type (Effectiveness Assessment) | FTI_ASS_NPV_RATE_CATEGORY | CHAR | 4 | Assigned to domain | KURST | |||
ASS_AUTO_INCEP | Create Initial Value Automatically (Effect. Assessment) | FTI_ASS_AUTO_INCEP | NUMC | 1 | THA_AUTO_INCEP | ||||
ASS_AUTO_EXEC | Calc. NPV for Option Exercise (Effectiveness Assessment) | FTI_ASS_AUTO_EXEC | NUMC | 1 | THA_AUTO_EXEC | ||||
ASS_THRESHOLD | Threshold Value in Percent (Effectiveness Assessment) | FTI_ASS_THRESHOLD | DEC | 5(3) | PRZ23 | ||||
ASS_TRANS_SPEED | Transfer Speed (Effectiveness Assessment) | FTI_ASS_TRANS_SPEED | DEC | 5(2) | THA_TRANS_SPEED | ||||
ASS_AUTO_NOCLEAN | Do Not Calculate Clean Price Automatically (Effect. Assess.) | FTI_ASS_AUTO_NO_CLEAN | CHAR | 1 | XFELD | ||||
ASS_FLG_SAVE_LOG | Save Log for Valuation (Effectiveness Assessment) | FTI_ASS_SAVE_LOG | CHAR | 1 | XFELD | ||||
MES_CALC_TYPE | Calculation Type (Effectiveness Measurement) | FTI_MES_CALC_TYPE | CHAR | 3 | Assigned to domain | THM_CALC_TYPE | |||
MES_CALC_CAT | Calc. Category: Effectiveness Measurement | FTI_MES_CALC_CATEGORY | NUMC | 3 | Assigned to domain | THM_CALC_CATEGORY | |||
MES_OFF_CLC_CAT | Offset Calculation Category: Effectiveness Measurement | FTI_MES_OFFSET_CALC_CAT | NUMC | 2 | THM_OFFSET_CALC_CAT | ||||
MES_AUSWT | Evaluation Type: Effectiveness Measurement | FTI_MES_TV_AUSWT | CHAR | 4 | Assigned to domain | JBREVAL | |||
MES_NPV_TYPE | Rate/NPV Type: Effectiveness Measurement | FTI_MES_TV_OKUART | CHAR | 3 | Assigned to domain | T_OKUART | |||
MES_KORART | Correlation Type: Effectiveness Measurement | FTI_MES_TV_KORART | CHAR | 3 | Assigned to domain | T_KORART | |||
MES_NPV_FIX | Read NPV? (Effectiveness Measurement) | FTI_MES_THA_NPV_FIX | CHAR | 1 | XFELD | ||||
MES_NPV_RATE_CAT | Read NPV Rate Type (Effectiveness Measurement) | FTI_MES_NPV_RATE_CATEGORY | CHAR | 4 | Assigned to domain | KURST | |||
MES_AUTO_INCEP | Create Initial Value Automatically (Effect. Measurement) | FTI_MES_AUTO_INCEP | NUMC | 1 | THA_AUTO_INCEP | ||||
MES_AUTO_EXEC | Calc. NPV for Option Exercise (Effectiveness Measurement) | FTI_MES_AUTO_EXEC | NUMC | 1 | THA_AUTO_EXEC | ||||
MES_THRESHOLD | Threshold Value in Percent (Effectiveness Measurement) | FTI_MES_THRESHOLD | DEC | 5(3) | PRZ23 | ||||
MES_TRANS_SPEED | Transfer Speed (Effectiveness Measurement) | FTI_MES_TRANS_SPEED | DEC | 5(2) | THA_TRANS_SPEED | ||||
MES_AUTO_NOCLEAN | Do Not Calc. Clean Price Automatically (Effect. Measurement) | FTI_MES_AUTO_NO_CLEAN | CHAR | 1 | XFELD | ||||
MES_FLG_SAVE_LOG | Save Log for Valuation (Effectiveness Measurement) | FTI_MES_SAVE_LOG | CHAR | 1 | XFELD | ||||
SHORTCUT | Shortcut Method | THM_SHORTCUT | CHAR | 1 | THM_FLAG | ||||
PROSPECTIVE | Details on the prospective assessment analysis | THM_DEFAULT_PROSPECTIVE | NUMC | 2 | THM_DEFAULT_PROSPECTIVE | ||||
CF_CAT | Method of ineffectiveness measurement | THM_CASH_FLOW_EFF_CAT | INT1 | 3 | THM_CASH_FLOW_EFF_CAT | ||||
HEDGEPLAN_ID | Hedge Plan ID | THM_PLANNERID | CHAR | 13 | Assigned to domain | ALPHA | THM_PLANNERID | PLN | |
TEXT | Description of Hedge Plan | THA_PLANNERTEXT | CHAR | 50 | TEXT50 | ||||
RISKCAT | Hedge Risk Category | THM_RISKCAT | NUMC | 2 | THM_RISKCAT | ||||
STARTTERM | Start of Term of Hedge Plan | THM_STARTTERM | DATS | 8 | DATUM | ||||
ENDTERM | End of Term of Hedge Plan | THM_ENDTERM | DATS | 8 | DATUM | ||||
CRUSER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
CDATE | Date | DATUM | DATS | 8 | DATUM | ||||
UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
UDATE | Date | DATUM | DATS | 8 | DATUM | ||||
TIME | Time | UZEIT | TIMS | 6 | UZEIT | ||||
SINGLEHEDGE | Indicator: Assign All Exposures to One Single Hedge | THM_SINGLEHEDGE | CHAR | 1 | FLAG | ||||
NOMINAL | Nominal Amount (E-HA) | THM_TRANSAMOUNT | CURR | 17(2) | THM_TRANSAMOUNT | ||||
NOM_CURRENCY | Nominal Amount Currency | THM_TRANSCURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RO_FLAG | E-HA Data Created via External Exposure Data | THM_RO_FLAG | CHAR | 1 | FLAG | ||||
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
PLAN_STATUS | Hedge Plan Status | THA_PLAN_STATUS | NUMC | 2 | THA_PLAN_STATUS | ||||
HP_GROUP | Hedge Plan Grouping | THA_GROUP | CHAR | 30 | TEXT30 | ||||
HP_PROGRAM | Hedge Plan Program | THA_PROGRAM | CHAR | 30 | TEXT30 |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_HM_HEDGE_REL_DATA using ABAP code?
As FTI_LDB_TR_HM_HEDGE_REL_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTI_LDB_TR_HM_HEDGE_REL_DATA as there is no data to select.How to access SAP table FTI_LDB_TR_HM_HEDGE_REL_DATA
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_HM_HEDGE_REL_DATA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects