BusinessObjects Board

Joining SAP tables in RFC load to fliter data

dataservices performance
#1

Hello,
We are attempting to load SAP tables using the RFC streaming ooption in Data Services 4.1. This works fine on individual tables but if we want to join 2 tables together to limit the extraction it performs a full table scan on the table and filters in data services not in SAP.
For examle if we link VBAK to VBAP to only extract sales orders created after a certain date ( extracting data from VBAP using a date from VBAK) it appears to first run a full table scan on VBAP then it filters the data in the dataflow before loading to the table. If the same extraction is performed in ABAP it will filter the table on the SAP side of the extraction.

Is there a workaround to get the RFC data flow to perform the same way?

Thanks,

Ozzloz (BOB member since 2013-11-07)

#2

You cannot do that.

Joining tables can only be done via a R/3 flow.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

#3

That is a shame it really limits the extraction capabilities for larger tables.

Ozzloz (BOB member since 2013-11-07)

#4

we have the same problem here!

the view is de-composed in a nested loop!

Roland Jentsch (BOB member since 2006-02-07)

#5

Just curious to know if there’s anything stopping you from using ABAP dataflows to extract SAP data? And have you seen this information?
http://wiki.scn.sap.com/wiki/display/EIM/Overview+SAP+Interfaces

Nemesis :australia: (BOB member since 2004-06-09)