T-codes to SAP HANA

[Former Member]

Hi Experts,

How do we identify which T-code need to be ,moved to SAP HANA as part of either Standard ERP Accelerators or custom ERP accelerators. Any help in this regards would be appriciated.

Regards

Nilesh Awaghan

[sagarjoshi · Accepted solution]

Hi Nilesh,

Identifying T-Codes and pieces of code blocks that needs to pushed down or optimized for HANA is not a very easy or trivial tasks.

To start with

• Check the transactions based on usage analysis reports which are long running (data like early watch data with usage and frequency analysis). You can also use data from STAD,SAT ..etc to identify this kind of information
• Do detailed SQL tracing like ST05 to check DB information
  
• Identify if the bottlenecks are due to Application server coding or DB Selects (e.g. SELECT SINGLE kind of statements in a loop)
  
• Check if your transactions are doing any calculations by looping on large internal tables after data fetch that can be done in Set Oriented way like aggregation & Grouping (e.g. ABAP COLLECT statements)
• Find out typical candidates which process large amount of table accesses but finally shows very small no. of rows to end user

If you do some of the steps above then you get good candidates to build custom procedures and HANA content views to achieve push down of ABAP code to HANA.

Hope this helps to start with your research.

Thanks,

Sagar