P_MFGORDEROPERATIONDELAY

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 Delay
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGORDEROPERATIONDELAY (
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSSEQUENCE,
    _BILLOFOPERATIONSTYPE,
    _BILLOFOPERATIONSVARIANT,
    _BOOOPERATIONINTERNALID,
    _BUSINESSAREA,
    _BUSINESSPROCESS,
    _BUSINESSPROCESSENTRYUNIT,
    _CAPACITYREQUIREMENT,
    _CAPACITYREQUIREMENTITEM,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _CONTROLLINGOBJECTCLASS,
    _EMPLOYEESUITABILITY,
    _EMPLOYEEWAGEGROUP,
    _ENDDATEOFFSETREFERENCECODE,
    _FUNCTIONALAREA,
    _LANGUAGE,
    _LEADTIMEREDUCTIONSTRATEGY,
    _LONGTEXT,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERSEQUENCE,
    _MFGORDERTYPE,
    _MRPCONTROLLER,
    _OPERATIONCONFIRMATION,
    _OPERATIONCONTROLPROFILE,
    _OPERATIONSETUPGROUP,
    _OPERATIONSETUPGROUPCATEGORY,
    _OPERATIONSETUPTYPE,
    _OPERATIONSTANDARDTEXTCODE,
    _OPERATIONUNIT,
    _OPEXTERNALPROCESSINGCURRENCY,
    _ORDINTERNALBILLOFOPERATIONS,
    _PRODUCEOPACTYNTWKINSTANCE,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTIONUNIT,
    _PROFITCENTER,
    _PURCHASEORDER,
    _PURCHASEORDERITEM,
    _PURCHASINGGROUP,
    _PURCHASINGINFORECORD,
    _PURCHASINGORGANIZATION,
    _RESPONSIBLEPLANNERGROUP,
    _SETUPOPACTYNTWKINSTANCE,
    _STARTDATEOFFSETREFERENCECODE,
    _TEARDOWNOPACTYNTWKINSTANCE,
    _WORKCENTER,
    _WORKCENTER_2,
    _WORKCENTERTYPE,
    _WORKCENTERTYPE_2,
    ACTUALFORECASTDURATION,
    ACTUALFORECASTDURATIONUNIT,
    ACTUALFORECASTENDDATE,
    ACTUALFORECASTENDTIME,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOOOPERATIONINTERNALID,
    BREAKDURATIONUNIT,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSPROCESSCONFIRMEDQTY,
    BUSINESSPROCESSENTRYUNIT,
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    COMPANYCODE,
    CONFIRMEDBREAKDURATION,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    COSTCTRACTIVITYTYPE1,
    COSTCTRACTIVITYTYPE2,
    COSTCTRACTIVITYTYPE3,
    COSTCTRACTIVITYTYPE4,
    COSTCTRACTIVITYTYPE5,
    COSTCTRACTIVITYTYPE6,
    COSTELEMENT,
    COSTESTIMATE,
    COSTINGSHEET,
    COSTINGVARIANT,
    EARLIESTSCHEDULEDWAITENDDATE,
    EARLIESTSCHEDULEDWAITENDTIME,
    EARLIESTSCHEDULEDWAITSTARTDATE,
    EARLIESTSCHEDULEDWAITSTARTTIME,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    ENDDATEOFFSETREFERENCECODE,
    FORECASTPROCESSINGDURATION,
    FORECASTPROCESSINGDURATIONUNIT,
    FORECASTWORKQUANTITY1,
    FORECASTWORKQUANTITY2,
    FORECASTWORKQUANTITY3,
    FORECASTWORKQUANTITY4,
    FORECASTWORKQUANTITY5,
    FORECASTWORKQUANTITY6,
    FUNCTIONALAREA,
    GOODSRECIPIENTNAME,
    LANGUAGE,
    LATESTSCHEDLDFCSTDENDDATE,
    LATESTSCHEDLDFCSTDSTARTDATE,
    LATESTSCHEDULEDWAITENDDATE,
    LATESTSCHEDULEDWAITENDTIME,
    LATESTSCHEDULEDWAITSTARTDATE,
    LATESTSCHEDULEDWAITSTARTTIME,
    LEADTIMEREDUCTIONSTRATEGY,
    MANUFACTURINGOBJECT,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERSUBOPERATION,
    MANUFACTURINGORDERTYPE,
    MAXIMUMNUMBEROFSPLITS,
    MAXIMUMWAITDURATION,
    MAXIMUMWAITDURATIONUNIT,
    MFGORDEROPERATIONISPHASE,
    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,
    OPERATIONOVERLAPPINGISPOSSIBLE,
    OPERATIONOVERLAPPINGISREQUIRED,
    OPERATIONREFERENCEQUANTITY,
    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,
    OPPLANNEDPROCESSINGDURNUNIT,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDSETUPDURN,
    OPPLANNEDSETUPDURNUNIT,
    OPPLANNEDTEARDOWNDURN,
    OPPLANNEDTEARDOWNDURNUNIT,
    OPPLANNEDTOTALQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    OPSCHEDLDREDUCTIONLEVEL,
    OPTOTALCONFIRMEDSCRAPQTY,
    OPTOTALCONFIRMEDYIELDQTY,
    OPTOTCONFDYIELDQTYINORDQTYUNIT,
    OPWORKQUANTITYUNIT1,
    OPWORKQUANTITYUNIT2,
    OPWORKQUANTITYUNIT3,
    OPWORKQUANTITYUNIT4,
    OPWORKQUANTITYUNIT5,
    OPWORKQUANTITYUNIT6,
    OVERLAPMINIMUMDURATION,
    OVERLAPMINIMUMDURATIONUNIT,
    PLANNEDACTUALENDDATEDVTNDURN,
    PLANNEDACTUALSTARTDATEDVTNDURN,
    PLANNEDBREAKDURATION,
    PLANNEDCURRENTENDDATEDVTNDURN,
    PLANNEDCURRENTSTRTDATEDVTNDURN,
    PLANNEDDELIVERYDURATION,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PROFITCENTER,
    PURCHASINGGROUP,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGORGANIZATION,
    PURGINFORECDDATAISFIXED,
    REQUESTINGCOSTCENTER,
    RESPONSIBLEPLANNERGROUP,
    SCHEDLDFCSTDEARLIESTENDDATE,
    SCHEDLDFCSTDEARLIESTENDTIME,
    SCHEDLDFCSTDEARLIESTSTARTDATE,
    SCHEDLDFCSTDEARLIESTSTARTTIME,
    SCHEDLDFCSTDLATESTENDTIME,
    SCHEDLDFCSTDLATESTSTARTTIME,
    SCHEDULEDMOVEDURATION,
    SCHEDULEDMOVEDURATIONUNIT,
    SCHEDULEDQUEUEDURATION,
    SCHEDULEDQUEUEDURATIONUNIT,
    SCHEDULEDWAITDURATION,
    SCHEDULEDWAITDURATIONUNIT,
    STANDARDMOVEDURATION,
    STANDARDMOVEDURATIONUNIT,
    STANDARDQUEUEDURATION,
    STANDARDQUEUEDURATIONUNIT,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    STARTDATEOFFSETREFERENCECODE,
    SUPERIOROPERATIONINTERNALID,
    SUPPLIER,
    TAXJURISDICTION,
    UNLOADINGPOINTNAME,
    WORKCENTERINTERNALID,
    WORKCENTERSTANDARDWORKQTY1,
    WORKCENTERSTANDARDWORKQTY2,
    WORKCENTERSTANDARDWORKQTY3,
    WORKCENTERSTANDARDWORKQTY4,
    WORKCENTERSTANDARDWORKQTY5,
    WORKCENTERSTANDARDWORKQTY6,
    WORKCENTERSTANDARDWORKQTYUNIT1,
    WORKCENTERSTANDARDWORKQTYUNIT2,
    WORKCENTERSTANDARDWORKQTYUNIT3,
    WORKCENTERSTANDARDWORKQTYUNIT4,
    WORKCENTERSTANDARDWORKQTYUNIT5,
    WORKCENTERSTANDARDWORKQTYUNIT6,
    WORKCENTERTYPECODE,
    WORKCENTERTYPECODE_2,
    PRIMARY KEY (ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS)
);