on 08-12-2010 4:51 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.