Table for Special Stock Types

[Former Member]

Hi All,

I am creating a report to display the stock information of a material. In that i need to include all the special stocks also.

Can anyone please tell me the table containing the data for special stock type E,K,M,O,P,Q,V,W,Y

[Former Member]

Check MCHB Table.

[Former Member]

Hi ,

I have found the tables for some of the special stock type. But i still did not find the table containing the data of

special stock type 'P'(Pipeline Material) and 'Y'(Shipping unit).

If anybody know this then please let me know

[Former Member]

Hi

You can check this table for your requirement

Table -MSKU - Special Stocks with Customer

Field name -SOBKZ(Special Stock Indicator)

regards

Chakram

[Former Member]

Hi,

I need the table containing the stock information of these special stock types and not the field for special stock

[asik_shameem]

Check these tables.

MSCA Sales Orders on Hand with Vendor

MSCD Customer stock with vendor

MSCS Customer stock with vendor - Total

MSFD Sales Order Stock with Vendor

MSFS Sales Order Stock with Vendor - Total

MSID Vendor Stock with Vendor

MSIS Vendor Stock with Vendor - Total

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSOA Total Sales Orders on Hand with Vendor

MSPR Project Stock

MSRD Project Stock with Vendor

MSRS Project Stock with Vendor - Total

MSSA Total Customer Orders on Hand

MSSL Total Special Stocks with Vendor

MSSQ Project Stock Total

[Former Member]

Hi,

If you have Number of Material Document (MBLNR) then you can get SOBKZ from MSEG table.

Hope it helps.

[Subhankar]

Hi

You can get this from T table T148. Main table for Special Stock type is EKPO-SOBKZ.

Thanks

Subhankar