FTI_LDB_TR_HM_HEDGE_RELATION SAP (Hedging Relationship) Structure details
Dictionary Type: Structure
Description: Hedging Relationship
Description: Hedging Relationship
ABAP Code to SELECT data from FTI_LDB_TR_HM_HEDGE_RELATION
Related tables to FTI_LDB_TR_HM_HEDGE_RELATION
Access table FTI_LDB_TR_HM_HEDGE_RELATION
Related tables to FTI_LDB_TR_HM_HEDGE_RELATION
Access table FTI_LDB_TR_HM_HEDGE_RELATION
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_HM_HEDGE_RELATION 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 "Hedging Relationship" 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_RELATION TYPE FTI_LDB_TR_HM_HEDGE_RELATION.
The FTI_LDB_TR_HM_HEDGE_RELATION table consists of various fields, each holding specific information or linking keys about Hedging Relationship data available in SAP. These include HEDGEPLAN_ID (Hedge Plan ID), VALUATION_AREA (Valuation Area), HEDGE_ID (Identification Number of Hedge Item), HR_RFHA (Hedging Instrument).. 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_RELATION 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 | |
| HEDGEPLAN_ID | Hedge Plan ID | THM_PLANNERID | CHAR | 13 | Assigned to domain | ALPHA | THM_PLANNERID | PLN | |
| VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
| HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
| HR_RFHA | Hedging Instrument | FTI_HR_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
| 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 | ||||
| CRUSER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
| 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 | ||||
| CF_CAT | Method of ineffectiveness measurement | THM_CASH_FLOW_EFF_CAT | INT1 | 3 | THM_CASH_FLOW_EFF_CAT | ||||
| RETROSPECT | Details on the retrospective assessment analysis | THA_DEFAULT_RETROSPECTIVE | CHAR | 2 | THA_DEFAULT_RETROSPECTIVE | ||||
| PROS_CALC_TYPE | Calculation type | THM_CALC_TYPE | CHAR | 3 | Assigned to domain | THM_CALC_TYPE | |||
| DATA_POINTS | No of Data Points in the period | FTI_NO_OF_POINTS | INT4 | 10 | INT4 | ||||
| SLICE_TYPE | Time Slicing Type | FTI_SLICE_TYPE | NUMC | 1 | FTI_SLICE_TYPE | ||||
| CALENDAR | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
| HOL_MOVE_TYPE | Holiday Movement Type | FTI_HOL_MOVE_TYPE | NUMC | 1 | FTI_HOL_MOVE_TYPE | ||||
| ASS_SIGNIFICANCE_RETRO | Level of Significance | FTI_ALPHA | DEC | 5(4) | FTI_ALPHA | ||||
| ASS_EFF_TEST_METHOD_RETRO | Effectiveness Test Method Category | THA_EFF_TEST_METHOD | CHAR | 2 | THA_EFF_TEST_METHOD | ||||
| ASS_HYPO_CREATE_AUTO_RETRO | Create Hypothetical Derivative automatically | TPM_HYP_DERIV_CREATE_AUTO | CHAR | 1 | XFELD | ||||
| ASS_CALC_CAT_PROSP | Calculation category for effectiveness | THM_CALC_CATEGORY | NUMC | 3 | Assigned to domain | THM_CALC_CATEGORY | |||
| ASS_OFF_CLC_CAT_PROSP | Offset Calculation Category | THM_OFFSET_CALC_CAT | NUMC | 2 | THM_OFFSET_CALC_CAT | ||||
| ASS_AUSWT_PROSP | Evaluation type in Risk Management | TV_AUSWT | CHAR | 4 | Assigned to domain | JBREVAL | |||
| ASS_NPV_TYPE_PROSP | Price/NPV Type for OTC Transactions | TV_OKUART | CHAR | 3 | Assigned to domain | T_OKUART | |||
| ASS_KORART_PROSP | Correlation Types | TV_KORART | CHAR | 3 | Assigned to domain | T_KORART | |||
| ASS_NPV_FIX_PROSP | Read NPV from table VTVBAR | THA_NPV_FIX | CHAR | 1 | XFELD | ||||
| ASS_NPV_RATE_CAT_PROSP | Exchange rate type for NPVs of VTVBAR | THA_NPV_RATE_CATEGORY | CHAR | 4 | Assigned to domain | KURST | |||
| ASS_AUTO_INCEP_PROSP | Do You Want To Create the Initial Value Automatically? | THA_AUTO_INCEP | NUMC | 1 | THA_AUTO_INCEP | ||||
| ASS_AUTO_EXEC_PROSP | Calculate Net Present Value for Option Exercise | THA_AUTO_EXEC | NUMC | 1 | THA_AUTO_EXEC | ||||
| ASS_THRESHOLD_PROSP | Threshold for Effectiveness Calculation in Percent | THA_THRESHOLD | DEC | 5(3) | PRZ23 | ||||
| ASS_TRANS_SPEED_PROSP | Transition Speed for Effectiveness Calculation | THA_TRANS_SPEED | DEC | 5(2) | THA_TRANS_SPEED | ||||
| ASS_AUTO_NOCLEAN_PROSP | Do Not Calculate Clean Price Automatically | THA_AUTO_NO_CLEAN | CHAR | 1 | XFELD | ||||
| ASS_FLG_SAVE_LOG_PROSP | Save Detail Log During Measurement | THA_SAVE_LOG | CHAR | 1 | XFELD | ||||
| ASS_SIGNIFICANCE_PROSP | Level of Significance | FTI_ALPHA | DEC | 5(4) | FTI_ALPHA | ||||
| ASS_EFF_TEST_METHOD_PROSP | Effectiveness Test Method Category | THA_EFF_TEST_METHOD | CHAR | 2 | THA_EFF_TEST_METHOD | ||||
| ASS_HYPO_CREATE_AUTO_PROSP | Create Hypothetical Derivative automatically | TPM_HYP_DERIV_CREATE_AUTO | CHAR | 1 | XFELD | ||||
| DESIG_QUANTITY | Designated quantity | THA_DES_QUANTITY | QUAN | 15(3) | THA_QUANTITY | ||||
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
| COMMODITY_PRICE | Commodity Price | FTR_COMPRICE | DEC | 13(5) | FTR_COMPRICE | ||||
| HR_REFNR | Reference number (unit no.) | KL_NR | CHAR | 10 | Assigned to domain | ALPHA | KL_NR | T30 | |
| EXP_FORW_PRICE | Forward price of the exposure | THA_EXP_FORW_PRICE | DEC | 29(10) | THA_PRICE_PER_UNIT | ||||
| COMM_ID_DERIV | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
| HEDGE_DES_QTY | Designated quantity of Hedged Item | THA_HEDGE_DES_QTY | QUAN | 15(3) | THA_QUANTITY | ||||
| HEDGE_DES_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| HD_NUMBER | Hypothetical Derivative Instrument Number | FTR_HD_NUMBER | CHAR | 13 | Assigned to domain | FTR_HD_NUMBER | |||
| HD_VERSION | Hypothetical Derivative Instrument Version Number | FTR_HD_VERSION | INT1 | 3 | FTR_HD_VERSION | ||||
| FP_CALC_METH | Calculation Method for expected forward price of exposure | THM_FP_CALC_METHOD | CHAR | 1 | THM_FP_CALC_METHOD |
| Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_HM_HEDGE_RELATION using ABAP code?
As FTI_LDB_TR_HM_HEDGE_RELATION 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_RELATION as there is no data to select.How to access SAP table FTI_LDB_TR_HM_HEDGE_RELATION
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_HM_HEDGE_RELATION 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