P_OPERATIONACTIVITYWORKLIST

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPERATIONACTIVITYWORKLIST (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _MFGORDER,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINTERNALID,
    _OPACTYUSERASSGMT,
    _OPERATIONACTIVITYNETWORK,
    _OPERATIONACTIVITYTEXT,
    _PRODUCTIONPLANT,
    _SASSCHEMA,
    _SASSTATUS,
    _UNITOFMEASURE,
    _USER,
    _WORKCENTERBYSEMANTICKEY,
    _WORKCENTERTYPE,
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION,
    MFGOPACTYEXECUTIONPRIORITY,
    MFGORDEROPERATIONTEXT,
    NROFOPACTYTEAMASSIGNMENTS,
    NROFOPACTYUSERASSIGNMENTS,
    OPACTUALEXECUTIONENDDATETIME,
    OPACTUALEXECUTIONSTARTDATETIME,
    OPACTYCONFISSFIBASED,
    OPACTYEXPDEXECDURNINSECONDS,
    OPACTYEXPDEXECLABORDURNINSECS,
    OPACTYISSELDFORRTACTVPOSTG,
    OPACTYNTWKELEMENTELEMENT,
    OPACTYNTWKELEMENTELMNTVERSCNTR,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKSEGMENTTYPE,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITY,
    OPERATIONACTIVITYNETWORK,
    OPERATIONACTYVERSIONCOUNTER,
    OPLTSTSCHEDLDEXECENDDTETME,
    OPLTSTSCHEDLDEXECSTRTDTETME,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODUCTIONPLANT,
    PRODUCTIONUNIT,
    RESPYMGMTTEAMID,
    SASSTATUSCATEGORY,
    STATUSANDACTIONSCHEMA,
    STATUSANDACTIONSCHEMASTATUS,
    USERID,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);