Please let me know which code is right ??

[Former Member]

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.

or

select * from marc into table it_marc

where matnr = p_matnr and

lvorm = ' '.

which one is right ???

[Former Member]

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

VJ

[Former Member]

Hi,

Both codes are correct.

Regards,

Ferry Lianto

[Former Member]

Hi Vijayendra Rao / Ferry,

Thank you for quick replies. Closing thread. points rewarded

Regards

Madhu

[Former Member]

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,

KC