SAP HANA ABAP CDS Interview Questions(11-20)

Question #11: What are the best practices which developers should keep in mind while using ABAP Core Data Services (CDS)? Question #12: How CDS controls Access with DCL(Data Control Language)?

Best Practices with Code Push Down in S4 HANA

Code Push Down is a very effective mechanism to improve the performance of ABAP code, however, the usage should be properly analyzed and planned. A developer generally has multiple options to use when hitting the database

Performance Comparison:  New Open SQL vs CDS vs AMDP vs CTE

« Previous Index Next » It is a very common question nowadays, which one to chose when hitting the database? Option candidates are New Open SQL, CDS(Core Data Services), AMDP(ABAP Managed Database Procedure) or CTE(Common Table Expression). They all are designed for new enhanced ABAP and they all are made for delivering performance. Moreover, all … Continue reading Performance Comparison:  New Open SQL vs CDS vs AMDP vs CTE

CDS Session Variables

« Previous Index Next » As of ABAP 7.51, CDS framework provides some runtime system variables which can be readily used to make CDS more optimal and feature-rich. These session variables sometimes also discard the need of parameterization of CDS view. $session.client is runtime SAP client which is equivalent to sy-mandt $session.system_date is current system … Continue reading CDS Session Variables

Table Function with Parameters

« Previous Index Next » Let’s create a Simple Table Function right away… Steps to create and test CDS Table Function which is always created along with AMDP class method: Right Click on Project > New > Other > Data Definition Provide Package, CDS name, and Description and Click Next Select Package if Package is … Continue reading Table Function with Parameters

Table Function

« Previous Index Next » A Table function is an integral part of CDS evolution which challenges CDS to do more! It is essentially a Code push down mechanism just like a CDS entity. We call Table function a CDS Data Definition Language(DDL) which uses syntax DEFINE TABLE FUNCTION. Some salient features of table functions … Continue reading Table Function

CDS View on View

« Previous Index Next » CDS View on View is a concept where a CDS selects from other CDS. It may be a good Idea to create an Exposed association and then create another view(View on View) to select specifically the required fields. This is a good programming practice and enhances clarity with CDS programming! … Continue reading CDS View on View