topic Re: Method/Class that returns valid material from internal table in Application Development and Automation Discussions

Method/Class that returns valid material from internal table

Former Member — Wed, 11 Feb 2009 14:46:19 GMT

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,

Re: Method/Class that returns valid material from internal table

Former Member — Wed, 11 Feb 2009 18:39:08 GMT

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

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

Re: Method/Class that returns valid material from internal table

Former Member — Wed, 11 Feb 2009 18:45:20 GMT

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