Core Data Services (CDS) ABAP Feature Matrix

• INNER JOIN
• LEFT OUTER JOIN
• RIGHT OUTER JOIN

• UNION
• UNION ALL

• WHERE
• GROUP BY
• HAVING
• AS

•  CROSS JOIN

• In SELECT list, e.g. ‘literal’ AS fieldName
• As RHS value

• +
• –
• *

• Boolean Operators
  • NOT, AND, OR
• Comparison Operators
  • BETWEEN, = , <>, <, >, <=, >=, LIKE
  • IS [NOT] NULL**

** Only in WHERE conditions

• / (Float-based division)

• Function as RHS value

• AVG( [DISTINCT] )
• MAX
• MIN
• SUM( [DISTINCT] )
• COUNT( [DISTINCT] )
• COUNT( * )

• CEIL
• MOD

• SUBSTRING
• LPAD

• ABS
• DIV (Integer-based division)
• DIVISION (Decimal-based division)
• FLOOR
• ROUND

• CONCAT
• REPLACE

• CONCAT_WITH_SPACE
• INSTR
• LEFT
• LENGTH
• LTRIM
• RIGHT
• RPAD
• RTRIM

• AVG( [AS] ) to specify return type

•  FLTP_TO_DEC

• UPPER
• LOWER

• CAST to built-in DDIC types, e.g.: abap.fltp

• COALESCE
• CURRENCY_CONVERSION
• UNIT_CONVERSION
• DECIMAL_SHIFT

• BINTOHEX
• HEXTOBIN

• DATS_DAYS_BETWEEN
• DATS_ADD_DAYS
• DATS_ADD_MONTHS
• DATS_IS_VALID
• TIMS_IS_VALID
• TSTMP_IS_VALID
• TSTMP_CURRENT_UTCTIMESTAMP
• TSTMP_SECONDS_BETWEEN
• TSTMP_ADD_SECONDS

• CAST
  • to data elements, e.g. CHAR80
  • can be nested

• ABAP_SYSTEM_TIMEZONE
• ABAP_USER_TIMEZONE
• TSTMP_TO_DATS
• TSTMP_TO_TIMS
• TSTMP_TO_DST
• DATS_TIMS_TO_TSTMP

• CAST
  • PRESERVING TYPE
  • SSTRING to other types
  • CLNT, LANG, TIMS, UNIT to data elements of type CHAR and SSTRING
  • CHAR, SSTRING, NUMC to ACCP and vice versa
  • Aggregate function as operand

• “Simple” CASE (behaves like switch statement)
• Nested CASE statements

• Path expressions in
  • SELECT list
  • FROM clause
  • WHERE clause
  • HAVING clause
• Filter conditions in path expressions, e.g.: Products._Texts[ langu = ‘EN’ ] as english_name

• “Searched” CASE (behaves like if … else if)

** Added elements cannot be input parameters, path expressions or aggregate expressions

• CASE expressions can be used as operands in CAST functions

** Input parameters, path expressions and conversion, date and time functions can be added/used

• Function as RHS value

** Views with aggregate functions, GROUP BY clauses and UNIONs can be extended

• Association definitions in views with UNIONs
• Default filters for associations (WITH DEFAULT FILTER)
• Cardinality “to many” ( *: ) can be specified in path filters

• KEY elements

• Input parameters on most DBs**

** Use ABAP API cl_abap_dbfeatures=>use_features to check if your DB supports CDS views with input parameters

• $session.user (sy-uname)
• $session.client (sy-mandt)
• $session.system_language (sy-langu)

• Input parameters on AnyDB

• TABLE FUNCTION**

** SAP HANA only

•  $session.system_date (sy-datum)

• Metadata Extensions (separate annotation “files”)

• End-user Texts
• (Implicit) Client Handling
• SAP Buffering
• Reference Fields for amounts/quantities

• Data Aging
• Compiler (compare filter conditions of path expressions to reduce number of JOINs)

• Environment.systemField (assign ABAP system fields as default values to input parameters). Possible values:
  • #CLIENT (sy-mandt)
  • #SYSTEM_DATE (sy-datum)
  • #SYSTEM_TIME (sy-uzeit)
  • #SYSTEM_LANGUAGE (sy-langu)
  • #USER (sy-uname)

• Enhanced client-handling (@ClientHandling replaces @ClientDependent)
• Specify key fields of CDS database view (@AbapCatalog.preserveKey)
• NULL values for annotations