topic Current stock data in Application Development and Automation Discussions

Current stock data

Former Member — Mon, 26 Oct 2009 09:13:32 GMT

Can we fetch The current stock of a material (unrestricted use) using a custom query? .if so please give me in which table and which field.

thanks in advance

Former Member — Mon, 26 Oct 2009 09:27:34 GMT

Data : itab type table of mcha with header line.

MCHA table contains Unrestricted stock

Go throught the table this gives the Unrestricted stock Batch wise.

select * from mcha into table itab where matnr = your_matnr and werks = your_werks and charg = your_charg.

Cheers

Ram

Edited by: Ramchander Krishnamraju on Oct 26, 2009 10:32 AM

kesavadas_thekkillath — Mon, 26 Oct 2009 09:29:49 GMT

MARD-LABST ( Unrestricted Stock)

MARD-LGORT ( Storage Location)

MARD-MATNR( Material No)

MARD-WERKS( Plant)

MARD-LVORM( Deletion Indicator )

You can also check transaction MCBC or MB52

Former Member — Mon, 26 Oct 2009 10:19:58 GMT

u can get it from MARD based on storage location material or plant