THMHRT_HR - Hedge Relationship
Hedge Relationship information is stored in SAP table THMHRT_HR.
It is part of development package FTHM_HEDGING_RELATIONSHIP in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Hedge Management - Package hedging relationship".
It is part of development package FTHM_HEDGING_RELATIONSHIP in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Hedge Management - Package hedging relationship".
Fields for table THMHRT_HR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| RFHA | Financial Transaction | X | TB_RFHA | CHAR | 26 | VTBFHA |
| HEDGE_ID | Identification Number of Hedged Item | X | THM_HEDGE_ID | NUMC | 20 | THMT_HEDGE_ITEM |
| HR_VERSION | Version of the hedging relationship | X | THM_HR_VERSION | NUMC | 6 | |
| HR_COMP_KEY | Key for Hedging Relationship | THM_HR_COMP_KEY | NUMC | 20 | ||
| VALUATION_AREA | Treasury Valuation Area | TPM_VAL_AREA | CHAR | 6 | ||
| HR_DATE | Inception date of the current hedge relationship version | THM_HR_DATE | DATS | 16 | ||
| HR_CR_DATE | System date when hr is written | THM_HR_AUDIT | DATS | 16 | ||
| HR_TIME | Time when hedge relationship is written | THM_HR_TIME | TIMS | 12 | ||
| CRUSER | Entered By | TB_CRUSER | CHAR | 24 | ||
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 24 | ||
| VOL_DERIVATIVE | Amount of the Derivative | THM_DES_VOL_DER | CURR | 9 | ||
| CURR_DERIVATIVE | Currency of the Designated Volume of the Derivative | THM_CURR_DER | CUKY | 10 | TCURC | |
| VOL_HEDGE_ITEM | Designated Amount of the Hedging Instrument | THM_DES_VOL_HEDGE | CURR | 9 | ||
| CURR_HEDGE_ITEM | Currency of the Hedged Item | THM_HEDGE_CURRENCY | CUKY | 10 | TCURC | |
| MEAS_EXISTS | Indicator that HR has an associated measurement | THM_HR_VALUED | INT1 | 1 | ||
| NOT_DELETABLE | Is hedging relationship deletable? | THM_HR_NOT_DELETABLE | INT1 | 1 | ||
| STATUS | Hedging Relationship Status | THM_HR_STATUS | INT1 | 1 | ||
| STATUS_CHANGE | Reason for a status change on the hedging relationship | THM_HR_STATUS_CHANGE | INT1 | 1 | ||
| SANLF | Product Category | SANLF | NUMC | 6 | ||
| SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 6 | ||
| SGSART | Product Type | VVSART | CHAR | 6 | ||
| SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 6 | ||
| RANTYP | Contract Type | RANTYP | CHAR | 2 | ||
| HR_RATE_CAT | Rates for the hr | THM_RATE_CAT | INT1 | 1 | ||
| HR_INT_FIX | Planned interest hedge rate for an hedging relationship | THM_HEDGE_RATE_INT | DEC | 6 | ||
| HR_INT_VAR | Planned interest reference hedge rate for an hedging rel. | THM_HEDGE_RATE_INT_REF | CHAR | 20 | ||
| HR_FX_RATE | Planned Exchange Rate of the Hedging Relationship | THM_HEDGE_RATE | DEC | 7 | ||
| HR_STARTVAL | Determine Value of Hedged Item at Inception Date | THM_STARTVALUE_SET | NUMC | 2 | ||
| BENCHMARK | Benchmark interest reference for an hedging relationship | THM_HR_BENCHMARK | CHAR | 20 | T056R | |
| FIX_BENCHMARK | Fixed benchmark interest rate of an hedging relationship | THM_HR_FIX_BENCHMARK | DEC | 6 | ||
| H_RFHA | Hypothetical transaction (hedge accounting) | GE_HYPTRANS | CHAR | 26 | VTBFHA | |
| HR_SPREAD | Interest Rate Spread to Risk Free Market Interest Rate | THA_SPREAD | DEC | 6 | ||
| PMAX | Strike Price Upper Limit | TB_PMAX | DEC | 6 | ||
| PMIN | Strike Price Lower Limit | TB_PMIN | DEC | 6 | ||
| REFTYP | Reference Category (Unit Category) | KL_TYP | CHAR | 6 | ATR1 | |
| REFNR | Reference Number (Unit No.) | KL_NR | CHAR | 20 | REFH | |
| HR_BEGIN_DATE | Hedging Relationship Start Date | THA_HR_BEGIN_DATE | DATS | 16 | ||
| KKASSA | Spot Rate | TB_KKASSA | DEC | 7 | ||
| DVTRAB | Contract Conclusion Date | TB_DVTRAB | DATS | 16 | ||
| DESIG_QUANTITY | Designated quantity | THA_DES_QUANTITY | QUAN | 8 | ||
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 6 | ||
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | ||
| COMMODITY_PRICE | Commodity Price | FTR_COMPRICE | DEC | 7 | ||
| HR_REFNR | Reference Number (Unit No.) | KL_NR | CHAR | 20 | ||
| EXP_FORW_PRICE | Forward price of the exposure | THA_EXP_FORW_PRICE | DEC | 15 | ||
| COMM_ID_DERIV | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | ||
| HEDGE_DES_QTY | Designated quantity of Hedged Item | THA_HEDGE_DES_QTY | QUAN | 8 | ||
| HEDGE_DES_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 6 | ||
| HD_NUMBER | Hypothetical Derivative Instrument Number | FTR_HD_NUMBER | CHAR | 26 | ||
| HD_VERSION | Hypothetical Derivative Instrument Version Number | FTR_HD_VERSION | INT1 | 1 | ||
| FP_CALC_METH | Calculation Method for Expected Forward Price of Exposure | THM_FP_CALC_METHOD | CHAR | 2 |