I_ORDEROPERATIONDATETIME

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.

-- Order Operation Date and Time as Timestamp
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDEROPERATIONDATETIME (
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    _WORKCENTER,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOMITEMNODECOUNT,
    BOOOPERATIONINTERNALID,
    BUSINESSAREA,
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    CHANGENUMBER,
    COMPANYCODE,
    CONTROLLINGOBJECTCLASS,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    ENDDATEOFFSETREFERENCECODE,
    FACTORYCALENDAR,
    FUNCTIONALAREA,
    LANGUAGE,
    NUMBEROFCONFIRMATIONSLIPS,
    NUMBEROFEMPLOYEES,
    NUMBEROFOPERATIONCONFIRMATIONS,
    NUMBEROFTIMETICKETS,
    OBJECTINTERNALID,
    OPACTUALEXECUTIONENDDATE,
    OPACTUALEXECUTIONENDDATETIME,
    OPACTUALEXECUTIONENDTIME,
    OPACTUALEXECUTIONSTARTDATE,
    OPACTUALEXECUTIONSTARTDATETIME,
    OPACTUALEXECUTIONSTARTTIME,
    OPACTUALPROCESSINGENDDATE,
    OPACTUALPROCESSINGENDDATETIME,
    OPACTUALPROCESSINGENDTIME,
    OPACTUALPROCESSINGSTARTDATE,
    OPACTUALPROCESSINGSTARTDTETME,
    OPACTUALPROCESSINGSTARTTIME,
    OPACTUALSETUPENDDATE,
    OPACTUALSETUPENDDATETIME,
    OPACTUALSETUPENDTIME,
    OPACTUALTEARDOWNSTARTDATE,
    OPACTUALTEARDOWNSTARTDATETIME,
    OPACTUALTEARDOWNSTARTTME,
    OPERATION,
    OPERATIONCONFIRMATION,
    OPERATIONCONFIRMEDENDDATE,
    OPERATIONCONFIRMEDREWORKQTY,
    OPERATIONCONFIRMEDSTARTDATE,
    OPERATIONCONTROLPROFILE,
    OPERATIONIMPORTANCE,
    OPERATIONISTOBEDELETED,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONSCRAPPERCENT,
    OPERATIONTEXT,
    OPERATIONUNIT,
    OPERLSTSCHEDLDEXECENDDTE,
    OPERLSTSCHEDLDEXECENDDTETME,
    OPERLSTSCHEDLDEXECENDTME,
    OPERLSTSCHEDLDEXECSTRTDTE,
    OPERLSTSCHEDLDEXECSTRTDTETME,
    OPERLSTSCHEDLDEXECSTRTTME,
    OPERLSTSCHEDLDPROCGSTRTDTE,
    OPERLSTSCHEDLDPROCGSTRTDTETME,
    OPERLSTSCHEDLDPROCGSTRTTME,
    OPERLSTSCHEDLDTRDWNSTRTDTE,
    OPERLSTSCHEDLDTRDWNSTRTDTETME,
    OPERLSTSCHEDLDTRDWNSTRTTME,
    OPLTSTSCHEDLDEXECENDDTE,
    OPLTSTSCHEDLDEXECENDDTETME,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTDTE,
    OPLTSTSCHEDLDEXECSTRTDTETME,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTDTETME,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTDTETME,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDTOTALQUANTITY,
    OPTOTALCONFIRMEDSCRAPQTY,
    OPTOTALCONFIRMEDYIELDQTY,
    PERSONNEL,
    PLANT,
    PLANTNAME,
    PLANTTIMEZONE,
    PRODUCEOPACTYNTWKINSTANCE,
    PROFITCENTER,
    SEQUENCE,
    SETUPOPACTYNTWKINSTANCE,
    STANDARDTEXTINTERNALID,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    STARTDATEOFFSETREFERENCECODE,
    TEARDOWNOPACTYNTWKINSTANCE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (ORDERINTERNALID, ORDEROPERATIONINTERNALID)
);