Auth_Objct_Activity

DDL: AUTH_OBJCT_ACTIVITY SQL: AUTHOBJCTACTVT Type: view

Activity Values for S_RS_COMP,S_RS_COMP1,SDDLVIEW

Auth_Objct_Activity is a CDS View that provides data about "Activity Values for S_RS_COMP,S_RS_COMP1,SDDLVIEW" in SAP S/4HANA. It reads from 1 data source (ust12) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
ust12 C inner

Parameters (1)

NameTypeDefault
P_User syuname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName AUTHOBJCTACTVT view
EndUserText.label Activity Values for S_RS_COMP,S_RS_COMP1,SDDLVIEW view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
Authorization_Profile A auth
Object A objct 
@AbapCatalog.sqlViewName: 'AUTHOBJCTACTVT'
@EndUserText.label: 'Activity Values for S_RS_COMP,S_RS_COMP1,SDDLVIEW'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Auth_Objct_Activity with parameters P_User: syuname
as select distinct from usrbf2 as A
inner join ust12 as C
on A.auth = C.auth
and A.objct = C.objct
and (A.objct='S_RS_COMP' or A.objct='S_RS_COMP1' or A.objct='SDDLVIEW')
{ 
A.auth as Authorization_Profile,
A.objct as Object,
case C.von when '*' then 3 
           when '03' then 3 
           when '16' then 3 
           else 0 
    end as Value_Flag
}
where C.field = 'ACTVT' and (C.von = '16' or C.von = '03' or C.von = '*') and C.aktps = 'A'
    and A.bname = $parameters.P_User;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USRBF2",
"UST12"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More