BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Joining SAP tables in RFC load to fliter data


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
Ozzloz
Forum Member
Forum Member



Joined: 06 Nov 2013

Posts: 4



PostPosted: Sun Mar 30, 2014 8:00 pm 
Post subject: Joining SAP tables in RFC load to fliter data

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,
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Mar 31, 2014 1:13 am 
Post subject: Re: Joining SAP tables in RFC load to fliter data

You cannot do that.

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

_________________
Consultant at Teradata

The opinions expressed in this post are my own views and not those of Teradata. Apply any advise in this post at your own discretion.
Back to top
Ozzloz
Forum Member
Forum Member



Joined: 06 Nov 2013

Posts: 4



PostPosted: Tue Apr 01, 2014 10:56 pm 
Post subject: Re: Joining SAP tables in RFC load to fliter data

That is a shame it really limits the extraction capabilities for larger tables.
Back to top
Roland Jentsch
Senior Member
Senior Member



Joined: 07 Feb 2006

Posts: 83



PostPosted: Wed Apr 09, 2014 6:22 am 
Post subject: Re: Joining SAP tables in RFC load to fliter data

we have the same problem here!

the view is de-composed in a nested loop!
Back to top
Nemesis
Forum Enthusiast
Forum Enthusiast



Joined: 08 Jun 2004

Posts: 1094
Location: London, England


flag
PostPosted: Thu Apr 24, 2014 6:12 am 
Post subject: Re: Joining SAP tables in RFC load to fliter data

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

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

_________________
Contracting in London again.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0292 seconds using 18 queries. (SQL 0.0033 Parse 0.0009 Other 0.0251)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo