I_LogAccMSecureIDRepository

DDL: I_LOGACCMSECUREIDREPOSITORY SQL: IACMSECIDRPTY Type: view BASIC Package: VDM_PLMB_ACM

Secure ID Repository

I_LogAccMSecureIDRepository is a Basic CDS View that provides data about "Secure ID Repository" in SAP S/4HANA. It reads from 1 data source (/plmb/auth_sidrp) and exposes 13 fields with key field LogAccMSecureID. It has 4 associations to related views. Part of development package VDM_PLMB_ACM.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
/plmb/auth_sidrp /plmb/auth_sidrp from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_LogAccMObjSecureIDAssgmt _LogAccMUsrSecureIDAssgmt $projection.LogAccMSecureID = _LogAccMUsrSecureIDAssgmt.LogAccMSecureID
[0..1] I_LogAccMContext _LogAccMContext $projection.LogAccMSecureIDOwnerID = _LogAccMContext.LogAccMContextInternalId and $projection.LogAccMSecureIDOwnerType = 'ACC'
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMSECIDRPTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Secure ID Repository view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY LogAccMSecureID sid
LogAccMObjectType obj_type
LogAccMSecureIDOwnerType owner_type
LogAccMSecureIDOwnerID owner_id
CreatedByUser creaby
CreationDateTime create_tstmp
LastChangedByUser chngby
LastChangeDateTime chng_tstmp
LogAccMSecureIDIsDeleted delflg
_LogAccMUsrSecureIDAssgmt _LogAccMUsrSecureIDAssgmt
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_LogAccMContext _LogAccMContext 
@AbapCatalog.sqlViewName: 'IACMSECIDRPTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Secure ID Repository'

define view I_LogAccMSecureIDRepository
  as select from /plmb/auth_sidrp

  association [0..*] to I_LogAccMObjSecureIDAssgmt as _LogAccMUsrSecureIDAssgmt on  $projection.LogAccMSecureID = _LogAccMUsrSecureIDAssgmt.LogAccMSecureID
  association [0..1] to I_LogAccMContext           as _LogAccMContext           on  $projection.LogAccMSecureIDOwnerID   = _LogAccMContext.LogAccMContextInternalId
                                                                                and $projection.LogAccMSecureIDOwnerType = 'ACC'
  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,
      obj_type                                         as LogAccMObjectType,

      owner_type                                       as LogAccMSecureIDOwnerType,

      owner_id                                         as LogAccMSecureIDOwnerID,

      @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,

      delflg                                           as LogAccMSecureIDIsDeleted,

      _LogAccMUsrSecureIDAssgmt,
      _CreatedByUser,
      _LastChangedByUser,
      _LogAccMContext
}

Learn More