I_MFGOPACTYASSGDTOOPTR

CDS View

Activities assigned to Operator

I_MFGOPACTYASSGDTOOPTR is a CDS View in S/4HANA. Activities assigned to Operator. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MfgOpActyAssgdToOptr view from CONSUMPTION Activities assigned to operator

Fields (11)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY UserID UserID 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
MfgOpActyExecutionPriority MfgOpActyExecutionPriority 1
MfgOpActyIsAssgdDirectlyToOptr MfgOpActyIsAssgdDirectlyToOptr 1
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds 1
OpActyExpdExecLaborDurnInSecs OpActyExpdExecLaborDurnInSecs 1
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 1

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.

-- Activities assigned to Operator
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGOPACTYASSGDTOOPTR (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    USERID,
    _OPACTYNTWKINSTANCE,
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION,
    MFGOPACTYEXECUTIONPRIORITY,
    MFGOPACTYISASSGDDIRECTLYTOOPTR,
    OPACTYEXPDEXECDURNINSECONDS,
    OPACTYEXPDEXECLABORDURNINSECS,
    OPACTYNTWKELEMENTEXTERNALID,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, USERID)
);