Intro

Sometimes you want to quickly export a few tables from a SAP Netweaver ABAP system, to copy them to another system.

My use case was to export tables prior to a system copy (for example SECSTORE related tables) and reimport them after the refresh. Since we had SAP installed on different database softwares, I wanted to have a single procedure, as it’s easier to maintain.

Another use case is when you need to copy a few tables from one database system to another, running a different database software.

You can also use this method to copy tables from one client to another.

The source documentation from SAP is located there, in case you want to use some advanced options from R3trans:

Export

Here is an example of control file to export SICF info. You should name this file “sicf_exp.ctl”. It is also possible to specify client=ALL if you want to export from all clients at once.

export
client=100
file='sicf.dat'
select * from ICFSERVLOC
select * from ICFSECPASSWD
select * from ICFDOCU
select * from ICFSERVICE
select * from ICFBUFFER
select * from ICFDELTA
select * from ICFHANDLER
select * from ICFHANDTREE
select * from ICFIMPORT
select * from ICFLOGORDER
select * from ICFNOHANDLER
select * from ICFVIRHOST
select * from SHMSERVICE

Then run the export

R3trans -w sicf_exp.log sicf_exp.ctl

Import

We’ll use the following control file “sicf_imp.ctl”. You can remove the line “client=…” to import to the same client(s) as the one(s) where the export was made.

import
client=100
file='sicf.dat'

Then run the import

R3trans -w sicf_imp.log sicf_imp.ctl