Skip to Content

First load in sap BW on HANA with 1.5 Billion Records

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....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded