P_StorePickingReqAuthzdUser

DDL: P_STOREPICKINGREQAUTHZDUSER SQL: PSTRASSAUTHUSR Type: view COMPOSITE

P_StorePickingReqAuthzdUser is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_StorePickingReqAuthzdUserAll, I_Site, I_User) and exposes 2 fields with key fields Store, UserID.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
P_StorePickingReqAuthzdUserAll _Auth inner
I_Site I_Site inner
I_User I_User inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSTRASSAUTHUSR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Store I_Site Site
KEY UserID auth bname 
@AbapCatalog.sqlViewName: 'PSTRASSAUTHUSR'

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_StorePickingReqAuthzdUser 
as select distinct from P_StorePickingReqAuthzdUserAll as auth  
    inner join P_StorePickingReqAuthzdUserAll as _Auth
                                 on _Auth.bname = auth.bname
                                and _Auth.object = 'W_ST_PKRQ'
                                and _Auth.field = 'ACTVT'
                                and ( _Auth.low = '03'
                                 or  _Auth.low  = '02'
                                 or  _Auth.low  = '*')                             
    inner join            I_User on auth.bname = I_User.UserID
    inner join            I_Site on auth.low      =  I_Site.Site
                                 or auth.low      =  '*'
                                 or (
                                    auth.low      <= I_Site.Site
                                    and auth.high >= I_Site.Site
                                  )
{
  key I_Site.Site as Store,
  key auth.bname       as UserID
}
where
      auth.object                 = 'W_ST_PKRQ'
  and auth.field                  = 'WERKS'
//  and I_User.IsTechnicalUser      = ' '

  and I_Site.SiteCategory         = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SITE",
"I_USER",
"P_STOREPICKINGREQAUTHZDUSERALL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More