Method/Class that returns valid material from internal table

[Former Member]

Hello,

I am searching for a second option to get valid material from MARA instead of using the selection below....

SELECT MATNR EXTWG

APPENDING CORRESPONDING FIELDS OF TABLE tmpmara

FROM MARA

FOR ALL ENTRIES IN it_nomrp

WHERE MATNR = it_nomrp-MATNR

AND EXTWG EQ p_extwg.

Is there a method where I can pass an internal table and a condition (where extwg = p_extwg) and it returns a result table of valid materials? I am looking for an alternative to compare performance....

Thanks,

AJ

[Former Member]

Not very clear..what you want your method to do...

in the method also you have to write same code....

[Former Member]

I dont think there is any such class to fetch the material. Regarding comparing the performance, I see that you are using For all entries in your select query. So you need to make sure that the master internal table ( it_nomrp) is not empty. Also see if you can use join instead of FAE.

regards,

Advait