I_LogAccMObjSecureIDAssgmt

DDL: I_LOGACCMOBJSECUREIDASSGMT SQL: IACMOBJSIDASGMNT Type: view BASIC

Object Secure ID Assignment

I_LogAccMObjSecureIDAssgmt is a Basic CDS View that provides data about "Object Secure ID Assignment" in SAP S/4HANA. It reads from 1 data source (/plmb/auth_obsid) and exposes 12 fields with key fields LogAccMSecureID, LogAccMObjectType, LogAccMObjectID. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
/plmb/auth_obsid /plmb/auth_obsid from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_LogAccMUsrSecureIDAssgmt _LogAccMUsrSecureIDAssgmt $projection.LogAccMSecureID = _LogAccMUsrSecureIDAssgmt.LogAccMActivitySecureID
[0..1] I_LogAccMSecureIDRepository _LogAccMSecureIDRepository $projection.LogAccMSecureID = _LogAccMSecureIDRepository.LogAccMSecureID
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMOBJSIDASGMNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL 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 Object Secure ID Assignment view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LogAccMSecureID sid
KEY LogAccMObjectType obj_type
KEY LogAccMObjectID object_id
LogAccMObjectAssignmentType assgnmt_type
CreatedByUser creaby
CreationDateTime create_tstmp
LastChangedByUser chngby
LastChangeDateTime chng_tstmp
_LogAccMUsrSecureIDAssgmt _LogAccMUsrSecureIDAssgmt
_LogAccMSecureIDRepository _LogAccMSecureIDRepository
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMB/AUTH_OBSID"
],
"ASSOCIATED":
[
"I_LOGACCMSECUREIDREPOSITORY",
"I_LOGACCMUSRSECUREIDASSGMT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More