Thank U I Implemented the logic. Now while fetching the records. I mean while calling the Query no dump. but there is Final internal table like rt_output here I am getting the dump No more memory available to add rows to an internal table-TSV_TNEW_PAGE_ALLOC_FAILED .... I am thinking final internal table not able to to hold huge data... Any advice.
"Using Cursor Technique to improve the performance
" Open cursor for fetching data in packages
OPEN CURSOR WITH HOLD @LV_cursor FOR
SELECT objectclas, objectid, changenr, username, udate, utime, tcode
FROM cdhdr
WHERE objectclas IN @LR_objectclas
AND username IN @s_user
AND udate IN @LR_daterange.
DO.
* " Fetch data in chunks
FETCH NEXT CURSOR lv_cursor INTO CORRESPONDING FIELDS OF TABLE lt_temp_cdhdr PACKAGE SIZE lv_package_size.
" Exit the loop if no more data
IF sy-subrc <> 0.
EXIT.
ENDIF.
SORT lt_temp_cdhdr BY objectclas objectid changenr.
CLEAR lt_dcdhdr.
" Append fetched records to the final table
APPEND LINES OF lt_temp_cdhdr TO lt_dcdhdr.
IF lt_dcdhdr IS NOT INITIAL.
SELECT objectclas, objectid, changenr, tabname, tabkey, fname, chngind, value_new, value_old FROM cdpos INTO TABLE @DATA(lt_dcdpos)
FOR ALL ENTRIES IN @LT_dcdhdr
WHERE objectclas = @LT_dcdhdr-objectclas AND objectid = @LT_dcdhdr-objectid AND changenr = @LT_dcdhdr-changenr.
IF lt_dcdpos IS NOT INITIAL.
SELECT bname, name_first, name_last FROM user_addr INTO TABLE @DATA(lt_duser_addr)
FOR ALL ENTRIES IN @LT_dcdhdr
WHERE bname = @LT_dcdhdr-username.
IF lt_duser_addr IS NOT INITIAL.
SELECT bname, persnumber, addrnumber FROM usr21 INTO TABLE @DATA(lt_dusr21)
FOR ALL ENTRIES IN @LT_duser_addr
WHERE bname = @LT_duser_addr-bname.
IF lt_dusr21 IS NOT INITIAL.
SELECT addrnumber, persnumber, date_from, consnumber,smtp_addr, smtp_srch FROM adr6 INTO TABLE @DATA(lt_dadr6)
FOR ALL ENTRIES IN @LT_dusr21
WHERE persnumber = @LT_dusr21-persnumber.
ENDIF.
ENDIF.
ENDIF.
SORT lt_dcdpos BY changenr.
SORT lt_duser_addr BY bname.
SORT lt_dusr21 BY bname.
SORT lt_dadr6 BY persnumber.
LOOP AT lt_dcdhdr INTO DATA(ls_dcdhdr).
READ TABLE lt_dcdpos WITH KEY changenr = ls_dcdhdr-changenr INTO DATA(ls_dcdpos) BINARY SEARCH.
READ TABLE lt_duser_addr WITH KEY bname = ls_dcdhdr-username INTO DATA(ls_duser_addr) BINARY SEARCH.
READ TABLE lt_dusr21 WITH KEY bname = ls_duser_addr-bname INTO DATA(ls_dusr21) BINARY SEARCH.
READ TABLE lt_dadr6 WITH KEY persnumber = ls_dusr21-persnumber INTO DATA(ls_dadr6) BINARY SEARCH.
APPEND VALUE #( uname = ls_dcdhdr-username
udate = ls_dcdhdr-udate
utime = ls_dcdhdr-utime
tcode = ls_dcdhdr-tcode
Objvale = ls_dcdhdr-objectid
tabname = ls_dcdpos-tabname
fname = ls_dcdpos-fname
valueold = ls_dcdpos-value_old
valuenew = ls_dcdpos-value_new
fstname = ls_duser_addr-name_first
lstname = ls_duser_addr-name_last
email = ls_dadr6-smtp_addr ) TO rt_output.
CLEAR:ls_dcdhdr,ls_dcdpos,ls_duser_addr,Ls_dusr21,ls_dadr6.
ENDLOOP.
ENDIF.
ENDDO.
CLOSE CURSOR lv_cursor.
