transfer or export sap table data

[Former Member]

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

[Former Member]

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

[sivakumar_kilari3]

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.

[Former Member]

Hi ,

Thanks for your response.

But I want to transfer table data to non sap system (another database). is it possible to export data to non sap system?

[sunny_pahuja2]

Hi,

Non-sap database and SAP database both are same ?

Thanks

Sunny

[sivakumar_kilari3]

Non SAP system means? Which application or database you want transfer?

Regards,

Siva

[Former Member]

Hi,

if you are still looking for an Option to export data from SAP tables or quick views to any database with ODBC driver you may have a look at t3cp. (t3cp.csbg.biz).

C.