Select statement Optimisation.

[Neslinn]

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.

[Former Member]

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

[Former Member]

Hi, you should replace

SELECT *

by

SELECT field1 field2 field3...

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

Hope it helps.