Skip to Content
0
Former Member
Jul 20, 2005 at 04:54 AM

Performance issue..

17 Views

Hi,

I am using select statement three times on table CABN.

The testing team said that its not a good idea to do multiple selection on same table as it increases read access on database table. They suggested me to use 'ranges' instead.

Now I am using this code inside a BADI implemenation method so I can't use ranges because ranges keyword is restricted to use in object oriented related concepts.

Now the other solution my lead suggested is to read this all in an internal table and then do it .

How do I do this ?

SELECT single ATINN from CABN

into WA_ATINN WHERE ATNAM =

W_temp1.

SELECT single ATINN from CABN

into WA_ATINN

WHERE ATNAM = W_temp2.

SELECT single ATINN from CABN

into WA_ATINN WHERE ATNAM =

W_temp3.