CMMT_HC_WL

Transparent Table Application Table
26 Fields 1 CDS Views

CMM: Commodity Hedge Constellation Worklist

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyHdgCnstltnTaskList view_entity from BASIC Commodity Hedge Constellation Task List

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY hc_wl_uuid CMM_HC_WL_UUID Worklist UUID
hc_worklist_id CMM_HC_WORKLIST_ID Worklist ID
hc_uuid SYSUUID_X16 UUID
hc_reproc_reason CMM_HC_REPROC_REASON Reprocessing Reason
hc_reproc_status CMM_HC_REPROC_STATUS HC Reproc Status
hc_reproc_stschng_reason CMM_HC_REPROC_STSCHNG_REASON Status Change Reason
hc_wl_remark CMM_HC_WL_REMARK Remark for Worklist
origin CMM_HC_WL_ORIGIN Reason Origin
process CMM_HC_WL_XFLG_PROCESS Task process
company_code BUKRS Company Code
deal_id TB_RFHA Transaction
amount TB_BZBETR Payment Amnt in PyC
currency TB_WZBETR Payment Currency
counterparty TB_KUNNR_NEW Partner
portfolio RPORTB Portfolio
hedge_class TOE_HEDGING_CLASSIFICATION Hedging Classificatn
late_dsgntn_date CMM_HC_LATE_DESIGNATION_DATE Lt Dsgntn Date
portfolio_ori RPORTB Portfolio
hedge_class_ori TOE_HEDGING_CLASSIFICATION Hedging Classificatn
log_handle CMM_APL_LOG_HANDLE Log Handle
created_by TB_URENAM User
created_at TIMESTAMPL Time Stamp
changed_by TB_UPUSER Changed By
changed_at TIMESTAMPL Time Stamp
local_last_change_datetime 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.

-- CMM: Commodity Hedge Constellation Worklist
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_HC_WL (
    CLIENT,                      -- Client [MANDT]
    HC_WL_UUID,                  -- Worklist UUID [CMM_HC_WL_UUID]
    HC_WORKLIST_ID,              -- Worklist ID [CMM_HC_WORKLIST_ID]
    HC_UUID,                     -- UUID [SYSUUID_X16]
    HC_REPROC_REASON,            -- Reprocessing Reason [CMM_HC_REPROC_REASON]
    HC_REPROC_STATUS,            -- HC Reproc Status [CMM_HC_REPROC_STATUS]
    HC_REPROC_STSCHNG_REASON,    -- Status Change Reason [CMM_HC_REPROC_STSCHNG_REASON]
    HC_WL_REMARK,                -- Remark for Worklist [CMM_HC_WL_REMARK]
    ORIGIN,                      -- Reason Origin [CMM_HC_WL_ORIGIN]
    PROCESS,                     -- Task process [CMM_HC_WL_XFLG_PROCESS]
    COMPANY_CODE,                -- Company Code [BUKRS]
    DEAL_ID,                     -- Transaction [TB_RFHA]
    AMOUNT,                      -- Payment Amnt in PyC [TB_BZBETR]
    CURRENCY,                    -- Payment Currency [TB_WZBETR]
    COUNTERPARTY,                -- Partner [TB_KUNNR_NEW]
    PORTFOLIO,                   -- Portfolio [RPORTB]
    HEDGE_CLASS,                 -- Hedging Classificatn [TOE_HEDGING_CLASSIFICATION]
    LATE_DSGNTN_DATE,            -- Lt Dsgntn Date [CMM_HC_LATE_DESIGNATION_DATE]
    PORTFOLIO_ORI,               -- Portfolio [RPORTB]
    HEDGE_CLASS_ORI,             -- Hedging Classificatn [TOE_HEDGING_CLASSIFICATION]
    LOG_HANDLE,                  -- Log Handle [CMM_APL_LOG_HANDLE]
    CREATED_BY,                  -- User [TB_URENAM]
    CREATED_AT,                  -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,                  -- Changed By [TB_UPUSER]
    CHANGED_AT,                  -- Time Stamp [TIMESTAMPL]
    LOCAL_LAST_CHANGE_DATETIME,  -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (CLIENT, HC_WL_UUID)
);

Learn More