on 04-23-2008 9:21 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.