THXT_HITEM

Transparent Table Application Table
17 Fields 3 CDS Views

Hedge Item DB table

THXT_HITEM is an SAP database table in S/4HANA. Hedge Item DB table. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_HedgedItem view_entity from BASIC Hedged Item
I_TrsyFinExpsrSubitemText view_entity inner BASIC Exposure Subitem Description
P_TrsyHedgeAcctgAttributes view_entity from BASIC Hedge Accounting Attributes

Fields (17)

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
hitem_number tpm_hitem_number Hedged Item No.
fiscal_year gjahr Fiscal Year
description tpm_hitem_descr HItem Desc.
hitem_category tpm_hitem_category HItem Category
hrel_oid tpm_db_os_guid DB Object ID
hrel_cls tpm_db_os_guid DB Object ID
user_data_oid tpm_db_os_guid DB Object ID
user_data_cls tpm_db_os_guid DB Object ID
hitem_startdate tpm_hitem_start_date HItem StartDate
hitem_pl_enddate tpm_hitem_plan_end_date Pl.End Date
hitem_enddate tpm_hitem_end_date HItem EndDate
hedge_spread tpm_hedge_spread Hedge Spread
hyp_derivative ftr_hd_number Hypoth. Deriv.

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 Item DB table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THXT_HITEM (
    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]
    HITEM_NUMBER,      -- Hedged Item No. [tpm_hitem_number]
    FISCAL_YEAR,       -- Fiscal Year [gjahr]
    DESCRIPTION,       -- HItem Desc. [tpm_hitem_descr]
    HITEM_CATEGORY,    -- HItem Category [tpm_hitem_category]
    HREL_OID,          -- DB Object ID [tpm_db_os_guid]
    HREL_CLS,          -- DB Object ID [tpm_db_os_guid]
    USER_DATA_OID,     -- DB Object ID [tpm_db_os_guid]
    USER_DATA_CLS,     -- DB Object ID [tpm_db_os_guid]
    HITEM_STARTDATE,   -- HItem StartDate [tpm_hitem_start_date]
    HITEM_PL_ENDDATE,  -- Pl.End Date [tpm_hitem_plan_end_date]
    HITEM_ENDDATE,     -- HItem EndDate [tpm_hitem_end_date]
    HEDGE_SPREAD,      -- Hedge Spread [tpm_hedge_spread]
    HYP_DERIVATIVE,    -- Hypoth. Deriv. [ftr_hd_number]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More