Dear Gurus,
Pls see the following query....its taking a lot time & giving runtime error TSV_TNEW_PAGE_ALLOC_FAILED as no of records being fetched is around 1950000.
SELECT * FROM bseg
INTO CORRESPONDING FIELDS* OF TABLE it_final
for all entries in t_bkpf where belnr = t_bkpf-belnr
and gjahr in so_gjahr and bukrs = 'NDPL'.
Pls see & tell hw cn i modify this. Also i m unable to find indexes for table bseg.
Thnx.