CDS Views Grundlagen

define view ZCDS_USER_INFORMATION as select from usr21 as user
-- JOIN
//left outer join adrc as company
//    on user.addrnumber = company.addrnumber
//left outer join adr6 as email
//    on user.addrnumber = email.addrnumber and user.persnumber = email.persnumber
//left outer join adrp as name
//    on user.persnumber = name.persnumber
-- ASSOCIATIONS
association to adrc as company on user.addrnumber = company.addrnumber
association to adr6 as email on user.addrnumber = email.addrnumber and user.persnumber = email.persnumber
association to adrp as name on user.persnumber = name.persnumber
{
    user.bname as Benutzername,
    name.name_first as Vorname,
    name.name_last as Nachname,
    email[inner].smtp_addr as EMail, // ohne inner = outer join über 600 Einträge, mit Inner nur Einträge wo die E-Mail vorhanden ist
    company.name1 as Firmenname
}

Sonstiges

Kommentare

• //
• --

SY-Felder

sy-mandt	#CLIENT
sy-datum	#SYSTEM_DATE
sy-uzeit	#SYSTEM_TIME
sy-langu	#SYSTEM_LANGUAGE
sy-user	#USER