on 03-11-2011 6:10 AM
Hi,
i want to transfer some SAP table data for e.g Material management related data to another database.
is there any way to accomplish this task or exporting data to file?
Thanks,
Arati
I personally like Oracle Export and Import tool.
1. To export T000 table,
C:\oracle\R3L\112\BIN>exp SAPR4L/123456 file=emp.dmp log=emp.log tables=T000 r
ows=yes indexes=yes
2. To import T000 table into target database,
imp SAPRZL/tiger file=emp.dmp fromuser=SAPRZL touser=SAPRZL tables=T000
Also this is very quick as large table might take longer time.
You also use brtools for this if your database if Oracle.
Regards
SM
Edited by: Sri on Mar 19, 2011 6:17 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a workbench transport request in SE09 and double click on it, system opens request/task screen , go to objects tab add program id as 'R3TR' object type as 'TABU' object name as table name (ex: ZTABLE) and click on the function button , put '*' in table keys and save the request.
Transport this request as you transport any other request, table entries will be transported .
Or,
[http://www.sap-basis-abap.com/sapbs046.htm]
Note 1942 - How does R3trans work?
Regards
Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.