Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

INVENTORY INFO - QUERY

Former Member

‎2007 Feb 15 3:31 AM

0 Likes
460

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

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

Reply
1 REPLY 1
Read only

Former Member

‎2007 Feb 15 3:54 AM

0 Likes
432

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,