Data Tables for Inventory Report

[former_member143179]

Dear Sir,

We need to develop an Inventory Report for displaying the Item wise Stock (cleared stock qty & value) . The Item can be available under the Un-restricted Stock as well as Stock lying under the Special Stock like Project / Sale-Order / Vendor Stock .

We request you to kindly guide us about the Tables where the relevant data will be available .

With Thanks and Regards

B Mittal

[Former Member · Accepted solution]

Hi

Please use this tables for inventory reports

MARC Plant Data for Material

MARD Storage Location Data for Material

MKOL Special Stocks from Vendor

MSCA Sales Orders on Hand with Vendor

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSPR Project Stock

RESB Reservation/dependent requirements

[former_member143179 · Accepted solution]

Dear Mr Kishore Kumar Chiluka

Thanks for reply . As suggested by you , we are able to get the Item Quantity but Item Value is not available . Kindly guide as how can we get the Item Value also please .

Regards

B Mittal

[Former Member · Accepted solution]

Hi

Please use this tables

EBEW Sales Order Stock Valuation

MBEW Material Valuation .

QBEW Project Stock Valuation

Valuation details are maintained in these tables

Thanks & Regards

Kishore