I_OPACTYRESPYMGMTTEAMASSGMTBSC

CDS View

Team to Operation Acty Instance Assgmt

I_OPACTYRESPYMGMTTEAMASSGMTBSC is a CDS View in S/4HANA. Team to Operation Acty Instance Assgmt. It contains 12 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_MfgOpActyRespyMgmtTeamAssgmt view from CONSUMPTION Teams Assigned to OA
C_TeamOpenOpActyAssignment view from CONSUMPTION Open operation activities assigned to a team
I_OpActyRespyMgmtTeamAssgmt view from COMPOSITE Team to Operation Acty Instance Assgmt
I_OpActyWorklistOfCurrentUser view inner COMPOSITE Operation Acty Worklist of Current User
P_MfgOpActyTeamUserAssgmt view from COMPOSITE
P_NrOfOpActyTeamAssgmnts view from COMPOSITE
P_NrOfTeamOpnOpActyAssgmnts view from COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 4
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY RespyMgmtTeamID RespyMgmtTeamID 3
_MfgRespyMgmtTeam _MfgRespyMgmtTeam 1
_OpActyNtwkInstance _OpActyNtwkInstance 3
_OperationActivityInstance _OperationActivityInstance 3
_RespyMgmtTeamHeaderDetail _RespyMgmtTeamHeaderDetail 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
MfgOpActyExecutionPriority MfgOpActyExecutionPriority 2

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.

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