topic Re: Ztable update in Application Development and Automation Discussions

Ztable update

Former Member — Wed, 09 Apr 2008 19:27:26 GMT

Hello friends,

I have 2 SAP systems and need to copy data from a Z table from one system to a different system.

How would we do that.

Writing a Z program is my last option..any other methods?

Thanks,

Ster

Re: Ztable update

Former Member — Wed, 09 Apr 2008 19:32:09 GMT

HI,

Can be done by sending a IDoc and again need upload program or FM .

Simple method is copy all data in Excel Sheet.

Then write a simple upload program from excel to data base table..

You find the program in internet or in SDN also

Regards

Syed A

Re: Ztable update

Former Member — Wed, 09 Apr 2008 19:37:58 GMT

Question you should ask urself:

Is a transport route configures b/t them?? If yes then you simply have to transport the entries. If not then are these servers connected through LAN or WAN? If yes then you have to write an rfc..to extract data ....else simply download all the entries in an excel sheet and then upload it programatically to ur data base. For downloading ..after having all ur entries displayed..From menu options choose table entry>list>export>spread-sheet

Re: Ztable update

Former Member — Wed, 09 Apr 2008 19:48:26 GMT

Thanks Guys.

Ster

Re: Ztable update

Former Member — Wed, 09 Apr 2008 21:00:55 GMT

Hi,

You can create RFC function module in the system where the data is existing and then call this function module from other system and get the data and update it in that system.

Thanks,

Srinivas

Re: Ztable update

GrahamRobbo — Wed, 09 Apr 2008 23:39:46 GMT

Hi Ster,

do you need to do this regularly or is this a one off?

If you want to do it regularly there is a way you can directly access external databases from ABAP using Native SQL.

The technique is called DB Multiconnect. Essentially it means you can have both your default SAP database and the database of the remote SAP system open at the same time in the same SAP Program. You can then easily read and write data to both.

Look here for some documentation that referes to the OSS notes for each database platform.

http://help.sap.com/saphelp_nw04/helpdata/en/50/63d6b37bda7f4a92e2dec21b14ceee/content.htm

Cheers

Graham Robbo