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

} </syntaxhighlight>

Sonstiges

SY-Felder

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