CMM_STRUC_QTY

Transparent Table Application Table
13 Fields 2 CDS Views

Commodity Structural Weights

CMM_STRUC_QTY is an SAP database table in S/4HANA. Commodity Structural Weights. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CommodityStructuralQuantity view from EXTENSION Commodity Structural Quantity - Extension
I_CommodityStructuralQuantity view_entity from BASIC Commodity Quantity Structural Info

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY product MATNR Material
KEY plant WERKS_D Plant
KEY 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
dummy_embd_commodity_incl_ps CMM_EMBEDDED_COMMODITY_INCL Embedded Commodity extensible field element

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 Structural Weights
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_STRUC_QTY (
    CLIENT,                        -- Client [MANDT]
    PRODUCT,                       -- Material [MATNR]
    PLANT,                         -- Plant [WERKS_D]
    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]
    DUMMY_EMBD_COMMODITY_INCL_PS,  -- Embedded Commodity extensible field element [CMM_EMBEDDED_COMMODITY_INCL]
    PRIMARY KEY (CLIENT, PRODUCT, PLANT, COMMODITY)
);

Learn More