TSI_CONTACT_entry

@AbapCatalog.sqlViewName: 'V_TSI_CONTACT'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true 
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
 define view TSI_CONTACT_entry as select  
      from usr21 as usr21
      inner join adcp as adcp 
         on usr21.mandt = adcp.client
        and usr21.persnumber = adcp.persnumber
        and usr21.addrnumber = adcp.addrnumber
      inner join adrc as adrc
        on usr21.mandt = adrc.client
       and usr21.addrnumber = adrc.addrnumber
      left outer join adr6 as adr6
         on usr21.mandt = adr6.client
        and usr21.persnumber = adr6.persnumber
        and usr21.addrnumber = adr6.addrnumber 
      left outer join adrp as adrp
        on usr21.mandt = adrp.client
       and usr21.persnumber = adrp.persnumber  {
           usr21.mandt,
           usr21.bname,
           usr21.persnumber, 
           usr21.addrnumber,
           adrc.name1,
           adrc.country,
           adrc.city1,
           adrc.street,
           adcp.fax_number,
           adcp.fax_extens,
           adcp.tel_number,
           adcp.tel_extens,
           adrp.title,
           adrp.name_first,
           adrp.name_last,
           adr6.smtp_addr}