P_PROCGEXECOPERATIONACTIVITY

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.

-- Operation Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PROCGEXECOPERATIONACTIVITY (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _MFGORDER,
    _MFGORDERDOCINFORECDOBJLINK,
    _MFGORDEROPDOCINFORECDOBJLINK,
    _OPACTYDOCINFORECDOBJLINK,
    _OPACTYMAINWRKCTRMFGUSER,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINTERNALID,
    _OPERATIONACTIVITYNETWORK,
    _OPERATIONACTIVITYTEXT,
    _ORDERINTERNALID,
    _PRODUCTIONPLANT,
    _SASSCHEMA,
    _SASSTATUS,
    _WORKCENTER,
    _WORKCENTERBYSEMANTICKEY,
    _WORKCENTERTYPE,
    DATEISACTUALDATE,
    LABORTRACKINGISREQUIRED,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERIMPORTANCE,
    MANUFACTURINGORDERTEXT,
    MFGORDEROPERATIONORSUBOP,
    MFGORDEROPERATIONTEXT,
    OANELEMENTDISPLAYSQNCNUMBER,
    OPACTYCONFISSFIBASED,
    OPACTYEXPDEXECDURNINSECONDS,
    OPACTYEXPDEXECLABORDURNINSECS,
    OPACTYNTWKELEMENTELEMENT,
    OPACTYNTWKELEMENTELMNTVERSCNTR,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKSEGMENTTYPE,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITY,
    OPERATIONACTIVITYNETWORK,
    OPERATIONACTYVERSIONCOUNTER,
    OPERATIONUNIT,
    OPLTSTSCHEDLDEXECSTRTDTE,
    OPLTSTSCHEDLDEXECSTRTDTETME,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDTOTALQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODUCTIONPLANT,
    PRODUCTIONPLANTNAME,
    PRODUCTIONUNIT,
    SASSTATUSCATEGORY,
    SASSTATUSCRITICALITY,
    STATUSANDACTIONSCHEMA,
    STATUSANDACTIONSCHEMASTATUS,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTEXT,
    WORKCENTERTYPECODE,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);