CMM_REXS_AGGR

Transparent Table Application Table
31 Fields 1 CDS Views

Stock on hand Aggregate

CMM_REXS_AGGR is an SAP database table in S/4HANA. Stock on hand Aggregate. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyTotalStockOnHand view_entity from BASIC Commodity Total Stock On Hand

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pricing_key CMM_VLOGP_PRICING_KEY Pricing Key
KEY version CMM_MTM_VERSION Version
entity_key CMM_DEND_ENTITY_KEY Entity
cutofftimestamp CMM_REXS_CUTOFF_TIMESTAMP Cut off Date/Time
creationtimestamp CREATION_TIMESTAMP Creation Date/Time
bukrs BUKRS Company Code
werks WERKS_D Plant
matnr MATNR Material
lgort LGORT_D Location
charg CHARG_D Batch
commodity TBA_STOEFFCHEN Commodity
record_type CMM_VLOGP_REC_TYPE Type of Data Record
signage_qty CMM_VLOGP_SIGNAGE_QTY Sign of Quantity
mglme CMM_MTM_MENGE_D_BASE Qty Base UoM
lagme LAGME Base Unit
commodity_quan CMM_MTM_QUAN_COMM Cmdty Quantity
commodity_uom CMM_MTM_QUAN_COMMUOM Cmdty UoM
commodity_rf_uom REFME_WS Ref. UoM
commodity_quan_mass CMM_MTM_QUAN_COMM_MASS Quantity in Mass UoM
commodity_mass_uom CMM_MTM_QUAN_COMMUOM Cmdty UoM
commodity_quan_volume CMM_MTM_QUAN_COMM_VOLUME Quantity in Vol UoM
commodity_volume_uom CMM_MTM_QUAN_COMMUOM Cmdty UoM
event_type CMM_REXS_INVENTORY_EVENT Inventory Event
qrep_guid CMM_REXS_Q_REP_GUID Q-Rep GUID
qrep_version CMM_REXS_SQ_REP_VERSION Q-Rep GUID Version
schedule_guid CMM_REXS_DPQS_GUID DPQS GUID
net_quan CMM_REXS_NET_QTY_BASE Net Quantity
net_quan_comm CMM_REXS_NET_QTY_CMMDTY Net Qty cmdty UOM
net_quan_mass CMM_REXS_NET_QTY_MASS Net Qty Mass UOM
net_quan_volume CMM_REXS_NET_QTY_VOLUME Net Qty Vol UOM

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.

-- Stock on hand Aggregate
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_REXS_AGGR (
    MANDT,                  -- Client [MANDT]
    PRICING_KEY,            -- Pricing Key [CMM_VLOGP_PRICING_KEY]
    VERSION,                -- Version [CMM_MTM_VERSION]
    ENTITY_KEY,             -- Entity [CMM_DEND_ENTITY_KEY]
    CUTOFFTIMESTAMP,        -- Cut off Date/Time [CMM_REXS_CUTOFF_TIMESTAMP]
    CREATIONTIMESTAMP,      -- Creation Date/Time [CREATION_TIMESTAMP]
    BUKRS,                  -- Company Code [BUKRS]
    WERKS,                  -- Plant [WERKS_D]
    MATNR,                  -- Material [MATNR]
    LGORT,                  -- Location [LGORT_D]
    CHARG,                  -- Batch [CHARG_D]
    COMMODITY,              -- Commodity [TBA_STOEFFCHEN]
    RECORD_TYPE,            -- Type of Data Record [CMM_VLOGP_REC_TYPE]
    SIGNAGE_QTY,            -- Sign of Quantity [CMM_VLOGP_SIGNAGE_QTY]
    MGLME,                  -- Qty Base UoM [CMM_MTM_MENGE_D_BASE]
    LAGME,                  -- Base Unit [LAGME]
    COMMODITY_QUAN,         -- Cmdty Quantity [CMM_MTM_QUAN_COMM]
    COMMODITY_UOM,          -- Cmdty UoM [CMM_MTM_QUAN_COMMUOM]
    COMMODITY_RF_UOM,       -- Ref. UoM [REFME_WS]
    COMMODITY_QUAN_MASS,    -- Quantity in Mass UoM [CMM_MTM_QUAN_COMM_MASS]
    COMMODITY_MASS_UOM,     -- Cmdty UoM [CMM_MTM_QUAN_COMMUOM]
    COMMODITY_QUAN_VOLUME,  -- Quantity in Vol UoM [CMM_MTM_QUAN_COMM_VOLUME]
    COMMODITY_VOLUME_UOM,   -- Cmdty UoM [CMM_MTM_QUAN_COMMUOM]
    EVENT_TYPE,             -- Inventory Event [CMM_REXS_INVENTORY_EVENT]
    QREP_GUID,              -- Q-Rep GUID [CMM_REXS_Q_REP_GUID]
    QREP_VERSION,           -- Q-Rep GUID Version [CMM_REXS_SQ_REP_VERSION]
    SCHEDULE_GUID,          -- DPQS GUID [CMM_REXS_DPQS_GUID]
    NET_QUAN,               -- Net Quantity [CMM_REXS_NET_QTY_BASE]
    NET_QUAN_COMM,          -- Net Qty cmdty UOM [CMM_REXS_NET_QTY_CMMDTY]
    NET_QUAN_MASS,          -- Net Qty Mass UOM [CMM_REXS_NET_QTY_MASS]
    NET_QUAN_VOLUME,        -- Net Qty Vol UOM [CMM_REXS_NET_QTY_VOLUME]
    PRIMARY KEY (MANDT, PRICING_KEY, VERSION)
);

Learn More