topic Re: BAPI for displaying stock in Application Development and Automation Discussions

BAPI for displaying stock

Former Member — Tue, 17 Oct 2006 06:47:26 GMT

hi,

Is there a bapi/FM which gives us the stock of a material on a particular date.

Satish

Re: BAPI for displaying stock

Former Member — Tue, 17 Oct 2006 06:55:15 GMT

Hi,

Check BAPI_MATERIAL_STOCK_REQ_LIST.

Thanks and Regards,

Bharat Kumar Reddy.V

Re: BAPI for displaying stock

Former Member — Tue, 17 Oct 2006 07:09:07 GMT

Hi Satish

BAPI_MATERIAL_AVAILABILITY can give us the stock of now, if you need to get the stock for a particular date option would be to gather material movements(MKPF, MSEG) and manipulate ourselves w.r.t current stock.

Kind Regards

Eswar

Re: BAPI for displaying stock

Former Member — Tue, 17 Oct 2006 08:26:15 GMT

hi bharat,

thank you. I just have a small doubt, can we use BAPI_MATERIAL_STOCK_REQ_LIST to get the stock of the material on a particular date.

Satish

Re: BAPI for displaying stock

Former Member — Tue, 17 Oct 2006 08:53:12 GMT

Hi Satish,

Sorry, it will give the requirement... you can try the following ...

For Materials (MARD-MATNR) selected above, Plant (MARD-WERKS) = Input Plant and Storage Location (MARD-LGORT) NOT EQUAL TO “RT01”, determine all the un-restricted quantities (MARD-LABST) and Stock in Inspection (MARD-INSME). Sum up all the quantities. Let the sum be equal to “ST”.

For Posting date (MKPF-BUDAT) = current date, determine all the Material documents (MKPF-MBLNR).

For Documents (MSEG-MBLNR) determined above, Materials (MSEG-MATNR) selected above, Storage Location (MSEG- LGORT) NOT EQUAL “RT01”, Movement type (MSEG-BWART) NOT EQUAL to “321”, Debit / Credit indicator (MSEG-SHKZG) = “H” pick up all the quantities (MSEG-MENGE). Sum up all the quantities. Let the sum be equal to “H”.

Similarly, For Documents (MSEG-MBLNR) determined above, Materials (MSEG-MATNR) selected above, Storage Location (MSEG- LGORT) NOT EQUAL “RT01” Movement type (MSEG-BWART) NOT EQUAL to “321”, Debit / Credit indicator (MSEG-SHKZG) = “S” pick up all the quantities (MSEG-MENGE). Sum up all the quantities. Let the sum be equal to “S”.

Then On date Stock (Un-restricted + QI) = “ST” + “H” – “S”

Thanks and Regards,

Bharat Kumar Reddy.V