Skip to Content
0
Former Member
Dec 06, 2010 at 07:48 PM

For all entries issue

29 Views

Hi All,

Below is the select query I have which is taking more time when the records in the internal table is touching to almost 2 million.

SELECT paledger vrgar versi

perio paobjnr pasubnr

belnr posnr gjahr perde

FROM ce1ec01

APPENDING TABLE t_ce1ec01 PACKAGE SIZE 10000

FOR ALL ENTRIES IN t_arixco2_tmp

WHERE paobjnr EQ t_arixco2_tmp-paobjnr

AND PERIO gt p_perio.

ENDSELECT.

The secondary index is created with fields PAOBJNR and PERIO fields.

I have used ST05 and it is using the secondary index.

Regards,

Pratyusha.