MATERIALID

Transparent Table Application Table
11 Fields 3 CDS Views

Material Identification

MATERIALID is an SAP database table in S/4HANA. Material Identification. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_MATERIAL_MASTER_B view left_outer Material Master based CDS View
I_JITOutbMaterialId view left_outer BASIC JIT S2P - S2L Material ID
ScmPrd_MatMap_Union view union_all Union of MARA and MATERIALID

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr_int matnr_int Material
matnr_ext matnr_ext Material Number
matnr_vers matnr_vers Version Number
matnr_guid matnr_iguid GUID (Material)
matnr_type matnr_type Material No. Type
matnr_head matnr_head Header Material
sptyp mgv_spec_type Spec.Cat.
matnr_sel matnr_sel Material
matnr_long matnr Material
matnr_arc matnr_arc Archived

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.

-- Material Identification
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATERIALID (
    MANDT,       -- Client [mandt]
    MATNR_INT,   -- Material [matnr_int]
    MATNR_EXT,   -- Material Number [matnr_ext]
    MATNR_VERS,  -- Version Number [matnr_vers]
    MATNR_GUID,  -- GUID (Material) [matnr_iguid]
    MATNR_TYPE,  -- Material No. Type [matnr_type]
    MATNR_HEAD,  -- Header Material [matnr_head]
    SPTYP,       -- Spec.Cat. [mgv_spec_type]
    MATNR_SEL,   -- Material [matnr_sel]
    MATNR_LONG,  -- Material [matnr]
    MATNR_ARC,   -- Archived [matnr_arc]
    PRIMARY KEY (MANDT, MATNR_INT)
);

Learn More