CMMT_HB

Transparent Table Application Table
18 Fields 1 CDS Views

Commodity Hedge Book

CMMT_HB is an SAP database table in S/4HANA. Commodity Hedge Book. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyHdgBookCompleteDetail view_entity from BASIC Commodity Hedge Book

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY hb_id CMM_HEDGE_BOOK Hedge Book
dcs_id TBA_DCSID DCS ID
pricing_period CMM_HB_PRICING_PERIOD Pricing Period
shift_delivery_period CMM_HB_SHIFT_DELIVERY_PERIOD Shift Del. Period
delivery_period TRBA_PERIOD_CLASS Period Class
reference_delivery_perd_shift CMM_HB_REF_DELIV_PERD_SHIFT Commodity Hedge Book - Reference Delivery Period Shift
authorizationgroup CMM_HB_AUTH_GR Authorization Group
product_cat_swap CMM_HB_PRODUCT_CAT Product Category Ind
product_cat_fwd CMM_HB_PRODUCT_CAT Product Category Ind
product_cat_otc CMM_HB_PRODUCT_CAT Product Category Ind
product_cat_lopt CMM_HB_PRODUCT_CAT Product Category Ind
product_cat_fut CMM_HB_PRODUCT_CAT Product Category Ind
is_deprecated CMM_HEDGE_DEPRECATE Deprecated
created_by TB_URENAM User
created_at TIMESTAMPL Time Stamp
changed_by TB_UPUSER Changed By
changed_at TIMESTAMPL Time Stamp

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.

-- Commodity Hedge Book
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_HB (
    CLIENT,                         -- Client [MANDT]
    HB_ID,                          -- Hedge Book [CMM_HEDGE_BOOK]
    DCS_ID,                         -- DCS ID [TBA_DCSID]
    PRICING_PERIOD,                 -- Pricing Period [CMM_HB_PRICING_PERIOD]
    SHIFT_DELIVERY_PERIOD,          -- Shift Del. Period [CMM_HB_SHIFT_DELIVERY_PERIOD]
    DELIVERY_PERIOD,                -- Period Class [TRBA_PERIOD_CLASS]
    REFERENCE_DELIVERY_PERD_SHIFT,  -- Commodity Hedge Book - Reference Delivery Period Shift [CMM_HB_REF_DELIV_PERD_SHIFT]
    AUTHORIZATIONGROUP,             -- Authorization Group [CMM_HB_AUTH_GR]
    PRODUCT_CAT_SWAP,               -- Product Category Ind [CMM_HB_PRODUCT_CAT]
    PRODUCT_CAT_FWD,                -- Product Category Ind [CMM_HB_PRODUCT_CAT]
    PRODUCT_CAT_OTC,                -- Product Category Ind [CMM_HB_PRODUCT_CAT]
    PRODUCT_CAT_LOPT,               -- Product Category Ind [CMM_HB_PRODUCT_CAT]
    PRODUCT_CAT_FUT,                -- Product Category Ind [CMM_HB_PRODUCT_CAT]
    IS_DEPRECATED,                  -- Deprecated [CMM_HEDGE_DEPRECATE]
    CREATED_BY,                     -- User [TB_URENAM]
    CREATED_AT,                     -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,                     -- Changed By [TB_UPUSER]
    CHANGED_AT,                     -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (CLIENT, HB_ID)
);

Learn More