06-10-2008 10:55 AM
Hi All,
How do you find whether stock is available for specified material in storage location, i mean which TABLE & FIELD should be referred?
Can anybody help me out.....
Regards
Prashanth
06-10-2008 10:57 AM
hi,
FM: 'MD_STOCK_REQUIREMENTS_LIST_API' will give the details of the material requirments. it wil populate 2 internal tables based on ur import parameters. that will giev u all details.
I hope this is wat u r looking for!!!
regards,
madhu
06-10-2008 10:58 AM
Hi Prashanth,
You can select from MARD table for this.
You have to pass the Material Number, Plant and Storage Location.
As for the quantity it's depends on what quantity that you want to select (blocked, unrestricted, in transfer, etc). You can find all these Quantity fields in MARD table.
Thanks,
Victor.
06-10-2008 10:59 AM
Hi Prashanth,
Use Table MARD and field LABST-Stock Quantity.
if u want consignment stock also then use table MKOL field SLABS.
Regards,
Babul.
06-10-2008 10:59 AM
06-10-2008 11:01 AM
hai,
go to mard table and supply material code and you can see it's different stock's(unrestricted/blocked) in different locations.
regards
06-10-2008 11:05 AM
refer transaction MMBE (stock overview).U can find all the stocks available for a particular material.
Also refer table MARD