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

[former_member425555]

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

[former_member208402]

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