Extracting Large Table Data from SAP ECC / S4H

[Vedette]

Are there any recommended methods for extracting large table data from ECC / S4H via a remote connection?

Function Module RFC_READ_TABLE is available but not release for customer use and therefore not recommended. What would be a suitable alternative (SAP, custom, or 3rd party) for extracting large tables (million+ records)?

My understanding is that CDS views are also not recommended for extracting large volumes of table data?

[Sandra_Rossi]

Extract to where? What database software is it? NB: if you access it directly, it's better of course.

[Sandra_Rossi]

If you want to extract data from a database, access the database directly. The best solution will then depend on the database software you are using.

[Sandra_Rossi]

If you want to use RFC anyway, create an RFC-enabled function module which does "the same" as RFC_READ_TABLE.

[MarkusTolksdorf]

Never use RFC_READ_TABLE nor bypass the ABAP system and access the data directly in the underlying database. Instead write a dedicated remote enabled function module that does proper authorization checks and is well-defined for the concrete use-case. 

In case your ABAP system is new enough you can also access CDS views via SQL Services and the ABAP ODBC driver, see https://help.sap.com/docs/btp/sap-business-technology-platform/accessing-abap-managed-data-from-exte.... Also with that approach security aspects can be considered in a proper way

Best regards,
Markus

[qwertie]

hello,

maybe you can use odbc connection for remote db? Otherwise r3trans can also extract tables from data on os level

br

[Vedette]

Hi Sandra, 

Extract to something like a sql db, external to SAP.