Skip to Content
author's profile photo Former Member
Former Member

Stock Check

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 10:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 01, 2013 at 10:58 AM

    Hi Vicky,

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

    Regards

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 10:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 10:23 AM

    Hi Vicky,

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

    Regards,

    Aish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 10:45 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 11:19 AM

    Dear Vicky,

    You can use MB5L 😊

    Best Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2013 at 12:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.