I_LOGACCMOBJSECUREIDASSGMT

CDS View

Object Secure ID Assignment

I_LOGACCMOBJSECUREIDASSGMT is a CDS View in S/4HANA. Object Secure ID Assignment. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_LogAccMObjSecureIDAssgmt view from COMPOSITE API for Object Secure ID Assignment
I_ChgMstrLogAccMSecureIDAssgmt view_entity from BASIC Change Number LogAccM Secure ID Assgmt
I_DocInfoRecordAccMSecIDAsgt view from BASIC Doc Info Record SecureID Assingment
I_ProdStrucLogAccMSecureAssgmt view from COMPOSITE Logistics Access Control Management 
@AbapCatalog.sqlViewName: 'IACMOBJSIDASGMNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Object Secure ID Assignment'

define view I_LogAccMObjSecureIDAssgmt
  as select from /plmb/auth_obsid
  association [0..*] to I_LogAccMUsrSecureIDAssgmt  as _LogAccMUsrSecureIDAssgmt  on $projection.LogAccMSecureID = _LogAccMUsrSecureIDAssgmt.LogAccMActivitySecureID
  association [0..1] to I_LogAccMSecureIDRepository as _LogAccMSecureIDRepository on $projection.LogAccMSecureID = _LogAccMSecureIDRepository.LogAccMSecureID
  association [0..1] to I_User                      as _CreatedByUser             on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                      as _LastChangedByUser         on $projection.LastChangedByUser = _LastChangedByUser.UserID
{
  key sid                                              as LogAccMSecureID,
  key obj_type                                         as LogAccMObjectType,
  key object_id                                        as LogAccMObjectID,
      assgnmt_type                                     as LogAccMObjectAssignmentType,

      @Semantics.user.createdBy: true
      creaby                                           as CreatedByUser,

      @Semantics.systemDateTime.createdAt: true
      create_tstmp                                     as CreationDateTime,

      @Semantics.user.lastChangedBy: true
      chngby                                           as LastChangedByUser,

      @Semantics.systemDateTime.lastChangedAt: true
      chng_tstmp                                       as LastChangeDateTime,

      _LogAccMUsrSecureIDAssgmt,
      _LogAccMSecureIDRepository,
      _CreatedByUser,
      _LastChangedByUser
}

Learn More