Skip to Content
0

Can we join sap tables directly from sap datastore without extracting them to out target datastore?

Aug 08, 2017 at 06:19 PM

47

avatar image
Former Member

hi,

I have to join 2 tables with huge data volume so first if i extract it to MY sql datastore it is taking taking 30 mins for each table.

So if I join both the sap tables(also I hav few filters) without extracting it to target datastore ,will it cause any performance issue? As source table datastore and target table datastore will be different.

Could u please help me out as I am new to sap bods.

Thanks,

Suja

SAP Data Services
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Ravi kiran Pagidi Answered Mar 07 at 11:14 AM
0

use ABAP dataflow to join SAP tables and the join will be pushed down to SAP system.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users