topic Re: syntax in repots.....???????? in Application Development and Automation Discussions

syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:04:42 GMT

when v use ....SELECT * INTO CORRESPONDING FIELDS OF TABLE TAB1 ........THE OUTPUT IS BETTER THAN ...........SELECT F1 F2 F3 F4 INTO TABLE TAB1 ......Y IT IS SO ??????PLS LEMME KNOW

Re: syntax in repots.....????????

kiran_k8 — Mon, 20 Aug 2007 05:08:39 GMT

Guru,

Select * will fetch all the records and is not recomended as it affects the performance.

Always see to that the where clause in the select statement have either primary key fields or index field,else it will also effect the performance.

select f1 f2 f3 from vbap into table ivbap where .....

is much better than using select *.

Just check for the keyword OPTIMISATION in SDN forum,you will be able to see tons of info related to your query.

K.Kiran.

Re: syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:09:15 GMT

Hi,

Because when u write select matnr mtart matkl into table it_mara at that time it find field as per your select query sequence but when u write selct * into corresponding fields it means it follow sequence of data dictionary so we always use corresponding fields option for that is improve your performance.

Rewards if it is useful.

Re: syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:11:38 GMT

Hi,

For further reference regarding optimization you can look into this link....

http://www.sapbrain.com/ARTICLES/TECHNICAL/optimization/optimization.html#Optimizing%20the%20load%20of%20the%20database

Regards,

Priyanka.

Re: syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:12:39 GMT

Hi,

using of * and into corresponding will results in poor performance

but the select fields into table will results in good performance

because when * is used all the fields will be fetched and it has to match the

field names from data base and in your internal table fields order and names...

but this will not be in the case of select field and into table

here we should be care full that the order of fields in itab and order of fields in

select query should be same

egL

data:begin of itab occurs 0,

matnr type mara-matnr,

ersda type mara-matrn,

matkl type mara-matkl,

end of itab.

select matnr ersda matkl

from mara into table itab

but it should not be

select matnr matkl ersda

from mara into table itab

as it will put the value of matkl in the ersda field in itab.

thanks & regards,

Venkatesh

...SELECT * INTO CORRESPONDING FIELDS OF TABLE TAB1 ........THE OUTPUT IS BETTER THAN ...........SELECT F1 F2 F3 F4 INTO TABLE TAB1 ......Y IT IS SO ??????PLS LEMME KNOW

Re: syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:16:09 GMT

Hello Guru,

Both are same... U can find the difference only with... INTO CORRESPONDING FIELDS OF TABLE... If you use this one... order of the fields in the selec statement and order of the fields in the internal table need not be same. where as if you are not using this... order of feids in both select statement and internal table should be same.

If u usr select * from... then it will just kill the performance of the report... so it is not suggestable...

Reward If Helpful.

Regards

Sasidhar Reddy Matli.

Re: syntax in repots.....????????

Former Member — Mon, 20 Aug 2007 05:22:27 GMT

THNX PRIYANKA 4 UR HELP .............GIVING U REWARDS.........