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

how to get the details of inventory (raw matl, finish good etc..)

Hi!

how can we get the details of the raw material, finished goods( both qty and value) wherein the value should match with the financial F.01

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 16, 2010 at 12:33 PM

    Hi ,

    You can get the same from transaction Code MB5L .. but you will get consolidated figure for the valuation class /GL account wise . You will not get the same , material wise ..

    Also , another problem is that the report shows figure for the current date.. you cannot display the same for the fhistorical date .

    For our client , we created a ABAP Report .. where we have the data as per MB5L .. but it has break-up .. material wise ..

    Please sit with your ABAp er and FIO person.. if you want a report similar to MB5L with each material selections and historical values..

    Please revert back for any further clarifications..

    Regards

    Sarada

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2010 at 12:36 PM

    Hi,

    Check with T-code MC.9...........Hope this may help you...........

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2010 at 12:37 PM

    you can get the details from 'list of Stock values: balances',

    execute trnx MB5L,

    here, the value in Stock account is equal to F.01 ..

    Double click on the Value to get the Stock updates.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2010 at 12:48 PM

    Hi,

    Use t.code: MB5L & execute.Now you will have report with G/L accounts for Raw material Inventory, Semi finished Products Inventory and Finished Product Inventory, just double click individual G/L account, you will get stock with value with valuation area.

    Or check table MBEW

    Regards,

    Biju k

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      As you said the values are matching at company level but under Individual plant level the figures are not matching. This is because you defined YOUR VALUATION AREA IS PLANT , so you are getting all value in plant level.

      You can cross check your valuation area is plant & it is (all plants ) assigned in OMWD with valuation grouping code.

      Regards,

      Biju K

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.