I_MFGORDEROPERATION

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.

-- Manufacturing Order Operation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATION (
    MANUFACTURINGORDER,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    PRODUCEOPACTYNTWKINSTANCE,
    _FACTORYCALENDAR,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERSEQUENCE,
    _MFGORDERTYPE,
    _MRPCONTROLLER,
    _OPERATIONCONFIRMATION,
    _OPERATIONCONTROLPROFILE,
    _ORDINTERNALBILLOFOPERATIONS,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _WORKCENTER_2,
    _WORKCENTERTYPE_2,
    ACTUALFORECASTDURATION,
    ACTUALFORECASTDURATIONUNIT,
    ACTUALFORECASTENDDATE,
    ACTUALFORECASTENDTIME,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOMITEMNODECOUNT,
    BOOOPERATIONINTERNALID,
    BREAKDURATIONUNIT,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSPROCESSCONFIRMEDQTY,
    BUSINESSPROCESSENTRYUNIT,
    BUSINESSPROCESSREMAININGQTY,
    BUSINESSPROCREMAININGQTYUNIT,
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    CHANGENUMBER,
    COMPANYCODE,
    CONFIRMEDBREAKDURATION,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLRECIPEDESTINATION,
    COSTCTRACTIVITYTYPE1,
    COSTCTRACTIVITYTYPE2,
    COSTCTRACTIVITYTYPE3,
    COSTCTRACTIVITYTYPE4,
    COSTCTRACTIVITYTYPE5,
    COSTCTRACTIVITYTYPE6,
    COSTELEMENT,
    COSTESTIMATE,
    COSTINGSHEET,
    COSTINGVARIANT,
    EARLIESTSCHEDULEDWAITENDDATE,
    EARLIESTSCHEDULEDWAITENDTIME,
    EARLIESTSCHEDULEDWAITSTARTDATE,
    EARLIESTSCHEDULEDWAITSTARTTIME,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    ENDDATEOFFSETREFERENCECODE,
    EXTPROCGOPERATIONHASSUBCONTRG,
    FACTORYCALENDAR,
    FORECASTPROCESSINGDURATION,
    FORECASTPROCESSINGDURATIONUNIT,
    FORECASTWORKQUANTITY1,
    FORECASTWORKQUANTITY2,
    FORECASTWORKQUANTITY3,
    FORECASTWORKQUANTITY4,
    FORECASTWORKQUANTITY5,
    FORECASTWORKQUANTITY6,
    FREEDEFINEDAMOUNT1,
    FREEDEFINEDAMOUNT2,
    FREEDEFINEDATTRIBUTE01,
    FREEDEFINEDATTRIBUTE02,
    FREEDEFINEDATTRIBUTE03,
    FREEDEFINEDATTRIBUTE04,
    FREEDEFINEDDATE1,
    FREEDEFINEDDATE2,
    FREEDEFINEDINDICATOR1,
    FREEDEFINEDINDICATOR2,
    FREEDEFINEDQUANTITY1,
    FREEDEFINEDQUANTITY2,
    FREEDEFINEDTABLEFIELDSEMANTIC,
    FUNCTIONALAREA,
    GOODSRECIPIENTNAME,
    INSPECTIONLOT,
    LANGUAGE,
    LATESTSCHEDLDFCSTDENDDATE,
    LATESTSCHEDLDFCSTDSTARTDATE,
    LATESTSCHEDULEDWAITENDDATE,
    LATESTSCHEDULEDWAITENDTIME,
    LATESTSCHEDULEDWAITSTARTDATE,
    LATESTSCHEDULEDWAITSTARTTIME,
    LEADTIMEREDUCTIONSTRATEGY,
    MANUFACTURINGOBJECT,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERIMPORTANCE,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERSUBOPERATION,
    MANUFACTURINGORDERTYPE,
    MAXIMUMNUMBEROFSPLITS,
    MAXIMUMWAITDURATION,
    MAXIMUMWAITDURATIONUNIT,
    MFGORDEROPERATIONISPHASE,
    MFGORDEROPERATIONORSUBOP,
    MFGORDEROPERATIONTEXT,
    MFGORDERPHASESUPERIOROPERATION,
    MINIMUMDURATION,
    MINIMUMDURATIONUNIT,
    MINIMUMMOVEDURATION,
    MINIMUMMOVEDURATIONUNIT,
    MINIMUMPROCESSINGDURATION,
    MINIMUMPROCESSINGDURATIONUNIT,
    MINIMUMQUEUEDURATION,
    MINIMUMQUEUEDURATIONUNIT,
    MINIMUMWAITDURATION,
    MINIMUMWAITDURATIONUNIT,
    MRPCONTROLLER,
    NOFURTHERBUSINESSPROCQTYISEXPD,
    NOFURTHEROPWORKQUANTITY1ISEXPD,
    NOFURTHEROPWORKQUANTITY2ISEXPD,
    NOFURTHEROPWORKQUANTITY3ISEXPD,
    NOFURTHEROPWORKQUANTITY4ISEXPD,
    NOFURTHEROPWORKQUANTITY5ISEXPD,
    NOFURTHEROPWORKQUANTITY6ISEXPD,
    NUMBEROFCAPACITIES,
    NUMBEROFCONFIRMATIONSLIPS,
    NUMBEROFEMPLOYEES,
    NUMBEROFOPERATIONCONFIRMATIONS,
    NUMBEROFOPERATIONPRICEUNITS,
    NUMBEROFTIMETICKETS,
    OPACTUALEXECUTIONENDDATE,
    OPACTUALEXECUTIONENDTIME,
    OPACTUALEXECUTIONSTARTDATE,
    OPACTUALEXECUTIONSTARTTIME,
    OPACTUALPROCESSINGENDDATE,
    OPACTUALPROCESSINGENDTIME,
    OPACTUALPROCESSINGSTARTDATE,
    OPACTUALPROCESSINGSTARTTIME,
    OPACTUALSETUPENDDATE,
    OPACTUALSETUPENDTIME,
    OPACTUALTEARDOWNSTARTDATE,
    OPACTUALTEARDOWNSTARTTME,
    OPCONFIRMEDWORKQUANTITY1,
    OPCONFIRMEDWORKQUANTITY2,
    OPCONFIRMEDWORKQUANTITY3,
    OPCONFIRMEDWORKQUANTITY4,
    OPCONFIRMEDWORKQUANTITY5,
    OPCONFIRMEDWORKQUANTITY6,
    OPERATIONCONFIRMATION,
    OPERATIONCONFIRMEDENDDATE,
    OPERATIONCONFIRMEDREWORKQTY,
    OPERATIONCONFIRMEDSTARTDATE,
    OPERATIONCONTROLPROFILE,
    OPERATIONHASLONGTEXT,
    OPERATIONIMPORTANCE,
    OPERATIONISTOBEDELETED,
    OPERATIONOVERLAPPINGISPOSSIBLE,
    OPERATIONOVERLAPPINGISREQUIRED,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONSCRAPPERCENT,
    OPERATIONSETUPGROUP,
    OPERATIONSETUPGROUPCATEGORY,
    OPERATIONSETUPTYPE,
    OPERATIONSISALWAYSOVERLAPPING,
    OPERATIONSPLITISREQUIRED,
    OPERATIONSTANDARDDURATION,
    OPERATIONSTANDARDDURATIONUNIT,
    OPERATIONSTANDARDTEXTCODE,
    OPERATIONUNIT,
    OPERLSTSCHEDLDEXECENDDTE,
    OPERLSTSCHEDLDEXECENDTME,
    OPERLSTSCHEDLDEXECSTRTDTE,
    OPERLSTSCHEDLDEXECSTRTTME,
    OPERLSTSCHEDLDPROCGSTRTDTE,
    OPERLSTSCHEDLDPROCGSTRTTME,
    OPERLSTSCHEDLDTRDWNSTRTDTE,
    OPERLSTSCHEDLDTRDWNSTRTTME,
    OPEXTERNALPROCESSINGCURRENCY,
    OPEXTERNALPROCESSINGPRICE,
    OPEXTERNALPROCESSINGPRICEUNIT,
    OPLTSTSCHEDLDEXECENDDTE,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTDTE,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    OPPLANNEDPROCESSINGDURN,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDSETUPDURN,
    OPPLANNEDSETUPDURNUNIT,
    OPPLANNEDTEARDOWNDURN,
    OPPLANNEDTEARDOWNDURNUNIT,
    OPPLANNEDTOTALQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    OPQTYTOBASEQTYDNMNTR,
    OPQTYTOBASEQTYNMRTR,
    OPSCHEDLDREDUCTIONLEVEL,
    OPTOTALCONFIRMEDSCRAPQTY,
    OPTOTALCONFIRMEDYIELDQTY,
    OPTOTCONFDYIELDQTYINORDQTYUNIT,
    OPWORKQUANTITYUNIT1,
    OPWORKQUANTITYUNIT2,
    OPWORKQUANTITYUNIT3,
    OPWORKQUANTITYUNIT4,
    OPWORKQUANTITYUNIT5,
    OPWORKQUANTITYUNIT6,
    OVERLAPMINIMUMDURATION,
    PERSONNEL,
    PLANNEDBREAKDURATION,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PROFITCENTER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    PURGINFORECDDATAISFIXED,
    REQUESTINGCOSTCENTER,
    RESPONSIBLEPLANNERGROUP,
    SCHEDLDFCSTDEARLIESTENDDATE,
    SCHEDLDFCSTDEARLIESTENDTIME,
    SCHEDLDFCSTDEARLIESTSTARTDATE,
    SCHEDLDFCSTDEARLIESTSTARTTIME,
    SCHEDLDFCSTDLATESTENDTIME,
    SCHEDLDFCSTDLATESTSTARTTIME,
    SCHEDULEDMOVEDURATION,
    SCHEDULEDMOVEDURATIONUNIT,
    SCHEDULEDQUEUEDURATION,
    SCHEDULEDQUEUEDURATIONUNIT,
    SCHEDULEDWAITDURATION,
    SCHEDULEDWAITDURATIONUNIT,
    SETUPOPACTYNTWKINSTANCE,
    STANDARDMOVEDURATION,
    STANDARDMOVEDURATIONUNIT,
    STANDARDQUEUEDURATION,
    STANDARDQUEUEDURATIONUNIT,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    STARTDATEOFFSETREFERENCECODE,
    SUPERIOROPERATIONINTERNALID,
    SUPPLIER,
    TAXJURISDICTION,
    TEARDOWNOPACTYNTWKINSTANCE,
    UNLOADINGPOINTNAME,
    WORKCENTERINTERNALID,
    WORKCENTERSTANDARDWORKQTY1,
    WORKCENTERSTANDARDWORKQTY2,
    WORKCENTERSTANDARDWORKQTY3,
    WORKCENTERSTANDARDWORKQTY4,
    WORKCENTERSTANDARDWORKQTY5,
    WORKCENTERSTANDARDWORKQTY6,
    WORKCENTERSTANDARDWORKQTYUNIT1,
    WORKCENTERSTANDARDWORKQTYUNIT2,
    WORKCENTERSTANDARDWORKQTYUNIT3,
    WORKCENTERSTANDARDWORKQTYUNIT4,
    WORKCENTERSTANDARDWORKQTYUNIT5,
    WORKCENTERSTANDARDWORKQTYUNIT6,
    WORKCENTERTYPECODE,
    WORKCENTERTYPECODE_2,
    PRIMARY KEY (MANUFACTURINGORDER, ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS, PRODUCEOPACTYNTWKINSTANCE)
);