cancel
Showing results for 
Search instead for 
Did you mean: 

Table and Field name

former_member417490
Participant
0 Kudos

Hi,

I am making a stock report where my client wants sales order stock unrestricted,quality inspection ,blocked stock ,transfer,return etc to be shown separately. Can anybody tell me what are the tables and fields name to do the report.

Thanks N Regards,

SIddhartha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

first try the report MB5B... U can get everything there..

and also mb52 and mb51

Former Member
0 Kudos

Use report MB51 . In this special stock E will give u the sales order stock. and space will give all other stock.

Answers (8)

Answers (8)

former_member417490
Participant
0 Kudos

thanks

Former Member
0 Kudos

hi,

Check table MCHB

regards

Krishna Mohan

former_member417490
Participant
0 Kudos

Thanks to all.Can anyone of you tell me what is the field name and table name of reserved stock.

Thanks N regards,

Siddhartha

Former Member
0 Kudos

Hi,

From tcode: MB5B ,you can get the details,but for your reference ,the tables are

EBEW SALES ORDER STOCK VALUATION

MBPR Stock at Production Storage Bin

MCHB Batch Stocks

MCSD Customer Stock

MCSS Total Customer Stock

MEIK Make-to-Order Stock for Customer Order

MKLK Consignment Stocks and Returnable Packaging with Customer

MKOL Special Stocks from 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

MSPR Project Stock

MSRD Project Stock with Vendor

MSRS Project Stock with Vendor - Total

MSSL Total Special Stocks with Vendor

MSSQ Project Stock Total

MYMP LIFO Period Stocks, Individual Material

I hope,it will help you

<=<< Sharing Knowledge is a way to Innovative >>=>

By,

Yoga

Former Member
0 Kudos

Check in table MARD

and Fields are

VMLAB for unrestricted stock

KZILS BLOCKED STOCK

VMUML for stock in transit

former_member581212
Active Contributor
0 Kudos

hi,

Check table MVKE..

regards

Priyanka.P

shyam_shinde2
Contributor
0 Kudos

SEE TABLE -MARD-Storage Location Data for Material

murugan_mgl
Active Contributor
0 Kudos

HI,

Try this

S_P00_07000139