I_SERIALNUMBERMANUFACTURINGORD

CDS View
3 Fields 2 CDS Views

Serial Number in Manufacturing Order

I_SERIALNUMBERMANUFACTURINGORD is a CDS View in S/4HANA. Serial Number in Manufacturing Order. It contains 3 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MfgOrdItmNmbrOfSerialNumbers view from COMPOSITE
P_MfgOrdOpSerialNumberForSplit view union_all CONSUMPTION Serial Number that can be split at an Order Operation

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY SerialNumber SerialNumber 1
ManufacturingOrder ManufacturingOrder 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 in Manufacturing Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERIALNUMBERMANUFACTURINGORD (
    MATERIAL,
    SERIALNUMBER,
    MANUFACTURINGORDER,
    PRIMARY KEY (MATERIAL, SERIALNUMBER)
);

Learn More