P_USER_ADDR

DDL: P_USER_ADDR SQL: PUSER_ADDR Type: view BASIC Package: SUSR

F4 Suchhilfe für Benutzer

P_USER_ADDR is a Basic CDS View that provides data about "F4 Suchhilfe für Benutzer" in SAP S/4HANA. It reads from 2 data sources (usr02, usr21) and exposes 21 fields with key fields mandt, bname. Part of development package SUSR.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
usr02 usr02 from
usr21 usr21 inner

Annotations (6)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSER_ADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label F4 Suchhilfe für Benutzer view
VDM.viewType #BASIC view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY mandt usr21 mandt
KEY bname usr21 bname
name_first adrp name_first
name_last adrp name_last
NAME_TEXTC adrp name_text
tel_extens adcp tel_extens
kostl usr21 kostl
building adcp building
roomnumber adcp roomnumber
department adcp department
INHOUSE_ML adcp ih_mail
name1 adrc name1
city1 adrc city1
post_code1 adrc post_code1
mc_namefir adrp mc_namefir
mc_namelas adrp mc_namelas
mc_name1 adrc mc_name1
mc_city1 adrc mc_city1
company uscompany company
idadtype usr21 idadtype
class usr02 class 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSER_ADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'F4 Suchhilfe für Benutzer'
@VDM.viewType: #BASIC

// F4 search help for Users

// This CDS view is used in the search help USER_ADDR.

// An authority check for S_USER_GRP with activity '03' (later also 'F4') is performed.



define view P_USER_ADDR
  as select from           usr02
    inner join             usr21     on  usr02.bname      = usr21.bname
    left outer to one join adrp      on  usr21.persnumber = adrp.persnumber
                                     and adrp.nation      = ''
                                     and adrp.date_from   = '00010101'
    left outer to one join adcp      on  usr21.persnumber = adcp.persnumber
                                     and usr21.addrnumber = adcp.addrnumber
                                     and adcp.nation      = ''
                                     and adcp.date_from   = '00010101'
    left outer to one join uscompany on  usr21.addrnumber = uscompany.addrnumber
                                     or (     usr21.template_orgaddr = uscompany.addrnumber
                                          and usr21.idadtype         = '04'                 )  // Use company or template_company

    left outer to one join adrc      on  usr21.addrnumber = adrc.addrnumber
                                     and adrc.nation      = ''
                                     and adrc.date_from   = '00010101'
    {
  key usr21.mandt,
  key usr21.bname,
      adrp.name_first,
      adrp.name_last,
      adrp.name_text as NAME_TEXTC,
      adcp.tel_extens,
      usr21.kostl,
      adcp.building,
      adcp.roomnumber,
      adcp.department,
      adcp.ih_mail   as INHOUSE_ML,
      adrc.name1,
      adrc.city1,
      adrc.post_code1,
      adrp.mc_namefir,
      adrp.mc_namelas,
      adrc.mc_name1,
      adrc.mc_city1,
      uscompany.company,
      usr21.idadtype,    
      @Consumption.hidden: true
      usr02.class  // Do not export usergroup! 

}

Learn More