Data Migration to S/4 HANA using DS

[vijy_mukunthan]

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

[vijy_mukunthan]

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

[former_member187605]

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?