I_BILLOFOPERATIONSOPBASIC

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.

-- Bill of Operations Operation Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFOPERATIONSOPBASIC (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVERSION,
    BOOOPERATIONINTERNALID,
    BOOOPINTERNALVERSIONCOUNTER,
    OPERATION,
    SUPERIOROPERATIONINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _ASSEMBLY,
    _BILLOFOPERATIONSBREAKDURNUNIT,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _BOOOPERATIONINTERNALID,
    _CAPACITYCATEGORY,
    _CHANGEMASTER,
    _COMPANYCODE,
    _CONTROLRECIPEDESTINATION,
    _ENDDATEOFFSETDURNUNIT,
    _EQUIPMENT,
    _FACTORYCALENDAR,
    _FREEDEFINEDAMOUNT1CURRENCY,
    _FREEDEFINEDAMOUNT2CURRENCY,
    _FREEDFNDTABLEFIELDSEMANTIC,
    _FUNCTIONALLOCATION,
    _INSPECTIONLOTTYPE,
    _INSPRESULTRECORDINGVIEW,
    _LEADTIMEREDUCTIONSTRATEGY,
    _LONGTEXTLANGUAGE,
    _MAINTOPERATIONEXECSTAGECODE,
    _MATERIALGROUP,
    _MAXIMUMWAITDURATIONUNIT,
    _MINIMUMDURATIONUNIT,
    _MINIMUMMOVEDURATIONUNIT,
    _MINIMUMQUEUEDURATIONUNIT,
    _MINIMUMWAITDURATIONUNIT,
    _MINPROCESSINGDURNPERSPLITUNIT,
    _OPERATIONCALCULATIONCONTROL,
    _OPERATIONCONTROLPROFILE,
    _OPERATIONSETUPGROUP,
    _OPERATIONSETUPGROUPCATEGORY,
    _OPERATIONSETUPTYPE,
    _OPERATIONSTANDARDDURATIONUNIT,
    _OPERATIONSTANDARDTEXT,
    _OPERATIONSTDWORKQTYGRPGCAT,
    _OPERATIONSYSTEMCONDITION,
    _OPERATIONUNIT,
    _OPEXTERNALPROCESSINGCURRENCY,
    _OVERLAPMINIMUMDURATIONUNIT,
    _OVERLAPMINIMUMTRANSFERQTYUNIT,
    _PERFORMANCEEFFICIENCYRATIO1,
    _PERFORMANCEEFFICIENCYRATIO2,
    _PERFORMANCEEFFICIENCYRATIO3,
    _PERFORMANCEEFFICIENCYRATIO4,
    _PERFORMANCEEFFICIENCYRATIO5,
    _PERFORMANCEEFFICIENCYRATIO6,
    _PLANT,
    _PURCHASECONTRACT,
    _PURCHASECONTRACTITEM,
    _PURCHASEORDERQTYUNIT,
    _PURCHASINGGROUP,
    _PURCHASINGINFORECORD,
    _PURCHASINGORGANIZATION,
    _STANDARDMOVEDURATIONUNIT,
    _STANDARDQUEUEDURATIONUNIT,
    _STANDARDWORKQUANTITYUNIT1,
    _STANDARDWORKQUANTITYUNIT2,
    _STANDARDWORKQUANTITYUNIT3,
    _STANDARDWORKQUANTITYUNIT4,
    _STANDARDWORKQUANTITYUNIT5,
    _STANDARDWORKQUANTITYUNIT6,
    _STARTDATEOFFSETDURNUNIT,
    _SUPPLIER,
    _WORKCENTER,
    _WORKCENTERTYPE,
    ASSEMBLY,
    BILLOFOPERATIONSBREAKDURATION,
    BILLOFOPERATIONSBREAKDURNUNIT,
    BILLOFOPERATIONSREFGROUP,
    BILLOFOPERATIONSREFVARIANT,
    BOOOPERATIONISPHASE,
    BOOPHASESUPERIOROPINTERNALID,
    BOOREFOPERATIONINCREMENTVALUE,
    BUSINESSPROCESS,
    CAPACITYCATEGORYCODE,
    CAPACITYREQUIREMENTDISTRKEY,
    CAPRQMTSDISTRIBUTIONFUNCTION,
    CHANGENUMBER,
    COMPANYCODE,
    CONTROLRECIPEDESTINATION,
    COSTCTRACTIVITYTYPE,
    COSTCTRACTIVITYTYPE1,
    COSTCTRACTIVITYTYPE2,
    COSTCTRACTIVITYTYPE3,
    COSTCTRACTIVITYTYPE4,
    COSTCTRACTIVITYTYPE5,
    COSTCTRACTIVITYTYPE6,
    COSTELEMENT,
    CREATEDBYUSER,
    CREATIONDATE,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    EQUIPMENT,
    FACTORYCALENDAR,
    FREEDEFINEDTABLEFIELDSEMANTIC,
    FUNCTIONALLOCATION,
    INSPECTIONLOTTYPE,
    INSPSBSTHASNOTIMEORQUANTITY,
    ISDELETED,
    ISIMPLICITLYDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LEADTIMEREDUCTIONSTRATEGY,
    LONGTEXTLANGUAGECODE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEJOBVERIFICATION,
    MAINTOPERATIONALCHECKLISTTYPE,
    MAINTOPERATIONEXECSTAGECODE,
    MATERIALGROUP,
    MAXIMUMNUMBEROFSPLITS,
    MAXIMUMWAITDURATION,
    MAXIMUMWAITDURATIONUNIT,
    MINIMUMDURATION,
    MINIMUMDURATIONUNIT,
    MINIMUMMOVEDURATION,
    MINIMUMMOVEDURATIONUNIT,
    MINIMUMQUEUEDURATION,
    MINIMUMQUEUEDURATIONUNIT,
    MINIMUMWAITDURATION,
    MINIMUMWAITDURATIONUNIT,
    MINPROCESSINGDURATIONPERSPLIT,
    MINPROCESSINGDURNPERSPLITUNIT,
    NUMBEROFCAPACITIES,
    NUMBEROFCONFIRMATIONSLIPS,
    NUMBEROFEMPLOYEES,
    NUMBEROFOPERATIONPRICEUNITS,
    NUMBEROFTIMETICKETS,
    OPERATION_2,
    OPERATIONCALCULATIONCONTROL,
    OPERATIONCONTROLPROFILE,
    OPERATIONCOSTINGRELEVANCYTYPE,
    OPERATIONEXTERNALID,
    OPERATIONOVERLAPPINGISPOSSIBLE,
    OPERATIONOVERLAPPINGISREQUIRED,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONSCRAPPERCENT,
    OPERATIONSETUPGROUP,
    OPERATIONSETUPGROUPCATEGORY,
    OPERATIONSETUPTYPE,
    OPERATIONSISALWAYSOVERLAPPING,
    OPERATIONSPLITISREQUIRED,
    OPERATIONSTANDARDDURATION,
    OPERATIONSTANDARDDURATIONUNIT,
    OPERATIONSTANDARDTEXTCODE,
    OPERATIONSYSTEMCONDITION,
    OPERATIONTEXT,
    OPERATIONUNIT,
    OPERATIONWORKPERCENT,
    OPEXTERNALPROCESSINGCURRENCY,
    OPEXTERNALPROCESSINGPRICE,
    OPPLANNEDWORKQUANTITY,
    OPQTYTOBASEQTYDNMNTR,
    OPQTYTOBASEQTYNMRTR,
    OPWORKQUANTITYUNIT,
    ORDERHASNOSUBOPERATIONS,
    OVERLAPMINIMUMDURATION,
    OVERLAPMINIMUMDURATIONUNIT,
    OVERLAPMINIMUMTRANSFERQTY,
    OVERLAPMINIMUMTRANSFERQTYUNIT,
    PERFEFFICIENCYRATIOCODE1,
    PERFEFFICIENCYRATIOCODE2,
    PERFEFFICIENCYRATIOCODE3,
    PERFEFFICIENCYRATIOCODE4,
    PERFEFFICIENCYRATIOCODE5,
    PERFEFFICIENCYRATIOCODE6,
    PLANNEDDELIVERYDURATION,
    PLANT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERQTY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGGROUP,
    PURCHASINGINFORECDADDLGRPGNAME,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    STANDARDMOVEDURATION,
    STANDARDMOVEDURATIONUNIT,
    STANDARDQUEUEDURATION,
    STANDARDQUEUEDURATIONUNIT,
    STANDARDWORKQUANTITY1,
    STANDARDWORKQUANTITY2,
    STANDARDWORKQUANTITY3,
    STANDARDWORKQUANTITY4,
    STANDARDWORKQUANTITY5,
    STANDARDWORKQUANTITY6,
    STANDARDWORKQUANTITYUNIT1,
    STANDARDWORKQUANTITYUNIT2,
    STANDARDWORKQUANTITYUNIT3,
    STANDARDWORKQUANTITYUNIT4,
    STANDARDWORKQUANTITYUNIT5,
    STANDARDWORKQUANTITYUNIT6,
    STARTDATEOFFSETDURATION,
    SUPPLIER,
    TEARDOWNANDWAITISPARALLEL,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVERSION, BOOOPERATIONINTERNALID, BOOOPINTERNALVERSIONCOUNTER, OPERATION, SUPERIOROPERATIONINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);