_MATERIALDATAPRIMARY

8 Fields

_MATERIALDATAPRIMARY is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
_Product _Product 2
ChmlCmplncInfoCombinedName ChmlCmplncInfoCombinedName 6
Material Material 6
MaterialIsProduced MaterialIsProduced 1
MaterialIsSold MaterialIsSold 1
MaterialIsSourced MaterialIsSourced 1
MaterialIsTransported MaterialIsTransported 1
MaterialName MaterialName 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 _MATERIALDATAPRIMARY (
    _PRODUCT,
    CHMLCMPLNCINFOCOMBINEDNAME,
    MATERIAL,
    MATERIALISPRODUCED,
    MATERIALISSOLD,
    MATERIALISSOURCED,
    MATERIALISTRANSPORTED,
    MATERIALNAME
);

Learn More