_OP

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 _OP (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BOOOPERATIONINTERNALID,
    BOOOPINTERNALVERSIONCOUNTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONSBREAKDURNUNIT,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _BOOOPERATIONINTERNALID,
    _CAPACITYCATEGORY,
    _CHANGEMASTER,
    _CONTROLRECIPEDESTINATION,
    _FACTORYCALENDAR,
    _INSPECTIONLOTTYPE,
    _INSPRESULTRECORDINGVIEW,
    _LEADTIMEREDUCTIONSTRATEGY,
    _LONGTEXTLANGUAGE,
    _MATERIALGROUP,
    _MAXIMUMWAITDURATIONUNIT,
    _MINIMUMMOVEDURATIONUNIT,
    _MINIMUMQUEUEDURATIONUNIT,
    _MINIMUMWAITDURATIONUNIT,
    _MINPROCESSINGDURNPERSPLITUNIT,
    _OPERATIONSETUPGROUP,
    _OPERATIONSETUPGROUPCATEGORY,
    _OPERATIONSTDWORKQTYGRPGCAT,
    _OPERATIONUNIT,
    _OPEXTERNALPROCESSINGCURRENCY,
    _OVERLAPMINIMUMDURATIONUNIT,
    _OVERLAPMINIMUMTRANSFERQTYUNIT,
    _PERFORMANCEEFFICIENCYRATIO1,
    _PERFORMANCEEFFICIENCYRATIO2,
    _PERFORMANCEEFFICIENCYRATIO3,
    _PERFORMANCEEFFICIENCYRATIO4,
    _PERFORMANCEEFFICIENCYRATIO5,
    _PERFORMANCEEFFICIENCYRATIO6,
    _PLANT,
    _PURCHASECONTRACT,
    _PURCHASECONTRACTITEM,
    _PURCHASINGGROUP,
    _PURCHASINGINFORECORD,
    _PURCHASINGORGANIZATION,
    _STANDARDMOVEDURATIONUNIT,
    _STANDARDQUEUEDURATIONUNIT,
    _STANDARDWORKQUANTITYUNIT1,
    _STANDARDWORKQUANTITYUNIT2,
    _STANDARDWORKQUANTITYUNIT3,
    _STANDARDWORKQUANTITYUNIT4,
    _STANDARDWORKQUANTITYUNIT5,
    _STANDARDWORKQUANTITYUNIT6,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    BILLOFOPERATIONSBREAKDURATION,
    BILLOFOPERATIONSDESC,
    BILLOFOPERATIONSREFGROUP,
    BILLOFOPERATIONSREFTYPE,
    BILLOFOPERATIONSREFVARIANT,
    BOOOPERATIONISPHASE,
    BOOPHASESUPERIOROPINTERNALID,
    BREAKDURATIONUNIT,
    BUSINESSPROCESS,
    CAPACITYCATEGORYCODE,
    CHANGENUMBER,
    CONTROLRECIPEDESTINATION,
    COSTCTRACTIVITYTYPE1,
    COSTCTRACTIVITYTYPE2,
    COSTCTRACTIVITYTYPE3,
    COSTCTRACTIVITYTYPE4,
    COSTCTRACTIVITYTYPE5,
    COSTCTRACTIVITYTYPE6,
    COSTELEMENT,
    CREATIONDATE,
    FACTORYCALENDAR,
    INSPECTIONLOTTYPE,
    INSPRESULTRECORDINGVIEW,
    INSPSBSTCOMPLETIONCONFIRMATION,
    INSPSBSTHASNOTIMEORQUANTITY,
    ISDELETED,
    ISIMPLICITLYDELETED,
    LEADTIMEREDUCTIONSTRATEGY,
    LINESEGMENTTAKT,
    LONGTEXTLANGUAGECODE,
    MATERIALGROUP,
    MAXIMUMNUMBEROFSPLITS,
    MAXIMUMWAITDURATION,
    MAXIMUMWAITDURATIONUNIT,
    MINIMUMMOVEDURATION,
    MINIMUMMOVEDURATIONUNIT,
    MINIMUMQUEUEDURATION,
    MINIMUMQUEUEDURATIONUNIT,
    MINIMUMWAITDURATION,
    MINIMUMWAITDURATIONUNIT,
    MINPROCESSINGDURATIONPERSPLIT,
    MINPROCESSINGDURNPERSPLITUNIT,
    NUMBEROFEMPLOYEES,
    NUMBEROFOPERATIONPRICEUNITS,
    OPERATIONCONTROLPROFILE,
    OPERATIONCOSTINGRELEVANCYTYPE,
    OPERATIONEXTERNALID,
    OPERATIONOVERLAPPINGISPOSSIBLE,
    OPERATIONOVERLAPPINGISREQUIRED,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONSCRAPPERCENT,
    OPERATIONSETUPGROUP,
    OPERATIONSETUPGROUPCATEGORY,
    OPERATIONSISALWAYSOVERLAPPING,
    OPERATIONSPLITISREQUIRED,
    OPERATIONSTANDARDTEXTCODE,
    OPERATIONSTDWORKQTYGRPGCAT,
    OPERATIONTEXT,
    OPERATIONUNIT,
    OPEXTERNALPROCESSINGCURRENCY,
    OPEXTERNALPROCESSINGPRICE,
    OPISEXTLYPROCDWITHSUBCONTRG,
    OPQTYTOBASEQTYDNMNTR,
    OPQTYTOBASEQTYNMRTR,
    ORDERHASNOSUBOPERATIONS,
    ORDERINTBILLOFOPITEMOFPHASE,
    OVERLAPMINIMUMDURATION,
    OVERLAPMINIMUMDURATIONUNIT,
    OVERLAPMINIMUMTRANSFERQTY,
    OVERLAPMINIMUMTRANSFERQTYUNIT,
    PERFEFFICIENCYRATIOCODE1,
    PERFEFFICIENCYRATIOCODE2,
    PERFEFFICIENCYRATIOCODE3,
    PERFEFFICIENCYRATIOCODE4,
    PERFEFFICIENCYRATIOCODE5,
    PERFEFFICIENCYRATIOCODE6,
    PLANNEDDELIVERYDURATION,
    PLANT,
    PRODUCTIONSUPERVISOR,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASINGGROUP,
    PURCHASINGINFORECDADDLGRPGNAME,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    STANDARDMOVEDURATION,
    STANDARDMOVEDURATIONUNIT,
    STANDARDQUEUEDURATION,
    STANDARDQUEUEDURATIONUNIT,
    STANDARDWORKQUANTITY1,
    STANDARDWORKQUANTITY2,
    STANDARDWORKQUANTITY3,
    STANDARDWORKQUANTITY4,
    STANDARDWORKQUANTITY5,
    STANDARDWORKQUANTITY6,
    STANDARDWORKQUANTITYUNIT1,
    STANDARDWORKQUANTITYUNIT2,
    STANDARDWORKQUANTITYUNIT3,
    STANDARDWORKQUANTITYUNIT4,
    STANDARDWORKQUANTITYUNIT5,
    STANDARDWORKQUANTITYUNIT6,
    SUPPLIER,
    TEARDOWNANDWAITISPARALLEL,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BOOOPERATIONINTERNALID, BOOOPINTERNALVERSIONCOUNTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);