topic Select statement Optimisation. in Application Development and Automation Discussions

Select statement Optimisation.

Neslinn — Tue, 22 Apr 2008 21:02:06 GMT

Hi All,

I have the below code:

SELECT * FROM prps

INTO CORRESPONDING FIELDS OF TABLE lt_prps_temp

WHERE pbukr = g_bukrs.

But the internal table -LT_PRPS_TEMP contains the fields in PRPS but not in the same order. In this case how can i change the 'INTO CORREPONDING FIELDS' to 'INTO TABLE'.

Thanks & Regards,

Neslin.

Re: Select statement Optimisation.

Former Member — Tue, 22 Apr 2008 21:10:53 GMT

You can mention the field list in the select statement ratherthan giving SELECT * as it is a performance issue.

If you really need all the fields then you can give.

Avoid using into corresponding too.

Also if you can use primary key field PSPNR in the where clause that improves the performance drastically.

Thanks,

Srinivas

Re: Select statement Optimisation.

Former Member — Tue, 22 Apr 2008 21:15:46 GMT

Hi, you should replace

SELECT *

SELECT field1 field2 field3...

Where fieldn are the fields you have in internal table for prps.

Hope it helps.