Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Please let me know which code is right ??

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 ???

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question