CMMT_TARGETQUOTA

Transparent Table Application Table
19 Fields 2 CDS Views

Target Hedge Quota Definition

CMMT_TARGETQUOTA is an SAP database table in S/4HANA. Target Hedge Quota Definition. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTargetQuotaDetail view from BASIC Commodity Hedge Target Quota
I_CmmdtyHedgeTargetQuotaHeader view from BASIC Commodity Hedge Target Quota

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY targetquota_uuid SYSUUID_X16 UUID
version CMM_TQ_VERSION Target Quota Version Number
company_code BUKRS Company Code
dcs_id TBA_DCSID DCS ID
direction CMM_HEDGE_DIRECTION Buy or Sell
valid_from CMM_TQ_VALID_FROM TQ ValidFrom
hedge_book CMM_HEDGE_BOOK Hedge Book
period_class TRBA_PERIOD_CLASS Period Class
remark CMM_HEDGE_REMARK Remark
is_active CMM_TQ_ACTIVE_IND TQ Active
is_obsolete CMM_TQ_OBSOLETE_IND TQ Obslt
status_id J_STATUS Status
log_handle APL_LOG_HANDLE Log Handle
is_hedged_fully CMM_TQ_IS_FULLY_HEDGED To Be Fully Hedged
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.

-- Target Hedge Quota Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_TARGETQUOTA (
    CLIENT,            -- Client [MANDT]
    TARGETQUOTA_UUID,  -- UUID [SYSUUID_X16]
    VERSION,           -- Target Quota Version Number [CMM_TQ_VERSION]
    COMPANY_CODE,      -- Company Code [BUKRS]
    DCS_ID,            -- DCS ID [TBA_DCSID]
    DIRECTION,         -- Buy or Sell [CMM_HEDGE_DIRECTION]
    VALID_FROM,        -- TQ ValidFrom [CMM_TQ_VALID_FROM]
    HEDGE_BOOK,        -- Hedge Book [CMM_HEDGE_BOOK]
    PERIOD_CLASS,      -- Period Class [TRBA_PERIOD_CLASS]
    REMARK,            -- Remark [CMM_HEDGE_REMARK]
    IS_ACTIVE,         -- TQ Active [CMM_TQ_ACTIVE_IND]
    IS_OBSOLETE,       -- TQ Obslt [CMM_TQ_OBSOLETE_IND]
    STATUS_ID,         -- Status [J_STATUS]
    LOG_HANDLE,        -- Log Handle [APL_LOG_HANDLE]
    IS_HEDGED_FULLY,   -- To Be Fully Hedged [CMM_TQ_IS_FULLY_HEDGED]
    CREATED_BY,        -- User [TB_URENAM]
    CREATED_AT,        -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,        -- Changed By [TB_UPUSER]
    CHANGED_AT,        -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (CLIENT, TARGETQUOTA_UUID)
);

Learn More