topic Re: Data table in Application Development and Automation Discussions

Data table

Former Member — Tue, 24 Oct 2006 20:34:22 GMT

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?

Re: Data table

RichHeilman — Tue, 24 Oct 2006 20:40:07 GMT

Tables are client independent, so the table itself should already exists in the other clients, you simply need to copy the data from the one client to the others. You can do this with a simple ABAP program.

Regards,

Rich Heilman

Re: Data table

Former Member — Tue, 24 Oct 2006 20:47:20 GMT

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

Re: Data table

Former Member — Tue, 24 Oct 2006 20:52:49 GMT

Both the clients are in different systems like one is in CRM and another r/3.

Re: Data table

Former Member — Wed, 25 Oct 2006 20:22:18 GMT

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

Re: Data table

TuncayKaraca — Wed, 25 Oct 2006 21:09:08 GMT

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).

Re: Data table

TuncayKaraca — Wed, 25 Oct 2006 21:13:21 GMT

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.