Skip to Content
0
Former Member
Jul 20, 2009 at 09:47 PM

SELECT statement not working

611 Views

I have a select statement it is not working properly

SORT i_bom_temp BY idnrk.

DELETE ADJACENT DUPLICATES FROM i_bom_temp COMPARING idnrk.

SELECT bdart matnr werks bdmng INTO TABLE i_resb

FROM resb

FOR ALL ENTRIES IN i_bom_temp

WHERE

  • matnr = 'RSG67FG'.

matnr = i_bom_temp-idnrk.

RESB has 24 table entries for the material. The SELECT statement featched me 2 entries. If i hard code the material it gives me all 24 entries in the material

Very weired.

Any suggestions.

Thanks,

AP