Skip to Content

New Custom Report for Newly Created Materials.

Hi All,

I have posted a subject last week regarding this issue.

I would like to create a new report for materials created under the specified date range with details of, MATERIAL NUMBER, DESCRIPTION, PLANT, UNIT OF MEASURE, CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED.

Can you give me an idea how can I retrive all these data for a praticular Plant and Specified date range.

Thanks

John K.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2009 at 07:31 PM

    Dear,

    Seen last week post too. Checked but the selection is typical, like material number, description, plant, uom, price (Current procuremnet price) will be displayed in MM60. --- But only difference is Instead of CREATION DATE, it will gives LAST CHANGE date (basing on changes made to material master).

    Secondly, Previous price, date price changed - This is typical to choose. The price of material updated some times with manual adjustments and changes also took place with inforecord updates and revaluation. The typical is to retrieve this data. I feel that may be your ABAPer can help in developing customizing report with all these data for our (I guess).

    Regards,

    Syed Hussain.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2009 at 08:47 PM

    Hi John,

    If you want to develop cuctomise report with details of MATERIAL NUMBER, DESCRIPTION, PLANT, UNIT OF MEASURE, CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED, you can use tables like MARA (MATERIAL NUMBER, UNIT OF MEASURE, Material creation date), MAKT (DESCRIPTION), MARC (MATERIAL NUMBER, PLANT) and MBEW (CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED).

    You can pass creation date in MARA table from where u will get all the materials created between these dates then from MAKT u can get description for these materials. then Pass those materials to MARC to get the plants for which materials are extended. then based on material and plant (valuation area ) you can get CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED information.

    You check with ABAPer how to incorporate this logic in program.

    Regards

    Chetan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2009 at 09:35 AM

    Hi john,

    You will get these details from MM60 standard report.

    Material

    Plant

    Valuation Type

    Material Description

    Last Change

    Material Type

    Material Group

    Base Unit of Measure

    Purchasing Group

    ABC Indicator

    MRP Type

    Valuation Class

    Price control

    Price

    Currency

    Price Unit

    Created by

    Material creation date and chaged fields are mentioned below. took from MARA table.

    Material creation Date:- ERSDA

    Last Changed date :-LAEDA

    Anil patreddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 09:45 AM

    Hi John,

    You can also write a query yourself (ABAPer will not be required then) using SQVI Tcode.

    Join the following tables:

    MARA, MAKT, MARC, MBEW, MBEWH

    YOUR PROBLEM SHOULD BE RESOLVED.

    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.