2007 Oct 15 10:10 AM
Hello,
Just a simple question. Is there a way by using the SAP Table or the Function Modules to check if quantity/stock of a material given on a certain date and specific plant?
Hope to hear from you soon. Sorry If I can respond sooner.
Thank you and good day.
Hello,
Just a simple question. Is there a way by using the SAP Table or the Function Modules to check if quantity/stock of a material given on a certain date and specific plant?
Hope to hear from you soon. Sorry If I can respond sooner.
Thank you and good day.
2007 Oct 15 3:55 PM
hi
you can use one of the two t-codes to get the necessary info.
In MB52 - Shows Material,Material Description,Plant,Storage Location wise Different Stock Value,and Total Value
In MB5B - Shows Material,Material Description,Plant,Storage Location, Material Doc., Movement Type, Posting Date wise total Receipt and Issue
Thanks.
2007 Oct 16 1:24 AM
Hi abap_greenhorn,
Thanks but I was thinking more of a SAP Table because I need to extract the results to a customized ABAP Program.
As for the FM, it doesnt specify the date unfortunatley, which is needed.
2007 Oct 15 4:14 PM
Hi,
Please try BAPI BAPI_MATERIAL_AVAILABILITY.
Regards,
Ferry Lianto
2007 Oct 16 6:04 AM
Hi,
You can check out the table EKPO (Purchasing Document Item) to find the stock of the material (MATNR) and link with EKET ( on Scheduling Agreement Schedule Lines) based on certain date (EINDT) and specific plant (WERKS).
Reward if useful........
2007 Oct 16 6:53 AM