_INSPLOTS

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 _INSPLOTS (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONOPERATION,
    ACCOUNTINGDOCUMENTTYPE,
    BATCH,
    BATCHBYSUPPLIER,
    BATCHSTORAGELOCATION,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUSAGE,
    BILLOFOPERATIONSVARIANT,
    BILLTOPARTYCOUNTRY,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    DELIVERYCATEGORY,
    DELIVERYDOCUMENT,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    GLACCOUNT,
    GOODSMOVEMENTTYPE,
    GOODSRECEIPTISMOVEDTOBLKDSTOCK,
    INSPECTIONCHARACTERISTICSTATUS,
    INSPECTIONDELIVERYCATEGORY,
    INSPECTIONDYNAMICSTAGE,
    INSPECTIONLOTAPPROVAL,
    INSPECTIONLOTCHANGEDBY,
    INSPECTIONLOTCREATEDBY,
    INSPECTIONLOTHASPARTIALLOTS,
    INSPECTIONLOTHASQUANTITY,
    INSPECTIONLOTHASUSAGEDECISION,
    INSPECTIONLOTISFULLINSPECTION,
    INSPECTIONLOTISSKIPPED,
    INSPECTIONLOTOBJECTTEXT,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTPLANT,
    INSPECTIONLOTQUANTITY,
    INSPECTIONLOTQUANTITYUNIT,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTEXT,
    INSPECTIONLOTTYPE,
    INSPECTIONMETHOD,
    INSPECTIONMETHODPLANT,
    INSPECTIONOPERATIONPLANT,
    INSPECTIONSEVERITY,
    INSPECTIONSPECIFICATION,
    INSPECTIONSPECIFICATIONPLANT,
    INSPECTIONSPECIFICATIONTEXT,
    INSPECTIONSUBSETLONGCHARKEY,
    INSPECTIONSUBSETSHORTCHARKEY,
    INSPECTIONSUBSETSORTKEY,
    INSPECTIONSUBSYSTEM,
    INSPECTORQUALIFICATION,
    INSPLOTDIGITALSGNTRINUSGEDCSN,
    INSPLOTDIGITALSGNTRRESULTSRECG,
    INSPLOTHASCONFIGNSPECIFICATION,
    INSPLOTHASMANUALSAMPLESIZE,
    INSPLOTHASMATERIALSPEC,
    INSPLOTISAUTOMUSGEDCSNPOSSIBLE,
    INSPLOTISBATCHREQUIRED,
    INSPLOTISDOCUMENTATIONREQUIRED,
    INSPLOTISSERIALNMBRPOSSIBLE,
    INSPLOTISSTOCKPOSTINGCOMPLETED,
    INSPLOTISTASKLISTREQUIRED,
    INSPLOTNMBRADDLRECORDEDCHARC,
    INSPLOTNMBROPENLONGTERMCHARC,
    INSPLOTNMBROPENSHORTTERMCHARC,
    INSPSPECIMPORTANCECODE,
    INSPSPECINFORMATIONFIELD1,
    INSPSPECINFORMATIONFIELD2,
    INSPSPECINFORMATIONFIELD3,
    INSPSUBSETLONGNUMERICKEY,
    INSPSUBSETSHORTNUMERICKEY,
    INSPSUBSETUSAGEDCSNCODE,
    INSPSUBSETUSAGEDCSNCODEGROUP,
    INSPSUBSETUSAGEDCSNVALUATION,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MANUFACTURINGORDER,
    MATERIAL,
    MATERIALBYCUSTOMER,
    MATERIALCOMPISSPECIALSTOCK,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    MATERIALISBATCHMANAGED,
    MATERIALNAME,
    MATERIALREVISIONLEVEL,
    MATERIALSAMPLE,
    MATERIALSAMPLECATEGORY,
    MATERIALSAMPLEDRAWINGLOCATION,
    MATERIALSAMPLERESPONSIBLENAME,
    MATERIALSAMPLESTORAGELOCATION,
    MATERIALSAMPLETYPE,
    MATLQUALITYAUTHORIZATIONGROUP,
    MATLSMPLDRAWINGLOCDESCRIPTION,
    NUMBEROFSERIALNUMBERS,
    OPERATIONCONFIRMATION,
    OPERATIONCONTROLPROFILE,
    OPERATIONTEXT,
    PLANT,
    PRODUCTIONVERSION,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGORGANIZATION,
    QUALITYCOSTCOLLECTOR,
    ROUTE,
    SALESORDER,
    SALESORDSTOCKWBSELEMENT,
    SALESORGANIZATION,
    SERIALNUMBERPROFILE,
    SMPLDRAWINGPROCEDURE,
    SMPLDRWGPROCEDISCONFREQUIRED,
    SOLDTOPARTY,
    STORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    SUPPLIER,
    WAREHOUSE,
    WORKCENTER,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPECTIONOPERATION)
);