PRD_UOM

Transparent Table Application Table

Product: Draft Unit of Measure Node

PRD_UOM is an SAP database table in S/4HANA. Product: Draft Unit of Measure Node. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductUnitsOfMeasureD view from BASIC

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
activeproduct PRODUCTNUMBER Product
activealternativeunit ALTERNATIVEUNIT Alternative UoM
alternativeunit ALTERNATIVEUNIT Alternative UoM
quantitynumerator QUANTITYNUMERATOR Base Quantity
quantitydenominator QUANTITYDENOMINATOR AlternativeQuan
materialvolume MATERIALVOLUME Volume
volumeunit VOLUMEUNIT Volume unit
grossweight GROSSWEIGHT Gross weight
weightunit WEIGHTUNIT Weight unit
unitspecificproductlength UNITSPECIFICPRODUCTLENGTH Length
unitspecificproductwidth UNITSPECIFICPRODUCTWIDTH Width
unitspecificproductheight UNITSPECIFICPRODUCTHEIGHT Height
productmeasurementunit PRODUCTMEASUREMENTUNIT Unit
lowerlevelpackagingunit LOWERLEVELPACKAGINGUNIT Lower-lev. unit
globaltradeitemnumber GLOBALTRADEITEMNUMBER GTIN
globaltradeitemnumbercategory GLOBALTRADEITEMNUMBERCATEGORY EAN category
dummy_uom_incl_eew_ps UOM_INCL_EEW MD Product 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.

-- Product: Draft Unit of Measure Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_UOM (
    CLIENT,                         -- Client [MANDT]
    DRAFTKEY,                       -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                 -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,                -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                  -- Product [PRODUCTNUMBER]
    ACTIVEALTERNATIVEUNIT,          -- Alternative UoM [ALTERNATIVEUNIT]
    ALTERNATIVEUNIT,                -- Alternative UoM [ALTERNATIVEUNIT]
    QUANTITYNUMERATOR,              -- Base Quantity [QUANTITYNUMERATOR]
    QUANTITYDENOMINATOR,            -- AlternativeQuan [QUANTITYDENOMINATOR]
    MATERIALVOLUME,                 -- Volume [MATERIALVOLUME]
    VOLUMEUNIT,                     -- Volume unit [VOLUMEUNIT]
    GROSSWEIGHT,                    -- Gross weight [GROSSWEIGHT]
    WEIGHTUNIT,                     -- Weight unit [WEIGHTUNIT]
    UNITSPECIFICPRODUCTLENGTH,      -- Length [UNITSPECIFICPRODUCTLENGTH]
    UNITSPECIFICPRODUCTWIDTH,       -- Width [UNITSPECIFICPRODUCTWIDTH]
    UNITSPECIFICPRODUCTHEIGHT,      -- Height [UNITSPECIFICPRODUCTHEIGHT]
    PRODUCTMEASUREMENTUNIT,         -- Unit [PRODUCTMEASUREMENTUNIT]
    LOWERLEVELPACKAGINGUNIT,        -- Lower-lev. unit [LOWERLEVELPACKAGINGUNIT]
    GLOBALTRADEITEMNUMBER,          -- GTIN [GLOBALTRADEITEMNUMBER]
    GLOBALTRADEITEMNUMBERCATEGORY,  -- EAN category [GLOBALTRADEITEMNUMBERCATEGORY]
    DUMMY_UOM_INCL_EEW_PS,          -- MD Product UOM [UOM_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);