CMMT_HDG_CONSTL

Transparent Table Application Table
18 Fields 1 CDS Views

CMM : Commodity Hedge Constellation

CMMT_HDG_CONSTL is an SAP database table in S/4HANA. CMM : Commodity Hedge Constellation. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyHdgConstellationDetail view from BASIC Commodity Hedge Constellation Details

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY hc_uuid SYSUUID_X16 UUID
KEY record_type CMM_HC_RECORD_TYPE Const. Record Type
valid_from CMM_HC_VALID_FROM Valid-From Timestamp
company_code CMM_HC_COMPANY_CODE Company Code
deal_number CMM_HC_DEAL_NUMBER Transaction
cm_exposure_id CMM_EXPOSURE_ID Plan Exposure ID
exposure_version CMM_EXPOSURE_VERSION Exposure Version No.
exposure_item_id CMM_EXPOSURE_ITEM_ID Exposure Item ID
fx_hedge_request CMM_HC_FX_HREQ_ID Hedge Request ID
mirror_companycode CMM_HC_COMPANY_CODE_MIRROR OICT Company Code
mirror_dealnumber CMM_HC_DEAL_NUMBER_MIRROR OIC Transaction
mirror_exposureitemid CMM_EXPOSURE_ITEM_ID Exposure Item ID
mirror_fxhedgerequest CMM_HC_FX_HREQ_ID_MIRROR Off. ICT FX HReq.
internal_companycode CMM_HC_COMPANY_CODE_INTERNAL ICT Company Code
internal_dealnumber CMM_HC_DEAL_NUMBER_INTERNAL IC Transaction
internal_exposureitemid CMM_EXPOSURE_ITEM_ID Exposure Item ID
internal_fxhedgerequest CMM_HC_FX_HREQ_ID_INTERNAL Intercomp. FX HReq.

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.

-- CMM : Commodity Hedge Constellation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_HDG_CONSTL (
    CLIENT,                   -- Client [MANDT]
    HC_UUID,                  -- UUID [SYSUUID_X16]
    RECORD_TYPE,              -- Const. Record Type [CMM_HC_RECORD_TYPE]
    VALID_FROM,               -- Valid-From Timestamp [CMM_HC_VALID_FROM]
    COMPANY_CODE,             -- Company Code [CMM_HC_COMPANY_CODE]
    DEAL_NUMBER,              -- Transaction [CMM_HC_DEAL_NUMBER]
    CM_EXPOSURE_ID,           -- Plan Exposure ID [CMM_EXPOSURE_ID]
    EXPOSURE_VERSION,         -- Exposure Version No. [CMM_EXPOSURE_VERSION]
    EXPOSURE_ITEM_ID,         -- Exposure Item ID [CMM_EXPOSURE_ITEM_ID]
    FX_HEDGE_REQUEST,         -- Hedge Request ID [CMM_HC_FX_HREQ_ID]
    MIRROR_COMPANYCODE,       -- OICT Company Code [CMM_HC_COMPANY_CODE_MIRROR]
    MIRROR_DEALNUMBER,        -- OIC Transaction [CMM_HC_DEAL_NUMBER_MIRROR]
    MIRROR_EXPOSUREITEMID,    -- Exposure Item ID [CMM_EXPOSURE_ITEM_ID]
    MIRROR_FXHEDGEREQUEST,    -- Off. ICT FX HReq. [CMM_HC_FX_HREQ_ID_MIRROR]
    INTERNAL_COMPANYCODE,     -- ICT Company Code [CMM_HC_COMPANY_CODE_INTERNAL]
    INTERNAL_DEALNUMBER,      -- IC Transaction [CMM_HC_DEAL_NUMBER_INTERNAL]
    INTERNAL_EXPOSUREITEMID,  -- Exposure Item ID [CMM_EXPOSURE_ITEM_ID]
    INTERNAL_FXHEDGEREQUEST,  -- Intercomp. FX HReq. [CMM_HC_FX_HREQ_ID_INTERNAL]
    PRIMARY KEY (CLIENT, HC_UUID, RECORD_TYPE)
);

Learn More