I_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 I_PROCGEXECOPERATIONACTIVITY (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _BILLOFMATERIAL,
    _MATERIAL,
    _ORDERHEADERPRODUCTIONPLANT,
    _PRODUCTIONPLANT,
    _WORKCENTER,
    _WORKCENTERTYPE,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOOOPERATIONINTERNALID,
    CONFIRMATIONSKIPPEDQUANTITY,
    CONFIRMATIONYIELDQUANTITY,
    LABORTRACKINGISREQUIRED,
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION,
    MFGORDEROPERATIONTEXT,
    MFGQUALIFICATIONISREQUIRED,
    NUMBEROFACTIVESHOPFLOORITEMS,
    OANELEMENTDISPLAYSQNCNUMBER,
    OPACTYCONFISSFIBASED,
    OPACTYEXPDEXECDURNINSECONDS,
    OPACTYEXPDEXECLABORDURNINSECS,
    OPACTYHASASSGDINSPCHARCS,
    OPACTYHASASSGDPRODNRSCETOOLS,
    OPACTYHASASSGDWORKINSTRUCTIONS,
    OPACTYHASASSIGNEDCOMPONENTS,
    OPACTYHASMANDATORYINSPCHARCS,
    OPACTYNTWKGROUPEXTERNALID,
    OPACTYNTWKGROUPVERSIONCOUNTER,
    OPACTYNTWKSEGMENTTYPE,
    OPERATIONACTIVITY,
    OPERATIONACTIVITYNETWORKGROUP,
    OPERATIONACTYVERSIONCOUNTER,
    OPERATIONEXECUTIONAVAILABLEQTY,
    OPERATIONUNIT,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDTOTALQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    ORDERHEADERPRODUCTIONPLANT,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PRODUCTIONUNIT,
    RESERVATION,
    SASSTATUSCATEGORY,
    STATUSANDACTIONSCHEMASTATUS,
    WORKCENTER,
    WORKCENTERTYPECODE,
    WORKINSTRUCTION,
    WORKINSTRUCTIONVERSIONCOUNTER,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);