Skip to Content
avatar image
Suja Raut

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

Aug 08, 2017 at 06:19 PM | 56 Views | Last edit Mar 06, 2018 at 09:57 PM 5 rev.

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Ravi kiran Pagidi
    Mar 07, 2018 at 11:14 AM

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

    Add comment
    10|10000 characters needed characters exceeded