P_RetailStoreAssignableUser

DDL: P_RETAILSTOREASSIGNABLEUSER SQL: PRTSTASSGBLUSER Type: view BASIC Package: ODATA_RETAIL_ST_COMMON

Assignable Users per Store in Retail Store Apps

P_RetailStoreAssignableUser is a Basic CDS View that provides data about "Assignable Users per Store in Retail Store Apps" in SAP S/4HANA. It reads from 2 data sources (I_Site, I_User) and exposes 2 fields with key fields Store, UserID. Part of development package ODATA_RETAIL_ST_COMMON.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_Site I_Site inner
I_User I_User inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRTSTASSGBLUSER 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 #BASIC view
VDM.private true view

Fields (2)

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

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

@VDM.viewType: #BASIC
@VDM.private: true
define view P_RetailStoreAssignableUser
  as select distinct from SUSR_USER_AUTH_OBJECT_VALS
    inner join            I_User on bname = I_User.UserID
    inner join            I_Site on low      =  I_Site.Site
                                 or low      =  '*'
                                 or (
                                    low      <= I_Site.Site
                                    and high >= I_Site.Site
                                  )
{
  key I_Site.Site as Store,
  key bname       as UserID
}
where
      object                 = 'W_SRS_APPL'
  and field                  = 'WERKS'
  and I_User.IsTechnicalUser = ' '
  and I_Site.SiteCategory    = 'A'

Learn More