topic Re: Please let me know which code is right ?? in Application Development and Automation Discussions

Please let me know which code is right ??

Former Member — Thu, 01 Nov 2007 15:11:10 GMT

Hi ,

if I am writing a slect statement on MARC table and have to keep a condition on field LVORM (Flag Material for Deletion at Plant Level). Which is right code and what is performnace issues.

select * from marc into table it_marc

where matnr = p_matnr and

lvorm eq SPACE.

select * from marc into table it_marc

where matnr = p_matnr and

lvorm = ' '.

which one is right ???

Re: Please let me know which code is right ??

Former Member — Thu, 01 Nov 2007 15:12:39 GMT

Hi,

Madhu, both the select statements are fine. TO reduce the performance you can select fields instead of SELECT * unless you need all the fields from MARA.

Cheers

Re: Please let me know which code is right ??

Former Member — Thu, 01 Nov 2007 15:13:10 GMT

Hi,

Both codes are correct.

Regards,

Ferry Lianto

Re: Please let me know which code is right ??

Former Member — Thu, 01 Nov 2007 15:18:54 GMT

Hi,

select * from marc into table it_marc

where matnr = p_matnr and

lvorm = ' '.

write it as, I observe there is no blank between two single quotes.

select * from marc into table it_marc

where matnr = p_matnr and

lvorm = ' '.

Bye,

Re: Please let me know which code is right ??

Former Member — Thu, 01 Nov 2007 15:20:33 GMT

Hi Vijayendra Rao / Ferry,

Thank you for quick replies. Closing thread. points rewarded

Regards

Madhu