P_EQUIPMATLSERIALNUMBERSTATUS

CDS View

P_EQUIPMATLSERIALNUMBERSTATUS is a CDS View in S/4HANA. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EquipMatlSerialNumStatusAggr view from COMPOSITE

Fields (4)

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

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EQUIPMATLSERIALNUMBERSTATUS (
    MATERIAL,
    SERIALNUMBER,
    _MATERIAL,
    MAINTOBJECTINTERNALID,
    PRIMARY KEY (MATERIAL, SERIALNUMBER)
);