Extract ECC

[jazcruz]

We have a requirement to extract the data from SAP ECC , which involves multiple tables involved in it around 10 tables and also involve loop logic from one table to another. What is the best approach to perform this ?

Is there any other way beyond ABAP program? I mean can we write SQL without installing any other tool?

Note : Client doesn't allow any external tools like BODS and all. Because they are going to decommission SAP soon . 

[nachtaktiv]

why do you want to write an ABAP program if you are using BW to extract from ECC ?

[jazcruz]

The client will not use BW or any other extraction tool. Its just ECC from where they want to extract the data and download it in csv file.

[nachtaktiv]

within the transaction DBACOCKPIT you can use the "SQL Editor"

[mamartins]

I would say that the best approach will be the native DBMS tool. Almost every DBMS engine have a tool to export data, examples:

• MSSQL: bcp and SQL Server Import and Export Wizard
• ORACLE: data pump

[bjansen]

ODBC connection to the database

[jazcruz]

o use DB. But I can’t use DB since, its risky. I can only access SAP ECC systems not DB.