4 weeks ago
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
11 | |
10 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.