Sunday, July 10, 2011

Table export import with R3trans directly from OS level

For exporting the tables:

command :

R3trans -w exp.log exp.ctl

example of exp.ctl:

export

client = 200

file = '/usr/sap/trans/data/export.dat'

select * from COEP

select * from BSIS
select * from ACCTCR
select * from COEP
select * from BALDAT
select * from MLIT
select * from MLPP
select * from MSEG
select * from MSTA
select * from NAST

select * from ONR0

select * from S033

select * from S700
select * from FAGLFLEXA
select * from CKIS
select * from KEKO




For importing the same table(s)

command :

R3trans -w imp.log imp.ctl

example of imp.ctl file :

import

file = '/usr/sap/trans/data/export.dat'

client = 200

No comments: