CMM_CUSTQTY_ITM

Transparent Table Application Table
14 Fields 2 CDS Views

Commodity Weights – Sales Item

CMM_CUSTQTY_ITM is an SAP database table in S/4HANA. Commodity Weights – Sales Item. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CustCommodityQuantityItem view from EXTENSION Customer Commodity Item - Extension
I_CustomerCommodityQtyItem view from BASIC Customer Commodity Item

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY uniquespecificationitemuuid CMM_SPECIFICATIONUUID Spec ID
uniquespecificationuuid CMM_SPECIFICATIONUUID Spec ID
commodity TBA_STOEFFCHEN Commodity
commodityquantity CMM_COMMODITY_QTY Commodity Quantity
commodityquantityuom CMM_COMMODITY_QTYUOM Commodity Qty Uom
referencequantity CMM_COMMODITY_REFQTY Comm Refer Quantity
referencequantityuom CMM_COMMODITY_REFQTYUOM Comm RefQty Uom
createdbyuser CMM_COMMODITY_CREATEDBY Created By
creationdatetime CMM_COMMODITY_CREATIONDATETIME Created On
lastchangedbyuser CMM_COMMODITY_LASTCHANGEDUSER Last Changed By
lastchangedatetime CMM_COMMODITY_LASTCHNGDATETIME Last Changed On
locallastchangedat CMM_CMMDTY_LOCLASTCHNGDATETIME Last Changed On
dummy_custqty_itm DUMMY Dummy function in length 1

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 Weights – Sales Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_CUSTQTY_ITM (
    CLIENT,                       -- Client [MANDT]
    UNIQUESPECIFICATIONITEMUUID,  -- Spec ID [CMM_SPECIFICATIONUUID]
    UNIQUESPECIFICATIONUUID,      -- Spec ID [CMM_SPECIFICATIONUUID]
    COMMODITY,                    -- Commodity [TBA_STOEFFCHEN]
    COMMODITYQUANTITY,            -- Commodity Quantity [CMM_COMMODITY_QTY]
    COMMODITYQUANTITYUOM,         -- Commodity Qty Uom [CMM_COMMODITY_QTYUOM]
    REFERENCEQUANTITY,            -- Comm Refer Quantity [CMM_COMMODITY_REFQTY]
    REFERENCEQUANTITYUOM,         -- Comm RefQty Uom [CMM_COMMODITY_REFQTYUOM]
    CREATEDBYUSER,                -- Created By [CMM_COMMODITY_CREATEDBY]
    CREATIONDATETIME,             -- Created On [CMM_COMMODITY_CREATIONDATETIME]
    LASTCHANGEDBYUSER,            -- Last Changed By [CMM_COMMODITY_LASTCHANGEDUSER]
    LASTCHANGEDATETIME,           -- Last Changed On [CMM_COMMODITY_LASTCHNGDATETIME]
    LOCALLASTCHANGEDAT,           -- Last Changed On [CMM_CMMDTY_LOCLASTCHNGDATETIME]
    DUMMY_CUSTQTY_ITM,            -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, UNIQUESPECIFICATIONITEMUUID)
);

Learn More