At Flexso, we’ve been checking out ABAP7.4 on HANA. One of our most important goals was to test the Code pushdown methodology. I’m pretty sure a lot of you have seen the code pushdown in action already. For those who were not yet able to test it, we’ve created a basic tutorial/movie.
So for using code pushdown, you have to start in HANA (bottom up approach) in order to access your HANA developments afterwards from the ABAP application layer. Because we’re working on ABAP 7.4 we can use the new ABAP for HANA artifacts:
In this tutorial we start by creating an attribute view in the HANA Studio, joining two tables, ZPA0000 and ZPA0001. These tables are replications of the tables PA0000 and PA0001 from ECC HR. We will also add a filter on one of the fields (comparable to a where condition in a select query).
After creating the HANA attribute view we cannot yet access this directly from ABAP. This is only possible using native SQL. In ABAP 7.4 however, you can create a Data Dictionary (DDIC) View on a HANA view which is only available in ABAP Development Tools!
This DDIC View is directly accessible through ABAP queries or via any ABAP for HANA artifact e.g. the ALV. So in our report, we use this DDIC View in an ALV for HANA (IDA ALV). We’ve already created a screen with a Container component called “CC_ALV”. As you can see, we’ve been also using the new syntax of ABAP7.4 .
Flexso presented this methodology at SAPience Belgium 2013, SAP Teched Amsterdam 2013 (session TEC207) and SAP Insider Track NL 2013.
SAP HANA Studio
And the movie ;-):