_DEFECT

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 _DEFECT (
    DEFECTINTERNALID,
    _DEFECTCODE,
    _DEFECTCODEGROUP,
    _DEFECTSTATUS,
    _INSPECTIONLOT,
    BATCH,
    CHANGEDDATETIME,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTCATEGORY,
    DEFECTCAUSEDBY,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTCODEVERSION,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTLOCATIONCATALOG,
    DEFECTLOCATIONCODE,
    DEFECTLOCATIONCODEGROUP,
    DEFECTLOCATIONCODEVERSION,
    DEFECTORIGIN,
    DEFECTTEXT,
    DEFECTUUID,
    EWMWAREHOUSE,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIAL,
    MATERIALSAMPLE,
    NUMBEROFDEFECTS,
    ORDERINTERNALID,
    PLANT,
    PROBLEMANALYSISSTATUS,
    PRODUCTIONORDER,
    PRODUCTIONORDERSEQUENCE,
    PRODUCTIONSUPPLYAREA,
    QUALITYISSUEREFERENCE,
    SOURCESTORAGEBIN,
    SOURCESTORAGETYPE,
    STORAGELOCATION,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID)
);