Function MD_STOCK_REQUIREMENTS_LIST_API for all Plant

[Flare]

Is there a way to run function MD_STOCK_REQUIREMENTS_LIST_API with just exporting the plant and not a specific material? I tried testing it in SE37, but it won't let me run the entire Plant, it demands a Material number.

The reason for this. I want to make a query based on MARC, then I want to create an additional field that would get a value from MD04.

I want to get the Stocks/requirements lists for all materials via this function and store it in an internal table so I can loop into it and fetch the data.

I feel that if I load the entire plant, my query would run faster. Or do you think that running the function for each material would take just as many resources as looping into an itab that had everything in it?

[Sharpshooter]

You are going to call this function in a query?
I see short dumps in your future - probably DBIF_RSQL_INVALID_CURSOR.