P_RU_BusinessPartnerEmailAll

DDL: P_RU_BUSINESSPARTNEREMAILALL SQL: PRUBPEMAILALL Type: view COMPOSITE Package: GLO_FIN_IS_RU

Customasing for BP Email + real BP Email

P_RU_BusinessPartnerEmailAll is a Composite CDS View that provides data about "Customasing for BP Email + real BP Email" in SAP S/4HANA. It reads from 3 data sources (I_BPCurrentDefaultAddress, I_BPCurrentDefaultAddress, I_BusinessPartner) and exposes 6 fields with key fields Partner, PartnerEmail, PartnerEmail. Part of development package GLO_FIN_IS_RU.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_BPCurrentDefaultAddress BPAddr from
I_BPCurrentDefaultAddress BPAddr union
I_BusinessPartner BusinessPartner inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRUBPEMAILALL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Partner CustEmail Partner
KEY PartnerEmail CustEmail BusinessPartnerEmailAddress
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted
KEY PartnerEmail
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
EmailAddressIsCurrentDefault 
@AbapCatalog.sqlViewName: 'PRUBPEMAILALL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
define view P_RU_BusinessPartnerEmailAll 
  as 
  select distinct from  I_RU_BusinessPartnerEmail  as CustEmail
    inner join I_BusinessPartner as BusinessPartner on  CustEmail.Partner = BusinessPartner.BusinessPartner 
{
  key CustEmail.Partner,
  key CustEmail.BusinessPartnerEmailAddress                      as PartnerEmail,
  BusinessPartner.IsBusinessPurposeCompleted,                    
  ''                                                             as EmailAddressIsCurrentDefault
}

union 
select from I_BPCurrentDefaultAddress as BPAddr{
    key BusinessPartner as Partner,
    key _AddressDefaultRepresentation._EmailAddress.EmailAddress as PartnerEmail,
    _BusinessPartner.IsBusinessPurposeCompleted,
    'X'                                                          as EmailAddressIsCurrentDefault
}

Learn More