THMHRT_HR

Transparent Table Application Table
53 Fields 1 CDS Views

Hedge Relationship

THMHRT_HR is an SAP database table in S/4HANA. Hedge Relationship. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ExposureBucket_HR view from BASIC Exposure Bucket hedging relationship

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY rfha tb_rfha Transaction
KEY hedge_id thm_hedge_id Hedged Item ID
KEY hr_version thm_hr_version HR version
hr_comp_key thm_hr_comp_key HR Key
valuation_area tpm_val_area Valuation Area
hr_date thm_hr_date Date HR
hr_cr_date thm_hr_audit System date for hr
hr_time thm_hr_time System time
cruser tb_cruser Entered By
upuser tb_upuser Changed By
vol_derivative thm_des_vol_der Amount Derivative
curr_derivative thm_curr_der Currency
vol_hedge_item thm_des_vol_hedge Des. Amount
curr_hedge_item thm_hedge_currency Hedge Currency
meas_exists thm_hr_valued HR valued
not_deletable thm_hr_not_deletable Y/N
status thm_hr_status HR Status
status_change thm_hr_status_change HR status change
sanlf sanlf Prod. Category
sfgtyp tb_sfgtyp Transaction Cat
sgsart vvsart Product Type
sfhaart tb_sfhaart Transactn Type
rantyp rantyp Contract Type
hr_rate_cat thm_rate_cat HR rate
hr_int_fix thm_hedge_rate_int Strike rate
hr_int_var thm_hedge_rate_int_ref Hedge rate int ref
hr_fx_rate thm_hedge_rate Hedge FX Rate
hr_startval thm_startvalue_set FV at Inception Date
benchmark thm_hr_benchmark Benchmark
fix_benchmark thm_hr_fix_benchmark Benchmark rate
h_rfha ge_hyptrans HypTransaction
hr_spread tha_spread Rate Spread
pmax tb_pmax Upper Limit
pmin tb_pmin Lower Limit
reftyp kl_typ Reference Cat.
refnr kl_nr Reference
hr_begin_date tha_hr_begin_date HdgeRel.StrtDte
kkassa tb_kkassa Spot Rate
dvtrab tb_dvtrab Contract Date
desig_quantity tha_des_quantity Des. Quantity
unit_of_measure tpm_cty_uom Unit of Measure
commodity_id trco_comm_id Cmdty ID (obsolete)
commodity_price ftr_comprice Price
hr_refnr kl_nr Reference
exp_forw_price tha_exp_forw_price Forward Price
comm_id_deriv trco_comm_id Cmdty ID (obsolete)
hedge_des_qty tha_hedge_des_qty Desig. Quantity
hedge_des_uom tpm_cty_uom Unit of Measure
hd_number ftr_hd_number Hypoth. Deriv.
hd_version ftr_hd_version Version No
fp_calc_meth thm_fp_calc_method Frwd Price Calc

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.

-- Hedge Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THMHRT_HR (
    MANDT,            -- Client [mandt]
    BUKRS,            -- Company Code [bukrs]
    RFHA,             -- Transaction [tb_rfha]
    HEDGE_ID,         -- Hedged Item ID [thm_hedge_id]
    HR_VERSION,       -- HR version [thm_hr_version]
    HR_COMP_KEY,      -- HR Key [thm_hr_comp_key]
    VALUATION_AREA,   -- Valuation Area [tpm_val_area]
    HR_DATE,          -- Date HR [thm_hr_date]
    HR_CR_DATE,       -- System date for hr [thm_hr_audit]
    HR_TIME,          -- System time [thm_hr_time]
    CRUSER,           -- Entered By [tb_cruser]
    UPUSER,           -- Changed By [tb_upuser]
    VOL_DERIVATIVE,   -- Amount Derivative [thm_des_vol_der]
    CURR_DERIVATIVE,  -- Currency [thm_curr_der]
    VOL_HEDGE_ITEM,   -- Des. Amount [thm_des_vol_hedge]
    CURR_HEDGE_ITEM,  -- Hedge Currency [thm_hedge_currency]
    MEAS_EXISTS,      -- HR valued [thm_hr_valued]
    NOT_DELETABLE,    -- Y/N [thm_hr_not_deletable]
    STATUS,           -- HR Status [thm_hr_status]
    STATUS_CHANGE,    -- HR status change [thm_hr_status_change]
    SANLF,            -- Prod. Category [sanlf]
    SFGTYP,           -- Transaction Cat [tb_sfgtyp]
    SGSART,           -- Product Type [vvsart]
    SFHAART,          -- Transactn Type [tb_sfhaart]
    RANTYP,           -- Contract Type [rantyp]
    HR_RATE_CAT,      -- HR rate [thm_rate_cat]
    HR_INT_FIX,       -- Strike rate [thm_hedge_rate_int]
    HR_INT_VAR,       -- Hedge rate int ref [thm_hedge_rate_int_ref]
    HR_FX_RATE,       -- Hedge FX Rate [thm_hedge_rate]
    HR_STARTVAL,      -- FV at Inception Date [thm_startvalue_set]
    BENCHMARK,        -- Benchmark [thm_hr_benchmark]
    FIX_BENCHMARK,    -- Benchmark rate [thm_hr_fix_benchmark]
    H_RFHA,           -- HypTransaction [ge_hyptrans]
    HR_SPREAD,        -- Rate Spread [tha_spread]
    PMAX,             -- Upper Limit [tb_pmax]
    PMIN,             -- Lower Limit [tb_pmin]
    REFTYP,           -- Reference Cat. [kl_typ]
    REFNR,            -- Reference [kl_nr]
    HR_BEGIN_DATE,    -- HdgeRel.StrtDte [tha_hr_begin_date]
    KKASSA,           -- Spot Rate [tb_kkassa]
    DVTRAB,           -- Contract Date [tb_dvtrab]
    DESIG_QUANTITY,   -- Des. Quantity [tha_des_quantity]
    UNIT_OF_MEASURE,  -- Unit of Measure [tpm_cty_uom]
    COMMODITY_ID,     -- Cmdty ID (obsolete) [trco_comm_id]
    COMMODITY_PRICE,  -- Price [ftr_comprice]
    HR_REFNR,         -- Reference [kl_nr]
    EXP_FORW_PRICE,   -- Forward Price [tha_exp_forw_price]
    COMM_ID_DERIV,    -- Cmdty ID (obsolete) [trco_comm_id]
    HEDGE_DES_QTY,    -- Desig. Quantity [tha_hedge_des_qty]
    HEDGE_DES_UOM,    -- Unit of Measure [tpm_cty_uom]
    HD_NUMBER,        -- Hypoth. Deriv. [ftr_hd_number]
    HD_VERSION,       -- Version No [ftr_hd_version]
    FP_CALC_METH,     -- Frwd Price Calc [thm_fp_calc_method]
    PRIMARY KEY (MANDT, BUKRS, RFHA, HEDGE_ID, HR_VERSION)
);

Learn More