Skip to Content
avatar image
-1
Former Member

how to tweek select query from normal abap to abap with hana db

am new to sap hana development and my requirement is ,

i am to fetching data from HRP tables , where the internal table is being filled with 90K records.

the select query is based on obj type and plan version, beging date and end date .

these are the possible conditions which i can give in WHERE condition in SELECT query .

it is taking lot of time to fetch the records. Recently we have been upgraded our DB to HANA DB . How can i use the HANA here ? what is that i need to do on SELECT Query so that it fetches in less time.

Also to get the text am doing FAE in HRT Tables, Processing this is also taking time.

Can you suggest any thing on this too ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 25, 2017 at 10:16 AM

    In fact a standard ABAP SELECT is simply transmitted by the DBI to the HANA DB almost unchanged. You can see in ST05 how it looks there. If it is only a single SELECT and there are lots of data you cannot expect any performance gain compared to coding it directly on HANA.

    The idea of code push down is more about transferring complex multiple selections and other processes to the DB in order to get rid of unnecessary round trips. E.g. doing calculations in DB functions instead of ABAP function modules. You can do such code push down directly in Open SQL (joins, unions, expressions, functions, common table expressions, ...) or model it in ABAP CDS.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 07:22 PM

    Hi Prathap,

    If you are new to SAP Hana development, i think, first, you can check this link https://blogs.saphana.com/2012/09/07/sap-hana-for-beginners/

    You will have to install SAP Hana Studio or Eclipse IDE(down all components refer to SAP Hana), but the most important after below recommends, is always keep ABAP Code Optimization for SAP HANA. For that you can check differents documents that could help you.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 10:55 PM

    There are so many resources on this, please search the SAP Community (Blogs, Documents PDF, etc.) ...

    In my opinion, a good starting point would be the BlogPost "ABAP custom code adaptation for SAP HANA – The efficient way" ...

    Add comment
    10|10000 characters needed characters exceeded