I_LogAccMActvSingleProfiles

DDL: I_LOGACCMACTVSINGLEPROFILES SQL: IACMSINGLEPRF Type: view BASIC

Single Profiles

I_LogAccMActvSingleProfiles is a Basic CDS View that provides data about "Single Profiles" in SAP S/4HANA. It reads from 1 data source (ust10s) and exposes 6 fields with key fields LogAccMSingleProfileIsActive, LogAccMSingleProfileAuthName, LogAccMSingleProfileAuthObject, LogAccMSingleProfileName. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
ust10s LogAccMSingleProfiles from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_LogAccMActvUsrAuthorizations _LogAccMActvUsrAuthorizations LogAccMSingleProfiles.auth = _LogAccMActvUsrAuthorizations.LogAccMUserAuthznName
[0..*] I_LogAccMUserMaster _LogAccMUserMaster LogAccMSingleProfiles.profn = _LogAccMUserMaster.LogAccMUserMasterProfile

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMSINGLEPRF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M 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 Single Profiles view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LogAccMSingleProfileIsActive
KEY LogAccMSingleProfileAuthName auth
KEY LogAccMSingleProfileAuthObject objct
KEY LogAccMSingleProfileName profn
_LogAccMActvUsrAuthorizations _LogAccMActvUsrAuthorizations
_LogAccMUserMaster _LogAccMUserMaster 
@AbapCatalog.sqlViewName: 'IACMSINGLEPRF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

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

@EndUserText.label: 'Single Profiles'

define view I_LogAccMActvSingleProfiles
  as select from ust10s as LogAccMSingleProfiles
  association [0..*] to I_LogAccMActvUsrAuthorizations as _LogAccMActvUsrAuthorizations on LogAccMSingleProfiles.auth = _LogAccMActvUsrAuthorizations.LogAccMUserAuthznName
  association [0..*] to I_LogAccMUserMaster            as _LogAccMUserMaster            on LogAccMSingleProfiles.profn = _LogAccMUserMaster.LogAccMUserMasterProfile
{
  key cast( aktps as /plmb/auth_do_active_state preserving type ) as LogAccMSingleProfileIsActive,
  key auth  as LogAccMSingleProfileAuthName,
  key objct as LogAccMSingleProfileAuthObject,
  key profn as LogAccMSingleProfileName,
  
  /*Associations*/
  _LogAccMActvUsrAuthorizations,
  _LogAccMUserMaster
}
where
  aktps = 'A' // only Active versions

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UST10S"
],
"ASSOCIATED":
[
"I_LOGACCMACTVUSRAUTHORIZATIONS",
"I_LOGACCMUSERMASTER"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More