I_OPACTYUSERASSGMTBASIC

CDS View

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.

Used by 8 CDS view(s) 11 fields

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 
@AbapCatalog.sqlViewName: 'IMPEUSROAIASSB'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'UserID'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@EndUserText.label: 'User to Operation Acty Instance Assgmt'
define view I_OpActyUserAssgmtBasic
  as select from mpe_oai_ass_usr
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [1..1] to I_User                      as _User                      on  $projection.UserID = _User.UserID
{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key oan_instance_id                                                       as OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key oan_element_number                                                    as OpActyNtwkElement,
  key exec_user                                                             as UserID,
      created_by                                                            as CreatedByUser,
      created_at                                                            as CreationDateTime,
      oa_exec_prio as MfgOpActyExecutionPriority,
      changed_by as LastChangedByUser ,
      changed_at as LastChangeDateTime,

      _OpActyNtwkInstance,
      _OperationActivityInstance,
      _User
}

Learn More