P_STOREPICKINGREQAUTHZDUSERALL

CDS View

P_STOREPICKINGREQAUTHZDUSERALL is a CDS View in S/4HANA. 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 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SUSR_NORMALIZE_UST12",
"SUSR_USER_AUTH_OBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More