SAP SELECT DATA SOURCE ABAP Statements

Get Example source ABAP code based on a different SAP table

• WITH PRIVILEGED ACCESS SELECT FROM

SELECT, FROM data_source
Short Reference

ABAP_SYNTAX
... dbtab
BEGIN_SECTION VERSION 5 OUT $|view
END_SECTION VERSION 5 OUT $[WITH PRIVILEGED ACCESS$]
$| cds_entity$[sql_para$]$[ sql_path$]$|$[WITH PRIVILEGED ACCESS$]
$| +cte$[sql_path$]
$| hierarchy_data
$| @itab

ABAP_ALTERNATIVES:
1 ... dbtab
BEGIN_SECTION VERSION 5 OUT $|view
END_SECTION VERSION 5 OUT $[WITH PRIVILEGED ACCESS$]
2 ... cds_entity$[sql_para$]$[sql_path$]$|$[WITH PRIVILEGED ACCESS$]
3 ... +cte$[sql_path$]
4 ... hierarchy_data
5 ... @itab

What does it do?
Specifies an individual DDIC database table dbtab,
BEGIN_SECTION VERSION 5 OUT a DDIC view view,
END_SECTION VERSION 5 OUT a non-abstract CDS entity cds_entity , a common table expression +cte, hierarchy data, an internal table @itab, or a CDS system entity in the FROM clause of a query.
Regarding views, there is the restriction that only those whose key fields are located together at the beginning of the view can be accessed.

ABAP Alternative 1 ... dbtab
BEGIN_SECTION VERSION 5 OUT $|view
END_SECTION VERSION 5 OUT $[WITH PRIVILEGED ACCESS$]

ABAP Addition
... WITH PRIVILEGED ACCESS

What does it do?
Specifies a DDIC database table dbtab
BEGIN_SECTION VERSION 5 OUT , a DDIC view or an external DDIC view view
END_SECTION VERSION 5 OUT .
BEGIN_SECTION VERSION 5 OUT DDIC views on which reads can be performed using SELECT are DDIC database views and DDIC projection views.
END_SECTION VERSION 5 OUT

Latest notes: