INVENTORY INFO - QUERY

Former Member — Thu, 15 Feb 2007 03:31:02 GMT

We have inventory at following locations:

1) Plant

2) Subcontractors

3) Storage

4) In Transit

How can I create a report which will show me where inventory is and how much it is worth and be able to go back in time and find out where this inventory was?

Really stuck in a bad jam here so any feedback is appreciated.....

Thank you

Re: INVENTORY INFO - QUERY

Former Member — Thu, 15 Feb 2007 03:54:23 GMT

Hi,

To ge the Inventory info, In Material Master, We have view called Plant Stock. In this view you can get the stock of that particular material in that plant/ Storage Location. The corresponding table is MARD.

Now Another view in accounting, you have Moving avg.Price/ Std. Price. Multiply the amount and the quantity at that plant/ Storage location. Then you will get the inventory value of that particular material.

In the case of subcontracting, Pick up the material documents with the movement type 541(there should not be 101 movement type document for this 541) and Sum up them and multiply with price of the material.

Find the T.codes MMBE Or MB5T For more clarifications.

Regards,

topic Re: INVENTORY INFO - QUERY in Application Development and Automation Discussions

INVENTORY INFO - QUERY

Re: INVENTORY INFO - QUERY