Transferring large volume of data from SAP ECC to SAP XMII

[Former Member]

Hi all,

What will be the best method to transfer large volume of data from SAP ECC to SAP XMII. We need to transfer the batch and inventory details from SAP ECC to Oracle using XMII. The data size ranges upto 2 millon. Which method of communication(BAPI/IDOC/Web Services) will provide the optimum performance? Also kindly let know some ideas of transferring this large volume to XMII.

Thanks

[Former Member · Accepted solution]

If you must use MII for this, set up some kind of cursor type logic.

For example get 10 records, then get next 10 records greater than last record etc.. and loop till finished.

This is similar to what we do when writing custom BI extractors.

I would only recomend this for an inital load situation.

If you have to move this much data often then search the forum for some other solutions that could fit your needs.

[agentry_src · Accepted solution]

Senthil,

You may be better off doing an export to file of the data from within SAP and doing a manual file import/load in Oracle. If this is expected to be done on a regular basis, you need to investigate using Change Pointers in SAP and use IDocs to download the data. The Change Pointers will allow to download only those records which have changed since the last download and thus limit your volume to something reasonable.

Regards,

Mike

[Former Member · Accepted solution]

Thanks for your inputs.

In the IDoc mode of communication, is there any way in which we could limit the number of data to be transferred during Initial Download. In Delata only the changed fields will be transferred but in Initial is there a way to restrict amount of data.

[agentry_src · Accepted solution]

I am quite sure you can limit it on the ERP side. If you were doing a manual download, you would simply use a limit based upon material number, plant, order number, etc. If you were triggering it from MII, then you could probably use some programmatic method. If you decide to go the programmatic MII route, there is, I believe, a template which is used to trigger the downloads and set the parameters. If you can't find it or it does not address all your IDoc types, let me know and I can help with that as well.

I still think a direct load from exported table files is the most efficient, but in production, that may not be allowed.

Good luck,

Mike