I_INSPECTIONSUBSET

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.

-- Inspection Point of Inspection Operation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONSUBSET (
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    MATERIALSAMPLE,
    _INSPECTIONLOT,
    _INSPECTIONOPERATION,
    _INSPECTIONSUBSETINTERNALID,
    _INSPSUBSETUSAGEDCSNVALN,
    _INSPSUBSETUSAGEDCSNVALNTXT,
    _UNIT,
    _USAGEDECISIONCODE,
    _USAGEDECISIONCODEGROUP,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INSPECTIONPARTIALLOT,
    INSPECTIONSUBSETDATE,
    INSPECTIONSUBSETLONGCHARKEY,
    INSPECTIONSUBSETQTYUNIT,
    INSPECTIONSUBSETREWORKQTY,
    INSPECTIONSUBSETSCRAPQTY,
    INSPECTIONSUBSETSHORTCHARKEY,
    INSPECTIONSUBSETSORTKEY,
    INSPECTIONSUBSETTIME,
    INSPECTIONSUBSETTIMEZONE,
    INSPECTIONSUBSETYIELDQTY,
    INSPECTOR,
    INSPSBSTDATEFLDPROPERTY,
    INSPSBSTEQUIPPROPERTY,
    INSPSBSTFUNCNLLOCPROPERTY,
    INSPSBSTLONGNMBRFLDPROPERTY,
    INSPSBSTLONGTXTFLDPROPERTY,
    INSPSBSTMATLSMPLPROPERTY,
    INSPSBSTSHRTNMBRFLDPROPERTY,
    INSPSBSTSHRTTXTFLDPROPERTY,
    INSPSBSTTIMEFLDPROPERTY,
    INSPSUBSETLONGNUMERICKEY,
    INSPSUBSETSHORTNUMERICKEY,
    INSPSUBSETUSAGEDCSNCODE,
    INSPSUBSETUSAGEDCSNCODEGROUP,
    INSPSUBSETUSAGEDCSNVALUATION,
    INSPSUBSETUSAGEDECISIONCATALOG,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    SELECTEDCODESET,
    SELECTEDCODESETPLANT,
    SHOPFLOORITEM,
    PRIMARY KEY (INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID, MATERIALSAMPLE)
);