Skip to Content
0

Data Migration to S/4 HANA using DS

Dec 12, 2016 at 09:23 AM

280

avatar image

Dear Experts

I am involved in S/4 HANA implementation project where there is huge volume of data needs to be migrated from CSV files. We are using SAP DS for data load and also using RDS package.

But the issue is that RDS used IDOC approach very huge volume of data like more that 3 millions will create unnecessary IDOC's. To avoid IDOC creation we developed fully custom based ZRFC for material master upload. Now the questions are

1) Since its a HANA DB as backend connecting to application layer wont be much improvement in performance. Since the business validation is happening at application layer so real push down of data will not happen.

2) Is there any other approach of data migration without connecting to the application layer connecting to direct DB layer

3) Like BAPI/ FM is there SQL script based functions or procedures to do the validation in the DB layer and load the data into HANA tables like the way how BAPI is loading into tables. Same or similar functionality or approach.

Let me know any one though in that direction or any inputs will be helpful.

Thanks and Regards

Vijay

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dirk Venken
Dec 13, 2016 at 11:12 AM
0

Technically it's possible to write directly into the tables of any HANA-based target system.

But how are you going to guarantee consistency while bypassing the S/4HANA application layer?

Share
10 |10000 characters needed characters left characters exceeded
Vijayakumar Mukunthan Dec 15, 2016 at 02:37 AM
0

Hi Dirk

I know technically possible to connect to HANA DB layer. I want some kind of SQL procedures or functions which does the operations of BAPI. I don't want to take the risk of update direct tables which will create inconsistency. That is why I am asking any similar kind of functions available at SQL scripts which does the same functions of BAPI.

Customers are started asking the question if this is a HANA DB where SAP says its performs lighting speed why its is taking 5 to 8 hrs of data load ?.

If DS is connected at application layer even if its a HANA DB we cannot achieve lighting speed because not all the BAPI's are doing push down to DB layer. Especially material master which uses the same old BAPI not doing the push down.

So kindly suggest me way for this.

Thanks and Regards

Vijay

Share
10 |10000 characters needed characters left characters exceeded