adesso orange🍊Stellenangebote:
Software Engineer Trainee · Senior
| (Senior) Cloud Software Engineer BTP
(Senior) Consultant Technologie · Consultant ABAP
Werkstudent Softwareentwicklung · Fiori / UI5 · Consulting · Application Management
Ich habe manuell über mehrere Versionen das Wiki geupdated. Evtl. läuft es noch nicht ganz rund ツ
CDS Views Grundlagen
Aus SAP Wiki ツ
Associations
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 mehr 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 |