cancel
Showing results for 
Search instead for 
Did you mean: 

How to transfer SAP add-ons tables quickly?

former_member211576
Contributor
0 Kudos

Hi experts,

I want to transfer data in our customized tables(hundreds) from R3 4.6C(MSSQL2000) to ECC 6(MSSQL2005) quickly?

1. bcp: could I assign the formatfile and put all tables into a batch file?

2. DTS/SSIS: a lot of trouble here, schema problem, objects already exists...

3. R3trans??

4. LSMW??

Please give me a easy to use and quickly method, thx.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI,

for customer specific tables only ( i.e Z or Y table)

you need to create workbench request for transporting table and it's value.

before transporting these tables you must transport the data types and domain ( y/z ) used in these table.

after that create the workbench request using SE10 as following

for transporting table

Program ID: R3TR

Object type : TABL

object : ztable

for transporting values of table

Program ID: R3TR

Object type : TABU

object : ztable

click on key field and add * to first raw.

release the request.

import the request on target system

if you want to use R3TRANS check Note 1942 - How does R3trans work?

if you are going for standard table check following

SAP reports when doing transports between different R/3 releases.

SAP Notes 126776 and 330267.

regards,

kaushal

Edited by: kaushal malavia on Apr 23, 2008 2:15 PM

Answers (0)