I_OPACTYUSERASSGMTBASIC

CDS View
11 Fields 8 CDS Views

User to Operation Acty Instance Assgmt

I_OPACTYUSERASSGMTBASIC is a CDS View in S/4HANA. User to Operation Acty Instance Assgmt. It contains 11 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_OpActyUserAssgmt view from CONSUMPTION User to Operation Activity Assignment
I_OpActyUserAssgmt view from COMPOSITE User to Operation Acty Instance Assgmt
I_OpActyWorklistOfCurrentUser view from COMPOSITE Operation Acty Worklist of Current User
P_MfgOpActyAssgdToOptrTeam view from COMPOSITE Activities assigned to Operators & Teams
P_NrOfOpActyUserAssgmnts view from COMPOSITE Number of User to Operation Activity Instance Assignments
P_NrOfOtherOpActyUserAssgmnts view from COMPOSITE No of User to Op Acty Instance Assgmnts without Session User
P_NrOfUsrOpnOpActyAssgmnts view from COMPOSITE Number of open Operation Activities assigned to an User
P_OpActyInstanceWithUserAssgmt view left_outer TRANSACTIONAL List of assigned and unassigned operation activities

Fields (11)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 3
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY UserID UserID 4
_OpActyNtwkInstance _OpActyNtwkInstance 2
_OperationActivityInstance _OperationActivityInstance 2
_User _User 2
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
MfgOpActyExecutionPriority MfgOpActyExecutionPriority 3

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.

-- User to Operation Acty Instance Assgmt
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYUSERASSGMTBASIC (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    USERID,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _USER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MFGOPACTYEXECUTIONPRIORITY,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, USERID)
);

Learn More