topic Re: program for migration of data in Application Development and Automation Discussions

program for migration of data

Former Member — Mon, 19 Nov 2007 10:01:58 GMT

Hello All,

I need to move certain amount of data that is present in SAP APO to R/3. Both are on different servers. What is the knid of programming needed to be done on the APO side. Can anyone give me a sample program done in a similar situation.

Points assured for all helpful answers.

Regards,

Seenu

Re: program for migration of data

Former Member — Mon, 19 Nov 2007 10:24:07 GMT

Hi Seenu,

You can use ALE/IDOC or BAPIs to transfer data from APO to R/3. You cal also use a middleware like XI.

Regards,

Satish

Re: program for migration of data

Former Member — Mon, 19 Nov 2007 10:32:49 GMT

Hi Seenu,

If both the servers have the same application layer then you will have to write 2 programs one in Server A (Source) and other in Server B (Target).

Write program in source server to move the data to application server using OPEN DATASET <filename> FOR OUTPUTand CLOSE DATASET.

Similarly write a program in target server to retreive data from application layer using OPEN DATASET <filename> FOR INPUT.

In case the application server is different then you will have to use GUI_DOWNLOAD to download the data to presentation server and then use GUI_UPLOAD to upload the data to target server.

If you want to transfer transactional data like SALES ORDER or PURCHASE ORDERS then you will have to use BAPI's to do the same.

Hope it helps.

Lokesh Aggarwal

Re: program for migration of data

Former Member — Mon, 19 Nov 2007 10:42:36 GMT

Hi Seenu

Please also explore the possibilibility of using the CIF ... (Core Interface) for APO<->R/3

<a href="/people/somnath.manna/blog/2006/12/31/demystifying-cif--part-ii:///people/somnath.manna/blog/2006/12/31/demystifying-cif--part-ii

Regards

Arun

Re: program for migration of data

Former Member — Mon, 19 Nov 2007 12:37:34 GMT

Hello Arun,

Thanks for ur reply. But there is a problem in using CIF. Since setup groups are master data, they are unidirectional i.e R/3 to APO but not vice versa.

Any other thoughts. Is there any BAPI???

Regards,

Seenu