P_UserDefaults

DDL: P_USERDEFAULTS Type: view_entity Package: SUSR

User Defaults

P_UserDefaults is a CDS View that provides data about "User Defaults" in SAP S/4HANA. It reads from 3 data sources (usr21, usr01, P_USR02) and exposes 13 fields with key field bname. Part of development package SUSR.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
usr21 UserAddress left_outer
usr01 UserDefaults from
P_USR02 UserExistence inner

Annotations (7)

NameValueLevelField
AbapCatalog.extensibility.extensible false view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User Defaults view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions false view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY bname usr01 bname
stcod usr01 stcod
spld usr01 spld
splg usr01 splg
spdbelseHendasspdb
spdaelseKendasspda
datfm usr01 datfm
dcpfm usr01 dcpfm
langu usr01 langu
start_menu usr21 start_menu
timefm usr01 timefm
tzone P_USR02 tzone
class P_USR02 class 
@AbapCatalog:   {
                  viewEnhancementCategory: [ #NONE ]
                , extensibility: { extensible: false }
                }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'User Defaults'
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #M,
  dataClass: #MIXED
}
@Metadata:      { allowExtensions: false }

// built for function module 'SUSR_USER_GET_DETAIL_MASS' (mass enabled 'BAPI_USER_GET_DETAIL')

// Parameter DEFAULTS with BAPIDEFAUL structure + username


define view entity P_UserDefaults
  as select from          usr01    as UserDefaults
    inner join            P_USR02  as UserExistence on UserExistence.bname = UserDefaults.bname
    left outer join       usr21    as UserAddress   on UserAddress.bname   = UserDefaults.bname
{
  key UserDefaults.bname,
      UserDefaults.stcod,
      UserDefaults.spld,
      UserDefaults.splg,
      case when UserDefaults.spdb is not initial then UserDefaults.spdb 
      else 'H' 
      end as spdb,
      case when UserDefaults.spda is not initial then UserDefaults.spda 
      else 'K'
      end as spda,
      UserDefaults.datfm,
      UserDefaults.dcpfm,
      UserDefaults.langu,
      //UserDefaults.cattkennz

      //UserAddress.kostl

      UserAddress.start_menu,
      UserDefaults.timefm,
      UserExistence.tzone,
      UserDefaults.ianatzonecode,

      @Consumption.hidden: true
      UserExistence.class
}

Learn More