Current stock data

[Former Member]

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]

Hi

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]

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]

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