cancel
Showing results for 
Search instead for 
Did you mean: 

using r3trans to copy client dependent tables from one client to another

Former Member
0 Kudos

Hi,

If you use r3trans to export a table from one client and then import to another client on the same SID, what happens to the table contents that exist prior to the import? In other words, are the import table contents overwritten or appended?

Any help is greatly appreciated.

Best Regards,

Rick Taylor

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

This depends on how you configured your control file used by R3TRANS during export.

if it contains DELETE *, then the previous contents for your client is deleted before import.

Former Member
0 Kudos

Hi Eric,

Thank you for your response. My export control file looks like the below illustration.

export

client=010

file='ESS_tables.dat'

select * from T7XSSSERSRV where mandt='010'

select * from T7XSSSERSRVT where mandt='010'

select * from T7XSSSERSRVCG where mandt='010'

So if I put DELTEE * after the file entry, will this insure the delete of all content of the data that is relevent to client 010 before importing?

Best Regards,

Rick Taylor

former_member204746
Active Contributor
0 Kudos

if you get this:

export

client=010

file='ESS_tables.dat'

delete * from T7XSSSERSRV

select * from T7XSSSERSRV

during export, it will export T7XSSSERSRV from client 010 but also it will put deletion commands into your exported file. deletion ONLY occurs when importing, it DOES NOT delete in your source system during export.

so, yes, with delete * appearing BEFORE select, it will delete old client 010 data from table T7XSSSERSRV.

refer to SAP Note 1942 - How does R3trans work?

and also read SAP note 130906 to get an idea.

good luck.

Former Member
0 Kudos

Eric,

That answeres my question. Thank you very much!

Best Regards,

Rick

Answers (0)