P_BPUsrEEWASmtpSrchInitial

DDL: P_BPUSREEWASMTPSRCHINITIAL SQL: PBPUEEWASMTPINI Type: view BASIC

Business User Workplace Address SmtpSrch Initial

P_BPUsrEEWASmtpSrchInitial is a Basic CDS View that provides data about "Business User Workplace Address SmtpSrch Initial" in SAP S/4HANA. It reads from 3 data sources (adr6, usr21, usr21) and exposes 3 fields with key field UserID.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
adr6 _EMail left_outer
usr21 usr21 from
usr21 usr21 union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PBPUEEWASMTPINI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User Workplace Address SmtpSrch Initial view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY UserID usr21 bname
bnameasUserID
BusinessPartnerUUID usr21 bpperson 
@AbapCatalog.sqlViewName: 'PBPUEEWASMTPINI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business User Workplace Address SmtpSrch Initial'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm : #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view P_BPUsrEEWASmtpSrchInitial
  as select from    usr21
    left outer join adr6 as _EMail on  usr21.addrnumber = _EMail.addrnumber
                                   and usr21.persnumber = _EMail.persnumber
{
  key usr21.bname    as UserID,
      usr21.bpperson as BusinessPartnerUUID
}
where
  (
       usr21.idadtype   = '00'
    or usr21.idadtype   = '04'
  )
  and(
       _EMail.smtp_addr is initial
    or _EMail.smtp_addr is null
  )


union all
// per definition a business user with IDADTYPE = '02' does not have a workplace address

// --> so EMail as part of Workplace Address is initial

select from usr21
{
  key usr21.bname    as UserID,
      usr21.bpperson as BusinessPartnerUUID
}
where
  usr21.idadtype = '02'

Learn More