Skip to Content
0
Former Member
Dec 01, 2008 at 08:50 AM

New Datasource with MBEWH table

137 Views

Hi,

I need to create a datasource based on a FM. The FM should retrive all the materials from MBEWH table for all the plants. It should basically retrieve the latest stock from MBEWH table.

Consider a material A is posted at year 2007 period 6 and 7 and its not posted in the following periods, it should take material A of year 2007 and period 7. If I retrive all the records, sort it and delete adjacent duplicates then it would be a performance issue, Since its a history table it will contain numerous records. If we use aggregate function also, then it also leads to performance problems. Is there any other way of proceeding with this issue? Is there any way to retrive the lastest stock from MBEWH table?

Any inputs.