CMMT_TQ_POSITION

Transparent Table Application Table
15 Fields 2 CDS Views

Commodity Hedge Target Quota Positions

CMMT_TQ_POSITION is an SAP database table in S/4HANA. Commodity Hedge Target Quota Positions. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTargetQuotaPosition view from BASIC Commodity Hedge Target Quota Positions
I_CmmdtyHdgTgtQtaPositionYear view from BASIC Commodity Hedge TQ Positions Year

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tq_pos_uuid SYSUUID_X16 UUID
targetquota_uuid SYSUUID_X16 UUID
position_valid_from CMM_TQ_POSITION_VALID_FROM Valid-From Date of Target Quota Position
position_year CMM_HEDGE_YEAR Position Year
period_class TRBA_PERIOD_CLASS Period Class
period_number CMM_PERIOD_NUMBER Period Number
hedge_management_quota CMM_TARGET_HEDGE_LIMIT_MAX Target Hdg Quota(%)
hedge_accounting_quota CMM_TARGET_HACC_LIMIT_MAX Target Hdg Quota(%)
remark CMM_HEDGE_REMARK Remark
is_active CMM_TQ_ACTIVE_IND TQ Active
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 Target Quota Positions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMT_TQ_POSITION (
    MANDT,                   -- Client [MANDT]
    TQ_POS_UUID,             -- UUID [SYSUUID_X16]
    TARGETQUOTA_UUID,        -- UUID [SYSUUID_X16]
    POSITION_VALID_FROM,     -- Valid-From Date of Target Quota Position [CMM_TQ_POSITION_VALID_FROM]
    POSITION_YEAR,           -- Position Year [CMM_HEDGE_YEAR]
    PERIOD_CLASS,            -- Period Class [TRBA_PERIOD_CLASS]
    PERIOD_NUMBER,           -- Period Number [CMM_PERIOD_NUMBER]
    HEDGE_MANAGEMENT_QUOTA,  -- Target Hdg Quota(%) [CMM_TARGET_HEDGE_LIMIT_MAX]
    HEDGE_ACCOUNTING_QUOTA,  -- Target Hdg Quota(%) [CMM_TARGET_HACC_LIMIT_MAX]
    REMARK,                  -- Remark [CMM_HEDGE_REMARK]
    IS_ACTIVE,               -- TQ Active [CMM_TQ_ACTIVE_IND]
    CREATED_BY,              -- User [TB_URENAM]
    CREATED_AT,              -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,              -- Changed By [TB_UPUSER]
    CHANGED_AT,              -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, TQ_POS_UUID)
);

Learn More