Core Data Services (CDS) ABAP Feature

Matrix
102925,091
With SAP NW ABAP 7.4 SP5 the first instalment of Core Data Services (CDS) support in ABAP was
delivered (see New Data Modeling Features in SAP NW ABAP 7.4 SP5). Since CDS is a relatively new
technology, new features are constantly being added. Below is a short overview of which features were
released with which SAP NW ABAP version and support package. For details about the features you
should check out the 7.40 ABAP Keyword Documentation, 7.50 ABAP Keyword Documentation and 7.51
ABAP Keyword Documentation.
 
ABAP Core Data Services (ABAP CDS)
SAP NW ABAP SQL Joins SQL Set Operations SELECT Clauses
7.4 SP5  INNER JOIN  UNION  WHERE
 LEFT OUTER JOIN  UNION ALL  GROUP BY
 RIGHT OUTER JOIN  HAVING
 AS
7.4 SP8
7.5
7.51   CROSS JOIN 
 
 SAP NW Literals Arithmetic Operators Conditional Expressions
ABAP
7.4 SP5  In SELECT list,  +  Boolean Operators
e.g. ‘literal’ AS  – o NOT, AND, OR
fieldName  *  Comparison Operators
 As RHS value o BETWEEN, = , <>, <,
>, <=, >=, LIKE
o IS [NOT] NULL**
** Only in WHERE conditions
7.4 SP8  / (Float-based 
division)
7.5
7.51  Function as RHS value
 
 SAP NW Aggregate Functions Numeric Functions String Functions
ABAP
7.4 SP5  AVG( [DISTINCT]  CEIL  SUBSTRING
)  MOD  LPAD
 MAX
 MIN
 SUM( [DISTINCT]
)
 COUNT( [DISTIN
CT] )
 COUNT( * )
7.4 SP8  ABS  CONCAT
 DIV (Integer-based  REPLACE
division)
 DIVISION (Decimal-
based division)
 FLOOR
 ROUND
7.5  CONCAT_WITH_SPACE
 INSTR
 LEFT
 LENGTH
 LTRIM
 RIGHT
 RPAD
 RTRIM
7.51  AVG( [AS] ) to   FLTP_TO_DEC  UPPER
specify return type  LOWER
 
SAP Byte String Date and Time Functions Other Functions
NW Functions
ABA
P
7.4  CAST to built-in DDIC
SP5 types, e.g.: abap.fltp
7.4  COALESCE
SP8  CURRENCY_CONVERSI
ON
 UNIT_CONVERSION
 DECIMAL_SHIFT
7.5  BINTOH  DATS_DAYS_BETWEEN  CAST
EX  DATS_ADD_DAYS o to data elements,
 HEXTOB  DATS_ADD_MONTHS e.g. CHAR80
IN  DATS_IS_VALID o can be nested
 TIMS_IS_VALID
 TSTMP_IS_VALID
 TSTMP_CURRENT_UTCTIMEST
AMP
 TSTMP_SECONDS_BETWEEN
 TSTMP_ADD_SECONDS
7.51  ABAP_SYSTEM_TIMEZONE  CAST
 ABAP_USER_TIMEZONE o PRESERVING
 TSTMP_TO_DATS TYPE
 TSTMP_TO_TIMS o SSTRING to other
 TSTMP_TO_DST types
 DATS_TIMS_TO_TSTMP o CLNT, LANG,
TIMS, UNIT to
data elements of
type CHAR and
SSTRING
o CHAR,
SSTRING,
NUMC to ACCP
and vice versa
o Aggregate
function as
operand
 
SAP Conditional (CASE) Extensibility (Unmanaged) Associations
NW Expressions
ABAP
7.4 SP5  “Simple” CASE $EXTENSION.* (support  Path expressions in
(behaves like for database table o SELECT list
 switch statement) extensions) o FROM clause
 Nested CASE o WHERE clause
statements o HAVING clause
 Filter conditions in path
expressions,
e.g.: Products._Texts[ langu =
‘EN’ ] as english_name
7.4 SP8  “Searched” CASE EXTEND VIEW**
(behaves like if … ** Added elements cannot
else if) be input parameters, path
expressions or aggregate
expressions
7.5  CASE expressions EXTEND VIEW**
can be used as ** Input parameters, path
operands in CAST expressions and conversion,
functions date and time functions can
be added/used
7.51  Function as RHS EXTEND VIEW**  Association definitions in views
value ** Views with aggregate with UNIONs
functions, GROUP BY  Default filters for associations
clauses and UNIONs can be (WITH DEFAULT FILTER)
extended  Cardinality “to many” ( *: ) can
be specified in path filters
 
SAP Session Variables Input Parameters Other
NW
ABA
P
7.4  KEY elements
SP5
7.4  Input parameters on most DBs**
SP8 ** Use ABAP
API cl_abap_dbfeatures=>use_features t
o check if your DB supports CDS views
with input parameters
7.5  $session.user (sy-uname)  Input parameters on AnyDB  TABLE
 $session.client (sy- FUNCTION*
mandt) *
 $session.system_languag ** SAP HANA only
e (sy-langu)
7.51   $session.system_date   Metadata
(sy-datum) Extensions
(separate
annotation
“files”)
 
SAP NW  “Core” Annotations Further Information
ABAP
7.4 SP5  End-user Texts ABAP CDS in
 (Implicit) Client Handling Release 7.40, SP05
 SAP Buffering
 Reference Fields for amounts/quantities
7.4 SP8  Data Aging ABAP CDS in
 Compiler (compare filter conditions of path expressions to reduce Release 7.40, SP08
number of JOINs)
7.5  Environment.systemField (assign ABAP system fields as default ABAP CDS in
 values to input parameters). Possible values: Release 7.50
o #CLIENT (sy-mandt)
o #SYSTEM_DATE (sy-datum)
o #SYSTEM_TIME (sy-uzeit)
o #SYSTEM_LANGUAGE (sy-langu)
o #USER (sy-uname)
7.51  Enhanced client-handling (@ClientHandling replaces ABAP CDS in
@ClientDependent) Release 7.51
 Specify key fields of CDS database view
(@AbapCatalog.preserveKey)
 NULL values for annotations
FollowLikeRSS Feed