Stock Check

[Former Member]

Can we check directly as to what all materials are available in stock without checking one by one for stock availability.

[Former Member · Accepted solution]

Hi Vicky,

please find below tables

Stock tables

Table	Description	SOBKZ
MARC	Plant Data for Material
MARD	Storage Location Data for Material
MCHB	Batch Stocks
MSSL	Total Special Stocks with Vendor	O
MSLB	Special Stocks with Vendor	O
MSKU	Special Stocks with Customer	V,W
MSSA	Total Customer Orders on Hand	E
MSKA	Sales Order Stock	E
MSSQ	Project Stock Total	Q
MSPR	Project Stock	Q
MKOL	Special Stocks from Vendor	K,M

Regards,

Aish

[Former Member]

Hi,

Your question is not related to Financial Accounting rather its related to Material Management, please post your queries at proper place and follow SCN rules.

Regards

[Former Member]

Dear Vicky,

You can use MB5L

Best Regards.

[suma_mani]

Hi Vicky,

MB52 is transaction cod where you can check stock availability for all materials at time.

Regards

Mani

[Former Member]

Hi,

Also you can check with MB5B if you want to check for particular period

[Former Member]

Hi Vicky,

Please Check the below tables & T.codes

Stock tables

Table	Description	SOBKZ
MARC	Plant Data for Material
MARD	Storage Location Data for Material
MCHB	Batch Stocks
MSSL	Total Special Stocks with Vendor	O
MSLB	Special Stocks with Vendor	O
MSKU	Special Stocks with Customer	V,W
MSSA	Total Customer Orders on Hand	E
MSKA	Sales Order Stock	E
MSSQ	Project Stock Total	Q
MSPR	Project Stock	Q
MKOL	Special Stocks from Vendor	K,M

Please check the MMBE plant stock for a material or MB52.Or use the table MARD for storage location stock.Plant will be having materials and for materials you will have stock for that plant.

Regards,

Aish

[Former Member]

Hi Vicky,

First check table level, there you can get all the information, after that go for t.code

Regards,

Aish

[Former Member]

Hi vicky

Please check the MMBE plant stock for a material or MB52, Or use the table MARD for storage location stock.Plant will be having materials and for materials you will have stock for that plant.

Regards,

Aish