P_USER_ADDR_EMAIL

DDL: P_USER_ADDR_EMAIL SQL: PUSER_ADDR_EMAIL Type: view BASIC Package: SUSR

F4 Search Help for Email Addresses

P_USER_ADDR_EMAIL is a Basic CDS View that provides data about "F4 Search Help for Email Addresses" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 5 fields with key fields mandt, bname. Part of development package SUSR.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 inner

Annotations (6)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSER_ADDR_EMAIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label F4 Search Help for Email Addresses view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY mandt usr21 mandt
KEY bname usr21 bname
smtp_addr adr6 smtp_addr
flgdefault adr6 flgdefault
class usr02 class 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSER_ADDR_EMAIL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'F4 Search Help for Email Addresses'
@VDM.viewType: #BASIC

// F4 search help for Email Addresses

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

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



define view P_USER_ADDR_EMAIL
  as select distinct from  usr02
    inner join             usr21     on usr02.bname = usr21.bname
    left outer to one join adr6      on usr21.persnumber = adr6.persnumber
                                     and usr21.addrnumber = adr6.addrnumber
                                     and adr6.date_from = '00010101'
    {
       key usr21.mandt,
       key usr21.bname,
           adr6.smtp_addr,
           adr6.flgdefault,
           @Consumption.hidden: true
           usr02.class  // Do not export usergroup!          

    }

Learn More