32 - ABAP Programming - Best Performance Guidelines Part2

Best Performance Guidelines Covered-
-Never use corresponding in the query.
-For traditional databases avoid using JOIN, use FOR ALL ENTRIES IN.

[@Rajasekharabap]

If it is hana db the performance of innerjoin or for all entries same Which one u prefer in hana database? If interviewer ask how to answer this sir can u pls tell

[@sapabapbyrahulmehta]

We prefer join as HANA is in-memory database.

[@prakashkarri7789]

Can you tell the ABAP version in which you are writing the code and is this ECC or S4 Hana system?

[@sapabapbyrahulmehta]

Hello Prakash - Some videos, I prepared through ECC system and some through S/4 HANA system, but from ABAP perspective, it does not matter as we can write logic in any system. If you want to work on ABAP on HANA objects like - CDS, AMDP then you require SOH(SAP Business Suite on HANA) or S/4 HANA(SAP Business Suite for HANA) system.

[@prakashkarri7789]

@@sapabapbyrahulmehta thanks for the reply Rahul, your teachings are great and very useful thanks for the classes and can you please post a detailed video on SAP ABAPER road map like what are best and need to learn modules or technologies to sustain in current and future market and what should be the path from where to where he need to learn and what are the upskills he need to do for the same.