In this series of videos, We want to discuss some performance aspects of ABAP CDS views. When a Fiori app is executed, user parameters will be passed down via OData query options to some handler logic in the ABAP backend. Either the SADL framework builds an SQL statement on a CDS view that is directly passed to the database, or some ABAP processing logic is called that executes SELECTs or JOINs on CDS views.
Course Page: www.anubhavtrainings.com/aoh-...
Call us on +91-84484 54549
Mail us on contact@anubhavtrainings.com
Website: www.anubhavtrainings.com
Our forum: www.anubhavtrainings.com/anub...
Join Our Telegram Channel : t.me/Anubhavlearningseries12
Linkedin: / anubhav-oberoy-3a216957
Pinterest: / anubhavtrainings
Twitter Page: / anubhavoberoy
Facebook : / anubhavtraining
Instagram : / anubhavtrainings
Linkedin: / anubhavtrainings
Feel free to call us on +91 8448454549, Or mail us on contact@anubhavtrainings.com
You can download the ppt of this session from below
anubhavtrainings.com/anubhav-...
Learn all the different techniques, which include the development of CDS in following aspects
➜ Finding CDS DDL Source Table
➜ CDS View with Dependency Tree, Dependency Graph and Graphical Editor
➜ Method 1 CDS Execution Plan: WIth the SQL Trace ST05
➜ Method 2 CDS Execution Plan: SQL Console
➜ CDS Execution Plan and Operations
➜ Best Practices to Improve Performance
➜ Demonstrate Null Value Preserving vs Non-Preserving Performance
➜ Code Push Down Exceptions
➜ Summary of the Section and Course
▶ Core Data Service is also known as CDS is one of the integral parts of many SAP® Projects. Advantage of Using CDS are:
➜ With the help of Core Data Services, we can expose data in views
which are compatible with ABAP® Dictionary
➜ Transport CDS views across multiple systems
➜ We can perform complex queries and join operations and reuse
existing CDS views
➜ We can use CDS view inside the ABAP® program with AMDP to Take
Advantage of Performance of HANA® and Features of ABAP®
➜ CDS also come up with feature-rich annotations, with the help
of which we can expose CDS views as oData source in a few
simple steps
➜ All than and more gives you enough reason to learn and
understand CDS view
In both cases, the resulting SQL statement will incorporate the access to a CDS view, which is a SQL expression on its own, plus one or several of the following ingredients:
Filters (via WHERE-clause and / or view parameters), projections (field lists), and other SQL options (GROUP BY, ORDER BY, LIMIT, …)
Explicit joins of the CDS view with other tables and views in ABAP OpenSQL
Additional OUTER JOINs that are added if associations are followed explicitly by accessing fields via path notation
Additional fields in WHERE-clause or joins are added if authority checks (DCLs - Data Control Language objects) are assigned to the CDS view