SAP NetWeaver AS ABAP Release 752, ©Copyright 2017 SAP AG. Alle Rechte vorbehalten.
ABAP - Schlüsselwortdokumentation → ABAP - Kurzreferenz → S
SELECT - Kurzreferenz
Syntax
SELECT [SINGLE [FOR UPDATE]]
{ [DISTINCT] { *
| { ..., data_source~*, ...,
col|
agg_exp( [DISTINCT] col )|
sql_exp} [AS alias], ... }
| (column_syntax)
FROM { { {data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}
| { [(] {data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}|join
{[INNER] JOIN}|{LEFT|RIGHT [OUTER [MANY TO ONE]] JOIN}|{CROSS JOIN}
{data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}|join [ON join_cond]
[)] }
| (source_syntax) [WITH PRIVILEGED ACCESS] [AS tabalias] }
[ {USING CLIENT clnt}
| {CLIENT SPECIFIED [entity1~clnt] [, entity2~clnt] ...} ] } }
| { FROM { { {data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}
| { [(] {data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}|join
{[INNER] JOIN}|{LEFT|RIGHT [OUTER [MANY TO ONE]] JOIN}|{CROSS JOIN}
{data_source [WITH PRIVILEGED ACCESS] [AS tabalias]}|join [ON join_cond]
[)] }
| (source_syntax) [AS tabalias] }
[ {USING CLIENT clnt}
| {CLIENT SPECIFIED [entity1~clnt] [, entity2~clnt] ...} ] }
FIELDS [DISTINCT]
{ *
| { ..., data_source~*, ...,
col|agg_exp( [DISTINCT] col )|
sql_exp} [AS alias], ... }
| (column_syntax) }
[[FOR ALL ENTRIES IN itab] WHERE sql_cond]
[GROUP BY {col1|
sql_exp1, col2|
sql_exp2, ...}|(column_syntax)]
[HAVING sql_cond]
[UNION ALL|DISTINCT SELECT ...]
[ORDER BY { {PRIMARY KEY}
|{{{col1|a1} [ASCENDING|DESCENDING],}
{{col2|a2} [ASCENDING|DESCENDING],}
... }
| (column_syntax) }].
{ { INTO {[CORRESPONDING FIELDS OF] wa}|(dobj1, dobj2, ...) }
| { INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab
[PACKAGE SIZE n] }
| { INTO @DATA(wa) }
| { INTO TABLE @DATA(itab) [PACKAGE SIZE n] } }
[ EXTENDED RESULT @oref ]
[ CREATING { READER|LOCATOR FOR { COLUMNS col1 col2 ... }
| { ALL [OTHER] [BLOB|CLOB] COLUMNS }
[READER|LOCATOR FOR ...] }
| { (crea_syntax) } ]
[UP TO n ROWS]
[OFFSET o]
[BYPASSING BUFFER]
[CONNECTION con|(con_syntax)]
...
[ENDSELECT.]
Wirkung
Open-SQL-Anweisung. Liest
Daten aus einer oder mehreren Datenbanktabellen in Datenobjekte. Wenn die Ergebnismenge nicht auf einmal
zugewiesen wird, wird eine Schleife geöffnet, die mit ENDSELECT abgeschlossen werden muss und in der die Ergebnisse in den Zielfeldern zur Verfügung stehen.
Zusätze
Angabe der Zeilen:
Struktur der Ergebnismenge
Angabe der Datenbanktabelle(n):
Angabe einer Bedingung:
Angabe einer Gruppierung:
Angabe einer Union:
Angabe einer Sortierung:
Angabe des Zielbereichs:
Angabe von Zusätzen: