source table: large BW table

Hello everyone,

does anyone have experience with large BW tables in Data Services?
I would like to load a BW table (ca. 150Mio. Records) in SAP HANA.
Since the RFC method is only for a small amount of data (<512kb), I tried to get the data over the Shared Directory method.
Small SAP tables I was able to transfer in HANA over an ABAP DataFlow. But this is not working with big tables. With the Data Transfer Method „Shared Directory“the System is creating the SAP tables on the SAP Server (about 70GB), but it’s not possible to access the data.
„Error while accessing table“
Since it´s working with small tables, it´s not a permission issue.
Is there any size limit for this tranfermethod?
There should be a way to use big BW tables. Due to performance testing i would not like to split the dataflow in a while-loop.

Best Regards

ADDA


ADDA (BOB member since 2010-07-01)