Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP role during Oracle to HANA DB migration

ricky_shaw
Contributor
0 Kudos

Hi,

1) What is the role of an ABAP programmer during Oracle to SAP HANA database migration?

2) What are the code changes needed to existing ABAP programs when migrating from premise to On cloud?

For example: i heard that select singles will not work in cloud and we need to use some alternatives..etc

I am aware of the SPAU & SPDD transactions during Ehp pack upgrade.

Any suggestions please.

6 REPLIES 6

FredericGirod
Active Contributor
0 Kudos

You have ATC variant for S/4 upgrade :

https://blogs.sap.com/2019/06/25/custom-code-adaptation-for-sap-s4hana-faq/

but from Oracle to Hana, the only point for me is the implicit SORT used in Oracle doesn't exist in HANA (the result will not be sorted by the table keys)

FredericGirod
Active Contributor
0 Kudos

You could check also in specific code if somebody use HINT :

https://help.sap.com/doc/abapdocu_753_index_htm/7.53/en-US/abenosql_db_hints.htm

matt
Active Contributor

frdric.girod There is no implicit SORT used in Oracle either. (Or any ERP really).

https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_10002.htm

Use the ORDER BY clause to order rows returned by the statement. Without an order_by_clause, no guarantee exists that the same query executed more than once will retrieve rows in the same order.

I've seen it happen that a program that worked for years in Oracle which assumed that the table was in primary key order suddenly stopped working because there was no ORDER BY.

With HANA it's just far more likely that you won't get records back in the same order they were stored.

FredericGirod
Active Contributor

matthew.billingham it is amazing the number of ABAP program, even standard, assuming this sort.

ricky_shaw
Contributor
0 Kudos

Apart from Sort conditions, are there any select stsmts that do not work on S/4 HANA Cloud ?

ricky_shaw
Contributor
0 Kudos

Hi, I also see that select single * does not work in the new HANA based system.

Can anyone suggest such kind of obstacles faced during migration to HANA?