P_EmplPrivCommData

DDL: P_EMPLPRIVCOMMDATA SQL: PEMPLPRVCOMMDATA Type: view BASIC

P_EmplPrivCommData is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adcp) and exposes 8 fields with key fields AddressID, Person.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
adcp root from

Annotations (3)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PEMPLPRVCOMMDATA view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AddressID adcp addrnumber
KEY Person adcp persnumber
DestinationLocationCountry
PhoneNumber
PhoneNumberExtension
MblPhoneDestinationLocCountry
MobilePhoneNumber
DefaultEmailAddress 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PEMPLPRVCOMMDATA'
@VDM.viewType: #BASIC
define view P_EmplPrivCommData 

  as select from adcp as root
  
   association[0..1] to  adr6 as _mail
    on root.addrnumber = _mail.addrnumber and
       root.persnumber = _mail.persnumber
     
     
  association[0..1] to adr2 as _phone  
    on root.addrnumber = _phone.addrnumber and 
       root.persnumber = _phone.persnumber
    
  {
   key root.addrnumber as AddressID,
   key root.persnumber as Person,
 
   _phone[1: r3_user = '1' ].country        as DestinationLocationCountry,
   _phone[1: r3_user = '1' ].tel_number     as PhoneNumber,
   _phone[1: r3_user = '1' ].tel_extens     as PhoneNumberExtension,
   
   _phone[1: r3_user = '3' ].country       as MblPhoneDestinationLocCountry, 
   _phone[1: r3_user = '3' ].tel_number    as MobilePhoneNumber, 
 
     
  _mail[1: flgdefault = 'X'].smtp_addr       as DefaultEmailAddress        
    
 
}  

            
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADCP",
"ADR2",
"ADR6"
],
"ASSOCIATED":
[
"ADR2",
"ADR6"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More