Query Stock materials list

[Former Member]

Hi Friends,

Can somebody help me to create a query for the below:

1.To get a list of materials in a particular storage location

2. Need to check for the list of materials whats the corresponding sales orders/deliveries?

3. Whats the status of the delivery for these articles?

Thanks

Isaac

[Former Member]

Dear,

May be this T.Code will help you.

1) MM60,

2) VL06G/VA05,

Regards,

Sandip

[Former Member]

Thanks friends for the replies...

I am building one query inorder to fetch the stock in the storage location using MARA and MARD tables(without using MB51/52/MMBE).

I just want to know whcih field do I need to use to pick the Unit of measure ....becoz the material stock lies with multiple unit of measures...so iam not sure whether to use MARA - MEINS or not?

Thanks

Isaac

[Former Member]

Isaac

Base Unit of measure ( MARA-MEINS) should be the one because in Inventory Management, the base unit of measure is the same as the stockkeeping unit. Hope this helps.

[Former Member]

Isaac

There's nothing newtonian about this, just kidding!

Try a query joining tables MARD, VBAP, LIPS and VBUP. Does it help?