P_MFGOPACTYASSGDTOOPTRTEAM

CDS View

P_MFGOPACTYASSGDTOOPTRTEAM is a CDS View in S/4HANA. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MfgOpActyAssgdToOptr view from COMPOSITE Activities assigned to Operator
P_NrOfUsrOpActyAssgmtWthDte view from COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY UserID UserID 2
MfgOpActyExecutionPriority MfgOpActyExecutionPriority 1
MfgOpActyIsAssgdDirectlyToOptr MfgOpActyIsAssgdDirectlyToOptr 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MFGOPACTYASSGDTOOPTRTEAM (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    USERID,
    MFGOPACTYEXECUTIONPRIORITY,
    MFGOPACTYISASSGDDIRECTLYTOOPTR,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, USERID)
);