Data Migration on HANA Simple Finance

[vijy_mukunthan]

Hi Experts

We have a requirement that one our customer they are implementing SAP HANA Simple Finance. We will get the data in some sort of files. How to load these data into SAP HANA. Will there be LSMW programs to load the data or we have to exclusively use BODS to upload the data using IDOC’s or BAPI?. Let me know how to start the migration activities.

  Currently we are installing PoC system to show to the customer. What all the steps to be followed for Simple Finance data migaration?.

Regards

Vijay Mukunthan

[former_member254877 · Accepted solution]

Hi Vijay -

if the data comes in Flat file, then use the Import option in HANA studio to load the files into HANA DB.

You can use BODS as well to load the data into HANA DB.

BAPI & IDOCS exclusively used for to update data into  ECC & APO..etc other environments other than BW & HANA.

Hope this helps.

[vijy_mukunthan · Accepted solution]

Hi Srinivas

  Then how the actual update will happen. Do i need to write special code for updating the tables?. How system will know which tables to be updated. If i use IDOC or BAPI system will take care of update. How i know what all the tables involved?.

Regards

Vijay Mukunthan

[former_member254877 · Accepted solution]

Hi Vijay -

You don't have to write the code to update tables, while importing File it will ask you the Table name and the structure.

you wouldn't be able to use IDOC or BAPI to update data in SAP HANA system.

All this you need to do through SAP HANA Studio where we do all the modeling & views creation..etc

Hope this helps.

[former_member187605 · Accepted solution]

I am sorry but I don't think that this answer addresses the question. SAP HANA Simple Finance is part of SAP S/4, the new generation business suite. So the question is not about how to load data into SAP HANA, but how to do that in S/4. Correct?

You might want to post your question in

[vijy_mukunthan · Accepted solution]

Hi Drik

  My intention is what all the techniques to load the data into HANA platform. As i am coming from traditional data migration for ECC R/3 i not aware of how to load the data into HANA. In R/3 any migration objects like material master, customer master, vendor master, G/L master we should not update the tables directly. In HANA its opposite to R/3 where tables has to be directly updated. This means i should know all the relevant tables for the particular object. This is what my confusion. How to address this.

Regards

Vijay Mukunthan

[former_member187605 · Accepted solution]

Loading data into HANA is not different from loading data into any other database type (except for the incredible loading speed, of course).

Loading data into ECC on HANA is not different from loading data into ECC on Oracle, DB/2, SQL Server (expert for the speed, again).

[ranadev_banerjee_sap · Accepted solution]

Hello Dirk,

Thanks for this answer. I am also having similar doubt since I am new to HANA. We are going to implement ECC on HANA. For this can we use conventional data migration approach like IDOC, BAPI, BDC etc?

Thanks in advance.

Best Regards,

Ranadev

[former_member187605 · Accepted solution]

Yes. In fact, there's predefined content in the mean time for loading data into S4/HANA, using IDOC and BAPI. See SAP Note 2239701 - SAP Rapid Data Migration for SAP S/4HANA for download instructions.

[Former Member]

Thank you Vijaya

[vijy_mukunthan]

Dear Dirk

  We have successfully go live on S/4 HANA for one our customer with data migration techniques like LSMW and IDOC methods.

  This to every one for better clarity.

The loading technique is same as ECC like LSMW direct input methods, BAPI and IDOC method with same traditional screens and transactions code only advantage is high speed.

Thanks and Regards

[Former Member]

Hi Vijay, I am working on Migration from ECC to HANA(Simple finance), did you used RDS for your migration,if yes did you use BAPI or IDOC in RDS, if you have used BAPI or IDOC which one is better and why ?

[former_member187605]

Check for a discussion on this topic.

[vijy_mukunthan]

Hi Uhdam

  We did NOT use BODS itself for simple finance. We use LSMW technique to load the data. We used all sort loading technique like Direct input, IDOC and also BAPI. In our case the volume is less we cannot compare the time taken via IDOC or BAPI.

The suggestion would be if huge volume of data is involved not adviced by IDOC. Go with BAPI where the performance would be much better. If less volume of data then you can use RDS package delivered by SAP which is using IDOC method. Its plug and Play type.

Now its you choice which solution to be implemented.

Thanks and Regards

Vijay