THXT_HREL

Transparent Table Application Table
43 Fields 2 CDS Views

Hedging Relationship DB Table

THXT_HREL is an SAP database table in S/4HANA. Hedging Relationship DB Table. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CommodityHedgingRelationship view from BASIC Commodity Hedging Relationship
I_HedgingRelationship view from BASIC Hedging Relationship

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
tr_acc_code TPM_ACC_CODE Accounting Code
valuation_area TPM_VAL_AREA Valuation Area
hrel_number TPM_HREL_NUMBER HedgingRel. No.
fiscal_year TPM_HREL_FISCAL_YEAR Fiscal Year of HR
description TPM_HREL_DESCR HR Description
user_data_oid TPM_DB_OS_GUID DB Object ID
user_data_cls TPM_DB_OS_GUID DB Object ID
hrel_status TPM_HREL_STATUS Status
hrel_des_date TPM_HREL_DES_DATE Des. Date
hrel_ded_date TPM_HREL_DEDES_DATE Dedes.Date
hrel_pl_des_date TPM_HREL_PL_DES_DATE Pl.Des.Date
hrel_pl_ded_date TPM_HREL_PL_DEDES_DATE Pl.Dedes.Date
hrel_valid_from TPM_HREL_VALID_FROM_DATE Valid-From Date
hrel_grouping_1 TPM_HREL_GROUPING_1 Group. Field 1
hrel_grouping_2 TPM_HREL_GROUPING_2 Group. Field 2
hrel_grouping_3 TPM_HREL_GROUPING_3 Group. Field 3
hrel_profile TPM_HREL_PROFILE Hedging Profile
hrel_mdcrsetid TPM_MDCRSETID ID of the MDCR Set
hrel_within_ldc TPM_HREL_WITHIN_LDC HR Within LDC
hrel_risk_curr TPM_RISK_CURRENCY Risk Crcy
hrel_within_init TPM_HREL_WITHIN_INIT HR Within Init.
hrel_rollover TPM_HREL_ROLLOVER Rollover Y/N
hrel_des_type TOE_DESIGNATION_TYPE Desig.Type
hres_calc_rule TPM_HRES_CALC_RULE Cost H.Res.Calc.Rule
hrel_hedging_area TOE_AREA Hedging Area
hrel_snapshot_id TOE_SNAPSHOT_ID Snapshot ID
hrel_split_id TOE_SPLIT_ID Split ID
hrel_ref_nr_id TPM_KL_NR Reference
hrel_ref_typ TPM_KL_TYP Reference Cat.
hrel_post_init TPM_HREL_WITHIN_POST_INIT HR Post-Init.
hrel_bal_sheet_rec_date TPM_HREL_BAL_SHEET_REC_DATE B/S Recog. Date
hrel_reclass_st_date TPM_HREL_RECLASS_START_DATE Alt.Reclass.Dte
hrel_counter_curr TPM_COUNTER_CURRENCY Target Crcy
dcsid TBA_DCSID DCS ID
hedge_book CMM_HEDGE_BOOK Hedge Book
hedging_area CMM_HEDGING_AREA Hedging Area
cmm_delivery_start_date CMM_HB_DELIVERY_START_DATE Del. Start Date
cmm_delivery_end_date CMM_HB_DELIVERY_END_DATE Del. End Date
cmm_hedge_request_id CMM_HEDGE_REQUEST_ID Hedge Request ID
cmm_hrel_des_fixing_date CMM_HREL_DES_FIXING_DATE Desig.Release Date
cmm_hrel_dedes_fixing_date CMM_HREL_DEDES_FIXING_DATE Dedesig.Release Date

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Hedging Relationship DB Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THXT_HREL (
    MANDT,                       -- Client [MANDT]
    OS_GUID,                     -- DB Object ID [TPM_DB_OS_GUID]
    TR_ACC_CODE,                 -- Accounting Code [TPM_ACC_CODE]
    VALUATION_AREA,              -- Valuation Area [TPM_VAL_AREA]
    HREL_NUMBER,                 -- HedgingRel. No. [TPM_HREL_NUMBER]
    FISCAL_YEAR,                 -- Fiscal Year of HR [TPM_HREL_FISCAL_YEAR]
    DESCRIPTION,                 -- HR Description [TPM_HREL_DESCR]
    USER_DATA_OID,               -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_CLS,               -- DB Object ID [TPM_DB_OS_GUID]
    HREL_STATUS,                 -- Status [TPM_HREL_STATUS]
    HREL_DES_DATE,               -- Des. Date [TPM_HREL_DES_DATE]
    HREL_DED_DATE,               -- Dedes.Date [TPM_HREL_DEDES_DATE]
    HREL_PL_DES_DATE,            -- Pl.Des.Date [TPM_HREL_PL_DES_DATE]
    HREL_PL_DED_DATE,            -- Pl.Dedes.Date [TPM_HREL_PL_DEDES_DATE]
    HREL_VALID_FROM,             -- Valid-From Date [TPM_HREL_VALID_FROM_DATE]
    HREL_GROUPING_1,             -- Group. Field 1 [TPM_HREL_GROUPING_1]
    HREL_GROUPING_2,             -- Group. Field 2 [TPM_HREL_GROUPING_2]
    HREL_GROUPING_3,             -- Group. Field 3 [TPM_HREL_GROUPING_3]
    HREL_PROFILE,                -- Hedging Profile [TPM_HREL_PROFILE]
    HREL_MDCRSETID,              -- ID of the MDCR Set [TPM_MDCRSETID]
    HREL_WITHIN_LDC,             -- HR Within LDC [TPM_HREL_WITHIN_LDC]
    HREL_RISK_CURR,              -- Risk Crcy [TPM_RISK_CURRENCY]
    HREL_WITHIN_INIT,            -- HR Within Init. [TPM_HREL_WITHIN_INIT]
    HREL_ROLLOVER,               -- Rollover Y/N [TPM_HREL_ROLLOVER]
    HREL_DES_TYPE,               -- Desig.Type [TOE_DESIGNATION_TYPE]
    HRES_CALC_RULE,              -- Cost H.Res.Calc.Rule [TPM_HRES_CALC_RULE]
    HREL_HEDGING_AREA,           -- Hedging Area [TOE_AREA]
    HREL_SNAPSHOT_ID,            -- Snapshot ID [TOE_SNAPSHOT_ID]
    HREL_SPLIT_ID,               -- Split ID [TOE_SPLIT_ID]
    HREL_REF_NR_ID,              -- Reference [TPM_KL_NR]
    HREL_REF_TYP,                -- Reference Cat. [TPM_KL_TYP]
    HREL_POST_INIT,              -- HR Post-Init. [TPM_HREL_WITHIN_POST_INIT]
    HREL_BAL_SHEET_REC_DATE,     -- B/S Recog. Date [TPM_HREL_BAL_SHEET_REC_DATE]
    HREL_RECLASS_ST_DATE,        -- Alt.Reclass.Dte [TPM_HREL_RECLASS_START_DATE]
    HREL_COUNTER_CURR,           -- Target Crcy [TPM_COUNTER_CURRENCY]
    DCSID,                       -- DCS ID [TBA_DCSID]
    HEDGE_BOOK,                  -- Hedge Book [CMM_HEDGE_BOOK]
    HEDGING_AREA,                -- Hedging Area [CMM_HEDGING_AREA]
    CMM_DELIVERY_START_DATE,     -- Del. Start Date [CMM_HB_DELIVERY_START_DATE]
    CMM_DELIVERY_END_DATE,       -- Del. End Date [CMM_HB_DELIVERY_END_DATE]
    CMM_HEDGE_REQUEST_ID,        -- Hedge Request ID [CMM_HEDGE_REQUEST_ID]
    CMM_HREL_DES_FIXING_DATE,    -- Desig.Release Date [CMM_HREL_DES_FIXING_DATE]
    CMM_HREL_DEDES_FIXING_DATE,  -- Dedesig.Release Date [CMM_HREL_DEDES_FIXING_DATE]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More