I_SERIALNUMBERMATERIALDOC_2

CDS View
2 Fields 2 CDS Views

Serial Number in Material Document

I_SERIALNUMBERMATERIALDOC_2 is a CDS View in S/4HANA. Serial Number in Material Document. It contains 2 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_InspLotMatlDocItmSrlNmbr view from CONSUMPTION Serial Numbers for Stock Posting
P_InspSrlNmbrUsgeDcsnStkPostd view from COMPOSITE Serial Number Usage Decision Posted

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY SerialNumber SerialNumber 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.

-- Serial Number in Material Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERIALNUMBERMATERIALDOC_2 (
    EQUIPMENT,
    SERIALNUMBER,
    PRIMARY KEY (EQUIPMENT, SERIALNUMBER)
);

Learn More