Skip to Content

First load in sap BW on HANA with 1.5 Billion Records

Jul 09, 2017 at 05:09 AM


avatar image

Hi Guys,

I have a ztable in ECC which got replicated to BW server. As its BW on HANA so using ADSO for current development. The data in the ztable and 1st level DSO is single level BOM data and requirement is to make it to multi level data in End routine of 2nd level DSO. Its working as expected in Development server. The issue is that in Production server I have 1.5 Billion materials and definitely by DTP execution will fail mentioning the internal table memory allocation exceeded(No storage space available for extending table result_package).

So Is there any way to make it split the materials in to chunks and call the DTP for those materials(I have already kept the semantic key on material) So that the execution of DTP's is successful. Please share your valuable suggestions....

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ashish Dwivedi Jul 12, 2017 at 01:00 PM

Hi Abhilash,

As this issue is related to DTP, so you can load the data with filter condition also that will load it in parts.

If possible apply these filters and make the required number of dtps and add them into the PC.

10 |10000 characters needed characters left characters exceeded