THXT_HREL - Hedging Relationship DB Table
Hedging Relationship DB Table information is stored in SAP table THXT_HREL.
It is part of development package FTR_TRL_HEDGE_MANAGEMENT in software component FIN-FSCM-TRM-TM-TR. This development package consists of objects that can be grouped under "New Hedge Management".
It is part of development package FTR_TRL_HEDGE_MANAGEMENT in software component FIN-FSCM-TRM-TM-TR. This development package consists of objects that can be grouped under "New Hedge Management".
Fields for table THXT_HREL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| OS_GUID | Object Identity in Database Format | X | TPM_DB_OS_GUID | CHAR | 64 | |
| TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 8 | ||
| VALUATION_AREA | Treasury Valuation Area | TPM_VAL_AREA | CHAR | 6 | ||
| HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 20 | ||
| FISCAL_YEAR | Fiscal Year of Hedging Relationship | TPM_HREL_FISCAL_YEAR | NUMC | 8 | ||
| DESCRIPTION | Hedging Relationship Description | TPM_HREL_DESCR | CHAR | 120 | ||
| USER_DATA_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 64 | ||
| USER_DATA_CLS | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR | 64 | ||
| HREL_STATUS | Hedging Relationship Status | TPM_HREL_STATUS | CHAR | 4 | ||
| HREL_DES_DATE | Designation Date | TPM_HREL_DES_DATE | DATS | 16 | ||
| HREL_DED_DATE | Dedesignation Date | TPM_HREL_DEDES_DATE | DATS | 16 | ||
| HREL_PL_DES_DATE | Planned Designation Date | TPM_HREL_PL_DES_DATE | DATS | 16 | ||
| HREL_PL_DED_DATE | Planned Dedesignation Date | TPM_HREL_PL_DEDES_DATE | DATS | 16 | ||
| HREL_VALID_FROM | Hedging Relationship Valid-From Date | TPM_HREL_VALID_FROM_DATE | DATS | 16 | ||
| HREL_GROUPING_1 | Grouping Field 1 | TPM_HREL_GROUPING_1 | CHAR | 40 | ||
| HREL_GROUPING_2 | Grouping Field 2 | TPM_HREL_GROUPING_2 | CHAR | 40 | ||
| HREL_GROUPING_3 | Grouping Field 3 | TPM_HREL_GROUPING_3 | CHAR | 40 | ||
| HREL_PROFILE | Hedging Profile | TPM_HREL_PROFILE | CHAR | 6 | ||
| HREL_MDCRSETID | ID of the MDCR Set | TPM_MDCRSETID | CHAR | 20 | ||
| HREL_WITHIN_LDC | Hedging Relationship Created Within Legacy Data Conversion | TPM_HREL_WITHIN_LDC | CHAR | 2 | ||
| HREL_RISK_CURR | Risk Currency | TPM_RISK_CURRENCY | CUKY | 10 | ||
| HREL_WITHIN_INIT | Hedging Relationship Created Within Valu.Area Initialization | TPM_HREL_WITHIN_INIT | CHAR | 2 | ||
| HREL_ROLLOVER | Hedging Relationship with Rollover Strategy | TPM_HREL_ROLLOVER | CHAR | 2 | ||
| HREL_DES_TYPE | Designation Type | TOE_DESIGNATION_TYPE | CHAR | 10 | ||
| HRES_CALC_RULE | Rule for Calculating Cost of Hedging Reserve | TPM_HRES_CALC_RULE | CHAR | 4 | ||
| HREL_HEDGING_AREA | Hedging Area | TOE_AREA | CHAR | 12 | ||
| HREL_SNAPSHOT_ID | Snapshot ID | TOE_SNAPSHOT_ID | INT4 | 4 | ||
| HREL_SPLIT_ID | Split ID | TOE_SPLIT_ID | INT1 | 1 | ||
| HREL_REF_NR_ID | Reference Number (Unit No.) | TPM_KL_NR | CHAR | 20 | ||
| HREL_REF_TYP | Reference Category (Unit Category) | TPM_KL_TYP | CHAR | 6 | ||
| HREL_POST_INIT | Hedging Relationship Created with Post-Initialization | TPM_HREL_WITHIN_POST_INIT | CHAR | 2 | ||
| HREL_BAL_SHEET_REC_DATE | Hedging Relationship Balance Sheet Recognition Date | TPM_HREL_BAL_SHEET_REC_DATE | DATS | 16 | ||
| HREL_RECLASS_ST_DATE | Alternative Reclassification Date | TPM_HREL_RECLASS_START_DATE | DATS | 16 | ||
| HREL_COUNTER_CURR | Target Currency | TPM_COUNTER_CURRENCY | CUKY | 10 | ||
| .INCLUDE | CMMS_HACC_DCS | 0 | ||||
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 40 |