P_STOREPICKINGREQAUTHZDUSERALL

CDS View

Authrized users for picking app All

P_STOREPICKINGREQAUTHZDUSERALL is a CDS View in S/4HANA. Authrized users for picking app All. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_StorePickingReqAuthzdUser view inner COMPOSITE Authrized users for picking app 
@AbapCatalog.sqlViewName: 'PSTRASSAUTHUSRA'
@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
// Refer View SUSR_USER_AUTH_OBJECT_VALS 

define view P_StorePickingReqAuthzdUserAll as select distinct 
      from 
        SUSR_USER_AUTH_OBJECT inner join SUSR_NORMALIZE_UST12
      on
        SUSR_USER_AUTH_OBJECT.object = SUSR_NORMALIZE_UST12.object and
        SUSR_USER_AUTH_OBJECT.auth  = SUSR_NORMALIZE_UST12.auth
        
      { 
        SUSR_USER_AUTH_OBJECT.bname as bname,
        SUSR_USER_AUTH_OBJECT.auth  as auth,
        SUSR_USER_AUTH_OBJECT.object as object,
        SUSR_NORMALIZE_UST12.field as field,
        SUSR_NORMALIZE_UST12.von_normalized as low,
        SUSR_NORMALIZE_UST12.bis_normalized as high
      }
where SUSR_USER_AUTH_OBJECT.object = 'W_ST_PKRQ'

Learn More