I_INSPECTIONRESULTHISTORY

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 Result History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONRESULTHISTORY (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPPLANOPERATIONINTERNALID,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _CHARCATTRIBUTECODE,
    _CHARCATTRIBUTECODEGRP,
    _INSPCHARACTERISTICSAMPLEUNIT,
    _INSPECTIONLOTORIGIN,
    _INSPECTIONLOTTYPE,
    _INSPECTIONRESULTATTRIBUTE,
    _INSPECTIONSPECIFICATION,
    _INSPECTIONSPECIFICATIONPLANT,
    _INSPECTIONSPECIFICATIONUNIT,
    _INSPECTIONVALUATIONRESULT,
    _INSPLOTSELECTIONCUSTOMER,
    _INSPLOTSELECTIONSUPPLIER,
    _INSPLOTSELMANUFACTURER,
    _INSPSPECCHARCTYPE,
    _INSPSPECIFICATIONVERSION,
    _MATERIAL,
    _PLANT,
    _WORKCENTER,
    BATCH,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BOOCHARACTERISTICVERSION,
    BOOOPERATIONINTERNALID,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CREATIONDATE,
    INSPCHARACTERISTICSAMPLESIZE,
    INSPCHARACTERISTICSAMPLEUNIT,
    INSPCHARCISNOTPLANNED,
    INSPECTIONCHARACTERISTICTEXT,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTTYPE,
    INSPECTIONOPERATION,
    INSPECTIONPARTIALSAMPLESIZE,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTMAXIMUMVALUE,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTMINIMUMVALUE,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTSTATUS,
    INSPECTIONRESULTTEXT,
    INSPECTIONSPECIFICATION,
    INSPECTIONSPECIFICATIONPLANT,
    INSPECTIONSPECIFICATIONUNIT,
    INSPECTIONSPECIFICATIONVERSION,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPLOTSELECTIONCUSTOMER,
    INSPLOTSELECTIONMANUFACTURER,
    INSPLOTSELECTIONMATERIAL,
    INSPLOTSELECTIONSUPPLIER,
    INSPRESULTVALIDVALUESNUMBER,
    INSPRESULTVARIANCE,
    INSPRSLTABOVETOLERANCEFRACTION,
    INSPRSLTABOVETOLERANCEVALSNMBR,
    INSPRSLTBELOWTOLERANCEFRACTION,
    INSPRSLTBELOWTOLERANCEVALSNMBR,
    INSPRSLTNONCONFORMINGVALSNMBR,
    INSPSPECCHARACTERISTICTYPE,
    INSPSPECDECIMALPLACES,
    INSPSPECHASLOWERLIMIT,
    INSPSPECHASUPPERLIMIT,
    INSPSPECLOWERLIMIT,
    INSPSPECRECORDINGTYPE,
    INSPSPECSAMPLEQUANTITYFACTOR,
    INSPSPECTARGETVALUE,
    INSPSPECUPPERLIMIT,
    ISBUSINESSPURPOSECOMPLETED,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    WORKCENTER,
    WORKCENTERINTERNALID,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPPLANOPERATIONINTERNALID)
);