10-24-2006 9:34 PM
I need to create same table similar to a one in another client with all the data.Is there some easy method of transfering data from one table to another between 2 clients?
10-24-2006 9:47 PM
Hi bharat
In target client write a program with the following statement.
select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '<Source client>'
for ex
if src client is 001
and target client is 002
then in 002 write
select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '001'.
use CLIENT SPECIFIED along with your update/modify/insert statements to be able to update target client table from source client.
Please check that both of the clients should be in smae applicn server
Regards
Naresh
10-24-2006 9:40 PM
10-24-2006 9:47 PM
Hi bharat
In target client write a program with the following statement.
select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '<Source client>'
for ex
if src client is 001
and target client is 002
then in 002 write
select * from <dbtablename> CLIENT SPECIFIED into table itab1 where mandt = '001'.
use CLIENT SPECIFIED along with your update/modify/insert statements to be able to update target client table from source client.
Please check that both of the clients should be in smae applicn server
Regards
Naresh
10-24-2006 9:52 PM
Both the clients are in different systems like one is in CRM and another r/3.
10-25-2006 10:09 PM
If you don't mind transport table content with transport requests, there are several forum topics about that.
Basically this one helps you:
1. Goto SE01.
2. Click New and create a New Work Bench Request.
3. Then place the cursor on the TR and click on Display Object List ( Shift + F11 )
4. Enter PGMID as R3TR
5. Enter OBJ as TABU
6. Enter OBJECT NAME as Z<TABLE NAME>
7. Again in the menu, select 'Extras>Change object function>Key according to key list'.
Now go to the menu, 'Goto-->Key list'. In the subsequent screen, click on 'Insert line' icon(with a + sign).
10-25-2006 10:13 PM
If you choose write a program to transfer data from one SAP system (e.g. R/3) to another SAP System (e.g. CRM) maybe you might need to do that frequently, you have to setup RFC connection between SAP systems then you can write a RFC enabled function module to select and update the data, so you can call this function module from other SAP system.
10-25-2006 9:22 PM
Then if is entirely different system...
Then you probably have to manually create the table in the target system..
Then write a program to insert the values...
Thanks,
Naren