P_MATERIALINFO

CDS View
6 Fields 2 CDS Views

P_MATERIALINFO is a CDS View in S/4HANA. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BatchInfo view inner COMPOSITE
P_CustomerOrder view inner BASIC

Fields (6)

KeyField CDS FieldsUsed in Views
BaseUnitOfMeasure BaseUnitOfMeasure 1
Costprice StandardPrice 1
MaterialPriceInCoCodeCurrency MaterialPriceInCoCodeCurrency 1
Price MaterialPrice 1
PriceUnit MaterialPriceUnit 1
Umrez Umrez 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_MATERIALINFO (
    BASEUNITOFMEASURE,
    COSTPRICE,
    MATERIALPRICEINCOCODECURRENCY,
    PRICE,
    PRICEUNIT,
    UMREZ
);

Learn More