topic Re: Regarding Material in Application Development and Automation Discussions

Regarding Material

Former Member — Wed, 27 Aug 2008 08:05:55 GMT

hi all,

How can i get Stock of particular day for particular Material type(like finished goods).

Regards

Rami

kesavadas_thekkillath — Wed, 27 Aug 2008 08:07:11 GMT

Check MARD Table Field-LABST.

i guess for a date the field is DLINL

Former Member — Wed, 27 Aug 2008 08:11:42 GMT

Hi,

You can use 'BAPI_MATERIAL_AVAILABILITY' to find available stock of material.

Also check the BAPI " BAPI_MATERIAL_STOCK_REQ_LIST ".

Hope this helps you.

Thanks,

Ruthra

Former Member — Wed, 27 Aug 2008 08:13:11 GMT

here i am getting stock for total material types but i need for particular material type.

Regards

Reddy

kesavadas_thekkillath — Wed, 27 Aug 2008 08:19:57 GMT

the go to "mara" table check "MTART" field and filter the materials

Former Member — Wed, 27 Aug 2008 08:20:13 GMT

Hi,

check transaction MC.9

Regards Vassko!

kesavadas_thekkillath — Wed, 27 Aug 2008 08:23:33 GMT

chk this outline

select matnr from mara into itabmara where mtart = 'HALB' and lvorm = space.

select matnr labst into table itab from mard for all entries in itabmara where matnr = itabmara-matnr.

labst gives only the stock in storage location.

if u want the stock in Quality inspectiojn also consider the field INSME.

if u want to filter based on plant....then go to marc table and filter the materials based on WERKS