I_DEFECTSERIALNUMBER

CDS View
6 Fields 4 CDS Views

Serial Number in Defect

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_DefectSerialNumberFDP view_entity from CONSUMPTION FDP for Serial Number in Defect
I_DefectSerialNumberTP view from TRANSACTIONAL Serial Number in Defect - TP
P_DefectSerialNumber view_entity from COMPOSITE Defect Serial Number
R_DefectSerialNumberTP view_entity from TRANSACTIONAL Serial Number in Defect - TP

Fields (6)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 3
KEY DfctSerialNmbrSequentialNumber DfctSerialNmbrSequentialNumber 3
Defect Defect 2
Equipment Equipment 3
SerialNumber SerialNumber 3
SerialNumberAssignmentDateTime SerialNumberAssignmentDateTime 3

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 Defect
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEFECTSERIALNUMBER (
    DEFECTINTERNALID,
    DFCTSERIALNMBRSEQUENTIALNUMBER,
    DEFECT,
    EQUIPMENT,
    SERIALNUMBER,
    SERIALNUMBERASSIGNMENTDATETIME,
    PRIMARY KEY (DEFECTINTERNALID, DFCTSERIALNMBRSEQUENTIALNUMBER)
);

Learn More