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

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

Extended CDS View

« Previous Index Next » How Extended CDS view Works? Extended CDS view works very similarly to Extension of Transparent Table. The CDS is extended in Eclipse IDE by writing some code. It's very simple to understand the basics of CDS extension. So, Let's extend a CDS: Goto Eclipse > Right Click on Project > … Continue reading Extended CDS View

CDS with Optional Parameters

« Previous Index Next » In the previous Tutorial, we saw how a CDS view can be made input enabled. This opens a new set of Code Push Down possibilities in AS ABAP. SAP provides a limited way(till release 7.51) for CDS view to accept optional parameters. Optional parameters here mean that parameters are optional … Continue reading CDS with Optional Parameters

CDS View with Parameters

« Previous Index Next » CDS views now come with the request Parameterization where scalar parameters can be passed to a CDS view. CDS with Parameter is very similar to normal CDS with the addition of keyword WITH PARAMETERS followed by the parameter name and its type. Till ABAP version 7.51, structured or tabular parameters are … Continue reading CDS View with Parameters

CDS View with Association and Path Expressions

« Previous Index Next » Let's  make ourselves familiar with some important keywords before we jump in to understand Association with examples: Association Association is different than join in that sense that association defines how two entities are connected to each other. It is sometimes understood as “Conceptual Thinking” also because its nature of linking … Continue reading CDS View with Association and Path Expressions