topic Re: ABAP Code Remediation in Application Development and Automation Discussions

ABAP Code Remediation

former_member191728 — Wed, 05 Apr 2017 04:50:07 GMT

Hi Experts,

As we know we need to do ABAP Code Remediation activities when migrating to HANA Database.

We use standard tools like SCI, ATC and SQLM for this

But my question is when should we actually start doing the ABAP Code Remediation activities.

I.e. after the system is migrated to HANA Database

On you current non-HANA Database.

What will be best approach before migration or after migration

Re: ABAP Code Remediation

retired_member — Wed, 05 Apr 2017 06:25:27 GMT

Since most of the cleanups recommended before moving to HANA will improve your code on any platform (it is always a good idea to replace nested SELECT loops with joins or subqueries ...), I'd say start as soon as possible.

Re: ABAP Code Remediation

matt — Wed, 05 Apr 2017 11:14:59 GMT

What Horst said...

I've been involved in a few HANA upgrades. You do everything you can upfront. Then you upgrade, and see what's broken. Then fix that. Performance monitoring is particularly important after upgrade, as some SQL is pathologically bad for HANA - i.e. it runs acceptably on Oracle (for example) but not optimally, and then collapses in a wobbly heap under HANA.

Re: ABAP Code Remediation

roberto_vacca2 — Wed, 05 Apr 2017 12:33:21 GMT

It depends on your environment.

If your company has an high-level attention on performance and security issues you should monitorize from st12, tracing your reports that actually are most consuming resources reports.

Queries will probably need a revisit (SQ01/SQ02). You'll need to regenerate query and stuff like that. Most of reports will still work.

Reports with SQL direct instructions must be reviewed. Pay attention to your Z*table. Most of table will be column oriented in HANA, and you'll probably need to review someones with big dimension. If production system comes up with a well powered hardware, you'll not probably notice any changes. Some standard changed, so trace all forced INSERT/MODIFY/DELETE to standard. Choose enhancement option instead.

For other tips, you'll need to find your solutions. Every company has different needs.

Hope to help Bye

Re: ABAP Code Remediation

Armin_Beil — Thu, 06 Apr 2017 06:45:22 GMT

Additionally to the good answers that have already been given I'd like to provide a link to this blog:

ABAP Custom Code Adaption for SAP HANA

It also contains a high level step by step procedure.

Best regards,
Armin