Question Re: ECC custom table extraction through Data Service in Technology Q&A

ECC custom table extraction through Data Service

Former Member — Fri, 04 Nov 2016 18:17:37 GMT

Hi,

We are trying to extract the ECC tables without abap data flow due to limitation not able to install packages in ECC.

Extracting through normal data flow and execute in background option .Presently we are running on DS 4.2. SP5

We are getting the below error after running couple of hours. Please let me know any suggestion for this kind of error codes .

error.jpg

Re: ECC custom table extraction through Data Service

former_member220897 — Fri, 18 Nov 2016 09:56:25 GMT

what do you see in transaction ST22 ?

Re: ECC custom table extraction through Data Service

former_member187605 — Fri, 18 Nov 2016 10:32:20 GMT

It's never a good idea to extract huge ECC tables in a normal data flow.

Refer to Best way to read data from SAP ECC for a more elaborate discussion on the different options.

Re: ECC custom table extraction through Data Service

Former Member — Fri, 18 Nov 2016 11:12:59 GMT

Please go through the link posted by Dirk. If you can create RFC Programs then you can make better use of RFC data transfer method while pulling data from SAP ECC, but this method will also generate ABAP programs on the Application server.

https://wiki.scn.sap.com/wiki/display/EIM/RFC+transport+method

What is the Data transfer method which you are using in the Datastore configuration?

If you have access to tables being used by SAP Application server then you can directly connect to the daatabase and pull data

Regards

Arun Sasi