R/3 ABAP Data Flow v/s Direct Table read

[Former Member]

Hello Experts - In my SAP ECC source table I have around 10 Billion records.... and I need to process these records through Data Service.

Its a Single Table and each record length is quite big.

What is the best method to make the data transfer process faster...

- ABAP Data Flow  ?

- Direct read from a table ?

I have seen couple of post but this is nowhere properly mentioned what to use where ?

I really need a proper and logical explanation which method I should Use here ?

Thanks

R

[Former Member · Accepted solution]

Hi,

Streaming data from SAP using RFC: Reads data from SAP applications using regular data flows

and supports tables (for small data sets only) and extractors.

ABAP : Reads data from SAP applications using ABAP data flows and supports tables, hierarchies, extractors, and functions with scalar arguments, good for .

Based on the number of records you mentioned, I would say ABAP is your better option. Because for large amounts of data performance is generally better when you extract data  using ABAP data flow.

Info from Supplement for SAP  guide , please check it.

Regards

Nawfal

[Former Member]

Hi,

the best method will depend on the version of DS you have....

regards,

Adrian

[Former Member]

I have BODS 4.0 SP -3 .... What you suggest for this ?