Question Re: Data Extraction from SAP ECC using Multiple tables in Technology Q&A

Data Extraction from SAP ECC using Multiple tables

Itishri — Tue, 06 May 2025 21:39:15 GMT

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 . They don't want to use SAP BW or BODS. They want us to just extract the data from multiple tables like Vendor data from LFA1, LFBW,LFB1,LFM1,ADRC,ADR6 and LFBK. table.

This is the first time i am posting the question. apologies if i tagged someone wrongly.

Re: Data Extraction from SAP ECC using Multiple tables

junwu — Tue, 06 May 2025 22:50:05 GMT

don't know what problem you have.....

Re: Data Extraction from SAP ECC using Multiple tables

Itishri — Tue, 06 May 2025 22:55:48 GMT

Hi @junwu - I am trying to understand what is the best approach to extract data in from multiple SAP ECC tables in to CSV format

Re: Data Extraction from SAP ECC using Multiple tables

BC_admin — Wed, 07 May 2025 08:16:30 GMT

you can export the tables in the OS level.

i hope below link can help you.

https://community.sap.com/t5/devops-and-system-administration-blogs/export-and-import-tables-in-sap-from-the-os-level-with-real-use-case/ba-p/13535839

Best Regards

Park sangyong