Extract data from z-table in a R/3 system to another Z-table

Question: I want to extract data from one Z-table in a R/3 system into another
Z-Table in another R/3 system.

Please advice the best FM or method of extracting the data from one
R/3 system and loading to the other.

Thanks
ABAPNewbie

Answer:
What abt the structures of these tables.. if the stucture in both systems is same.. there are 2 ways.

1. If RFC connection is steup between these systems, write a small program in the target system and use FM RFC_READ_TABLE to read data from source system, and update the table in target system.

2. If RFC connection is not there, write a program in source system to download entire table's data into a flat file, another program in target system to read this flat file and update the table there.

If the structures are not same, the options you have are still the same, only difference is that you'll have to write a little conversion logic also.

Regards
Sudhir/Mohit

Answer:
TwoAbapers

Many thanks I want to find out the number of records in a z - table in the remote system.

How can I find the number of records in the remote system z-table is there a FM for this.

Thanks
AbapNewBie

Answer:
You could create a transport which would contain the table and it's contents, and then import the transport to the new system.

For getting a record count, I'm unaware of any FM, but you could write your own RFC-enabled FM fairly easily, or just log onto the other system and check the count.
Copyright ?2007 - 2008 www.jt77.com