SAP ABAP HANA CDS Interview Questions

Question 1: What is SAP CDS view? Answer Question 2: Which three TADIR objects/artifacts are created on activation of a CDS? Answer Question 3: How many types of CDS views are there? Answer Question 4: What is Association and Path expression in CDS? Answer Question 5: Can CDS view have a tabular parameter(as of ABAP 7.52)? Answer: No, CDS view … Continue reading SAP ABAP HANA CDS Interview Questions

Advertisements

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