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