P_PRODUCTUNITSOFMEASURED

CDS View

P_PRODUCTUNITSOFMEASURED is a CDS View in S/4HANA. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_Productsuppliereanwd view inner COMPOSITE
P_Productunitofmeasuretextwd view inner COMPOSITE
P_ProductUnitsOfMeasureWD view left_outer COMPOSITE
P_ProductUnitsOfMeasureWD view union_all COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ActiveAlternativeUnit ActiveAlternativeUnit 1
KEY Activeproduct Activeproduct 1
alternativeunit alternativeunit,ProductUnit 2
globaltradeitemnumber globaltradeitemnumber 1
globaltradeitemnumbercategory globaltradeitemnumbercategory 1
grossweight grossweight 1
lowerlevelpackagingunit lowerlevelpackagingunit 1
materialvolume materialvolume 1
ParentDraftKey ParentDraftKey 1
productmeasurementunit productmeasurementunit 1
quantitydenominator quantitydenominator 1
quantitynumerator quantitynumerator 1
unitspecificproductheight unitspecificproductheight 1
unitspecificproductlength unitspecificproductlength 1
unitspecificproductwidth unitspecificproductwidth 1
volumeunit volumeunit 1
weightunit weightunit 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODUCTUNITSOFMEASURED (
    ACTIVEALTERNATIVEUNIT,
    ACTIVEPRODUCT,
    ALTERNATIVEUNIT,
    GLOBALTRADEITEMNUMBER,
    GLOBALTRADEITEMNUMBERCATEGORY,
    GROSSWEIGHT,
    LOWERLEVELPACKAGINGUNIT,
    MATERIALVOLUME,
    PARENTDRAFTKEY,
    PRODUCTMEASUREMENTUNIT,
    QUANTITYDENOMINATOR,
    QUANTITYNUMERATOR,
    UNITSPECIFICPRODUCTHEIGHT,
    UNITSPECIFICPRODUCTLENGTH,
    UNITSPECIFICPRODUCTWIDTH,
    VOLUMEUNIT,
    WEIGHTUNIT,
    PRIMARY KEY (ACTIVEALTERNATIVEUNIT, ACTIVEPRODUCT)
);