Exporting and importing table using R3trans program between 2 clients

[Former Member]

Hi,

How to export and import a table between to clients in a same system using R3trans program?

I need to copy a table from Client 020 in a system to client 040 of the same system using R3 trans. I need to know the procedure.

Can any one advice

Regards,

Suresh

[former_member199963]

Yes, this is very helpful for doing RFC's export and import. We had a request to rebuild a system so used this method to export the RFCs and import them on completion of installation.

Thanks,

Asad

[Former Member]

hi,

If we are exporting big tables like 100 million rows of tables , are there any tips to make it import faster...

any commit or parallel commands?

Please suggest..

[Former Member]

Does Parallel = 4 will work if we add the same in export and import.ctl files?

Please suggest.

Thanks,

Subhash.G

[Former Member]

Please also check if proper indexes are there for table.

[Former Member]

As far as I know parallel = n is used while importing transport requests and during upgrades etc. and this parameter is specifically designed for that,

May be you can give a try.

[Former Member]

Hi Suresh,

we use R3trans for copying tables in exceptional cases only.

Please go thru following link.

http://help.sap.com/saphelp_47x200/helpdata/en/3d/ad5c514ebc11d182bf0000e829fbfe/frameset.htm

hope this is helpful

Thank you

PS : Award points if helpful

[Former Member]

This is how you do a export and import of table entries.

Export:

Open Notepad and type the following,

export

client = 020

file = 'clone.export.<sid>.<client no>.data'

select * from <client_dependent_tablename1>

select * from <client_dependent_tablename2>

........................................

........................................

select * from <client_dependent_tablenamen>

Save the file as export.ctl

Run R3trans export.ctl

and the data of these files will be stored in a file called clone.export.<sid>.data in the directory from which you have called R3trans

Import:

Open Notepad,

import

client = 040

file = clone.export.<sid>.<client no>.data

buffersync = yes

Save the file as import.ctl

Run R3trans import.ctl

Cheers!

Bidwan

Message was edited by:

Bidwan Baruah

[ivar_hovik]

Very nice "how to"

Thanks

[Former Member]

Hi Suresh,

Tables are at data dictionary level.Once you create table it can be

used by every client in the system.It is a data dictonary object so it is

client independent.There is no need to copy the table.

Reward points if help full!!!

Regards,

Vamshi

[Former Member]

Hi,

Why dont you do it using tocde SCC1...Its can be used for transports between clients with the same system.

• Reward Points for helpful answers.

Regards,

Prashant

[Former Member]

Hi Prashant,

I will not be able (not in a position) to create a transport request in this case. That is why I want to do it using R3trans.

Regards,

Suresh