I_SERIALNUMBERMATERIALDOCUMENT

CDS View
5 Fields 3 CDS Views

Serial Number Material Documents

I_SERIALNUMBERMATERIALDOCUMENT is a CDS View in S/4HANA. Serial Number Material Documents. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_SerialNumberMaterialDocument view from COMPOSITE Serial Numbers
I_MaterialDocumentSerialNumber view_entity from COMPOSITE Seial Numbers for Material Document
R_MaterialDocItemSerialNoTP view_entity from TRANSACTIONAL RAP Matdoc Serialnumbers

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentYear MaterialDocumentYear 1
KEY SerialNumber SerialNumber 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.

-- Serial Number Material Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERIALNUMBERMATERIALDOCUMENT (
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    SERIALNUMBER,
    PRIMARY KEY (MATERIAL, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, SERIALNUMBER)
);

Learn More