TSV_TNEW_PAGE_ALLOC_FAILED - No more storage space available for extending

40 Views

Hi

Im SAP-BW Consultant. I need some code in the transfer rules. But while im loading data , im getting "No more storage space available for extending an internal table.

Pls check my code and modify it so that i can load the data of 5,000,00 records

TYPES: BEGIN OF tys_TG_1,

/BIC/ZIUTILICH TYPE /BIC/OIZIUTILICH,

/BIC/ZIRGRCH TYPE /BIC/OIZIRGRCH,

/BIC/ZPRODUCT TYPE /BIC/OIZPRODUCT,

END OF tys_TG_1.

TYPES: tyt_TG_1 TYPE STANDARD TABLE OF tys_TG_1

WITH NON-UNIQUE DEFAULT KEY.

data: e_s_result type tys_TG_1.

data: e_t_result type tyt_TG_1.

DATA : ITAB1 TYPE STANDARD TABLE OF /BIC/AZDSO_HYD00.

DATA : WA_ITAB TYPE /BIC/AZDSO_HYD00.

loop at RESULT_PACKAGE into e_s_result.

Select /BIC/ZIUTILICH /BIC/ZIRGRCH /BIC/ZPRODUCT FROM /BIC/AZDSO_HYD00 INTO

(e_s_result-/BIC/ZIUTILICH,

e_s_result-/BIC/ZIRGRCH,

e_s_result-/BIC/ZPRODUCT)

WHERE

COMP_CODE = e_s_result-COMP_CODE AND

PROFIT_CTR = e_s_result-PROFIT_CTR .

append e_s_result to e_t_result.

endselect.

clear e_s_result.

ENDLOOP.

refresh RESULT_PACKAGE.

move e_t_result[] to RESULT_PACKAGE[].

So im getting TSV_TNEW_PAGE_ALLOC_FAILED - No more storage space available for extending an internal table..

I think there is a problem in the code. pls look it and modify it.

Regards

kumar