The ABAP Core Data Services (ABAP CDS) framework has been available since NetWeaver 7.40 SP05 and offers highly attractive features & benefits, e.g.:
- Many new SQL features:
- SQL joins: INNER JOIN, LEFT OUTER JOIN, ...
- SQL set operations: UNION, UNION ALL
- SELECT clauses: GROUP BY, HAVING
- Aggregate functions: AVG, MAX, SUM, ...
- Numeric functions: CEIL, MOD, ABS, ...
- String functions: SUBSTRING, LPAD, CONCAT, ...
- Date and time functions: DATS_DAYS_BETWEEN, DATS_ADD_DAYS, ...
- ...
- Easy-to-integrate services on-top:
- OData clients
- SAP Fiori
- Analytics
- Simplification of application coding
- Push-down of workload into the database
Since the technology is fairly new it poses quite some challenges to you as system administrators or development teams. You need to
- ensure that the maintenance level of their software stack is up-to-date,
- keep an eye on the overall CDS work load,
- monitor and tune the performance of complex queries, and
- establish clear rules for the development of own code using CDS.
Fortunately, a best practice guide is now available on how to implement, monitor and tune CDS based applications in Business Suite systems. All supported databases types are covered (IBM Db2, Oracle, MS-SQL, SAP ASE, SAP MaxDB & SAP HANA DB). The document provides an holistic approach to CDS and is written for IT architects, ABAP developers, SAP Basis teams and database administrators. Regular updates are planned.
Direct Link:
ABAP Core Data Services | SAP Business Suite – Best Practice Guide
Short URL:
https://tinyurl.com/ABAP-CDS-inside-BusinessSuite
Last update of the guide:
7-Feb-2020