Data-export from several tables by ABAP/SQL-script

[former_member1365898]

Hello experts,

how can I export data from several SAP tables and structures through "ABAP+SQL-Scripting" based on database Oracle as back-ende-DBMS and export results to and external text-file?

Thank you and best regards,

Val.

[Former Member · Accepted solution]

Hi Wahid,

If you 're planning to export/import table data and structure from one sap system to other than the simplest way would be via transport request.

But if you're planing to export/import table data and structure from one Oracle Db to another Oracle DB you nned to do it at DB level using exp & imp sql command

E.g.:

Export:

exp owner/password FILE=tableData.dmp tables=owner.table1,owner.table2, owner.table3 log=tableExportlog.log indexes=Y grants=Y

Import:

imp owner/password FILE=tableData.dmp tables=table1,table2, owner.table3 log=tableImportLog.log buffer=1024000 grants=Y indexes=Y

OR

Use BR*Tools

Export/Import - SAP Database Guide: Oracle - SAP Library

Regards,

Prithviraj.

[former_member1365898 · Accepted solution]

Hi Prithviraj,

the main problem is the extension of an erp structure and export that to a text file. I think the best way is infoset query. Is it the right way?

Regards,

Val.