Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
bernd_kohler
Explorer
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
4 Comments