_MATERIALVH

7 Fields

_MATERIALVH is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY MRPArea MRPArea 2
KEY Plant Plant 2
MaterialBaseUnit MaterialBaseUnit 2
MaterialGroup MaterialGroup 1
MaterialName MaterialName 3
MRPType MRPType 2

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 _MATERIALVH (
    MATERIAL,
    MRPAREA,
    PLANT,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATERIALNAME,
    MRPTYPE,
    PRIMARY KEY (MATERIAL, MRPAREA, PLANT)
);

Learn More