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
Aus SAP Wiki ツ
K M1ch3lde verschob die Seite CDS Views nach CDS Views Grundlagen |
|||
| (8 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 7: | Zeile 7: | ||
|- | |- | ||
|@AbapCatalog.sqlViewName | |@AbapCatalog.sqlViewName | ||
| | |Name für automatisch generierter View in der SE11 | ||
|- | |- | ||
|@AbapCatalog.compiler.compareFilter | |@AbapCatalog.compiler.compareFilter | ||
| Zeile 33: | Zeile 33: | ||
* | * | ||
<syntaxhighlight lang=" | <syntaxhighlight lang="php" copy> | ||
define view ZCDS_USER_INFORMATION as select from usr21 as user | define view ZCDS_USER_INFORMATION as select from usr21 as user | ||
-- JOIN | -- JOIN | ||
| Zeile 81: | Zeile 81: | ||
|- | |- | ||
|} | |} | ||
Aktuelle Version vom 23. November 2024, 19:39 Uhr
Annotiations
= Definierung von Eingeschaften, Einstellungen und Metadaten für den View.
| @AbapCatalog.sqlViewName | Name für automatisch generierter View in der SE11 |
| @AbapCatalog.compiler.compareFilter | True: False: |
| @AbapCatalog.preserveKey | True: False: |
| @AccessControl.authorizationCheck | #NOT_REQUIRED:
#CHECK: |
| @EndUserText.label | Beschreibungstext des Views |
| @VDM.viewType | #CONSUMPTION |
Associations
- Standardgemäß Abbildung als LEFT OUTER JOIN
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 |
