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: Unterschied zwischen den Versionen
| Zeile 1: | Zeile 1: | ||
[[Kategorie:Core Data Services]] | [[Kategorie:Core Data Services]] | ||
define view ZCDS_USER_INFORMATION as select from usr21 as user | define view ZCDS_USER_INFORMATION as select from usr21 as user | ||
-- JOIN | -- JOIN | ||
Version vom 24. März 2022, 11:52 Uhr
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 |
