R/3 ABAP Data Flow v/s Direct Table read
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 ?
Nawfal Tazi replied
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.