I_EQUIPMATLSERIALNUMBER

CDS View
4 Fields 6 CDS Views

Material Serial Number

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_DfctRecdAvailSerialNumberVH view_entity union CONSUMPTION Defect Recording Avail Serial Number
I_EquipMatlSrlNmbrChgHistory view_entity inner COMPOSITE Equip Mat Serial Number Change History
I_EquipMatlSrlNmbrChgHistory view_entity union_all COMPOSITE Equip Mat Serial Number Change History
I_EquipMatlSrlNumberWarranty view_entity from COMPOSITE Material Serial Number Warranty
R_EquipMatlSerialNumberTP view_entity from TRANSACTIONAL Material Serial Number - TP
R_EquipMatlSrlNmbrPrtnTP view_entity from TRANSACTIONAL Partner of Material Serial Number - TP

Fields (4)

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

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

Learn More