Skip to Content
0

SAP BODS or SAP PI?

Nov 03, 2017 at 07:09 PM

70

avatar image
Former Member

Hello Experts,

I seek your opinion on one of the critical scenario we are facing in our project. The requirement is to migrate 3.5 million purchase info records (PIR) from SAP ECC 6.0 to SAP S4HANA 1710. Now we have two options:

1- Go by BODS and load 3.5 million idocs.

2- Go by PI. Anyways interfaces are going to build to support post go live replication.

Now question is what should be the preferred way? Can BODS handle 3.5 million idocs creation or PI is suitable to do an initial load of such volumes?

Note: Its almost one is to one mapping with no other transformation logic required.

Regards.

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

2 Answers

Tammy Powlas
Nov 03, 2017 at 08:06 PM
0

Data Services is great for migration; it can handle 3.5 million records

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Nov 06, 2017 at 12:09 PM
0

Data Services will be the best ETL tool to migrate the SAP ECC data to HANA Database. You may refer the SAP Supplement Guide which can be useful.

SAP Supplement Guide

Regards

Arun Sasi

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your response.

The problem here is we need to read the long text for those PIR as well and using /BODS/READ_TEXT function is very very slow like 20-25K records per hour. How can we handle 3.5 million record extraction along with long text?

Regards

0

Arvind,

If you are reading Long text then you can use the long_to_varchar(). Kindly refer to the Data Services Reference Guide. Also use ABAp Data flows for faster execution.

Regards

Arun Sasi

0

Arvind, you can use long_to_varchar() function to convert the long text to varchar. Also you can use ABAP Data flow for data extraction from big tables.

Regards

Arun Sasi

0