Code Pushdown in ABAP on HANA

[former_member577082]

Hi All,

I am new to ABAP on HANA, i learnt about Code Push-down concept which means that it pushes the code to the database layer from the application layer there in the database layer it performs calculations and bring back the relevant data to the application layer.

Hear my doubt is, in ECC also we have both Application layer and Database layer but why the code is not pushed to database layer. What change in the HANA Database made this code push-down concept possible.

Rewards will be given

Thanks,

M.S.L.Praveena.

[geert-janklaps]

Hi,

Please have a look at following blog, which explains the main differences between both approaches.

https://blogs.sap.com/2020/03/14/code-to-data-paradigm-in-abap-with-sap-hana/

In ECC you can use the same code push down approach if your ECC system is running on top of a HANA database. (you can use in on classic databases as well, but you won't get the same advantages like the performance improvements compared to SAP HANA databases)

Best regards,

Geert-Jan Klaps

[matt]

Rewards? Really?

[FredericGirod]

matthew.billingham 🙂 you are waiting in the dark for rewards, I am sure !! 🙂

[Sandra_Rossi]

There are rewards in SAP Community now? Money? Do people really need rewards to answer? Do companies prefer hiring developers who have SCN badges and present screenshots of karma points? Or do you just mean the "upvote" and "accept answer" (-> karma points in your profile) in that case no need to say.

You say "why the code is not pushed to database layer", you mean in ABAP versions before AMDP/CDS were introduced (before 7.40)? Because there was no integrated mechanism provided by SAP. Before that, you could write database procedures at database side and call them from ABAP, but it was custom development, and it couldn't be called "pushdown" of course.

[ujjwal16]

Simple answer:

Before HANA for SAP ECC, dta base which SAP using was mostly Oracle, although it can be any DB like IBM DB2, Microsoft Access, SQL database etc...all these were just database, which means they can only hold physical data, which can further be extracted by application layer and perform the calculation.

Whereas, HANA is not just a database, but also a platform. Platform is something that helps you in performing various amputations and calculations.

HANA has an in-memory database with tools and a set of application libraries where it allows for a superior OLTP and OLAP system.