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

Valuation Type with material list as on date

Hi Guys,

Business needs a T.Code where they need to reflect the material list with valuation type as on date. I am confused on what or which table we should use? Also even we create new Z-report with matl n valuation type, we also need there Company code, plant as well.

Do we have any such standard Transaction code meeting the requirement? If not then which fields we may select? Pls help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 19, 2016 at 12:55 PM

    Its not as on date, its as today in MBEW. Once you open the table you will understand which fields you have to select.

    You could have find this answer with a search.

    If you need historic by Year and period: MBEWH.

    Use report MM60 and change the layout to include Valuation type.. You will get what you want.

    Regards

    Anand

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 01:15 PM

    In table MSTA you will find the creation date of a view per organization, based on that an ABAPer will be able to "calculate" which views existed per date.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      MSTA n MM60 I can look out for but how to get the total receipt, total issue quantity of the same material with their respective dates? Pls help

      Since Business is asking for the following:

      Input Data

      Material

      Plant

      Storage Location

      Material Type

      Output Data

      Material

      Material Description

      Material Type

      B UOM

      Valuation Class

      Valuation Type

      Storage Location

      Stock

      Price

      Plant

      Total Receipt

      Total Issue

      Last Receipt date

      Last Issue date

      Last Receipt Qty

      Last Issue Qty

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 06:49 AM

    MSTA n MM60 I can look out for but how to get the total receipt, total issue quantity of the same material with their respective dates? Pls help

    Since Business is asking for the following:

    Input Data

    Material

    Plant

    Storage Location

    Material Type

    Output Data

    Material

    Material Description

    Material Type

    B UOM

    Valuation Class

    Valuation Type

    Storage Location

    Stock

    Price

    Plant

    Total Receipt

    Total Issue

    Last Receipt date

    Last Issue date

    Last Receipt Qty

    Last Issue Qty

    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.