Ztable update

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks Guys.

Ster

[Former Member]

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

[GrahamRobbo]

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