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

How to generate a report in MM

Hi All,

1. I want to generate a report in MM(Material Management) into excel where I can see the comments of my Purchase orders where I mentioned in Header Text, Header Note. Is it possible? If yes please let me know how to do that.

2. I want to generate report where It shows PO creation Date and the Delivery Date of the PO.

3. I want to generate report where what ever PO's I created It should show me what are all the ERS(evaluated Receipt System) Vendors and which are all the Non-ERS vendors.

4. I want to generate report where what ever PO'S I created all have the Tax code.

These reports I want to export in Exce....... Please suggest can I run these reports in 1 report or how many I can club.....

Please advise..

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 02:10 AM

    Check

    ME2L

    ME2M

    ME2C

    ME2B

    ME2N

    ME80FN

    You have the option top export to excel as well

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 05:06 AM

    Hi ,

    1. I want to generate a report in MM(Material Management) into excel where I can see the comments of my Purchase orders where I mentioned in Header Text, Header Note. Is it possible? If yes please let me know how to do that.

    --> For the above requirement you will have to develop a 'Z' report with the help of ABAPer

    2. I want to generate report where It shows PO creation Date and the Delivery Date of the PO.

    --> PO creation date is available in standard reports like ME2L , ME2M. However for delivery date you will have to customize a 'Z' report.

    3. I want to generate report where what ever PO's I created It should show me what are all the ERS(evaluated Receipt System) Vendors and which are all the Non-ERS vendors.

    -> This report is not available in Standard SAP.

    4. I want to generate report where what ever PO'S I created all have the Tax code.

    -> This report is not available in Standard SAP.

    All the above requirement of yours can be clubbed in a single report by developing a 'Z' report with the help of ABAPer.

    Regards

    Swapnil Iyer

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks!!!!!!! for your answer. However we developed the z reports I can customise pleae tell me the T codes where I need to run. We developed reports like ZME80FN,ZSE16 Plese let me know the T codes.

  • Posted on Aug 23, 2011 at 05:06 AM

    Hi dear,

    Standard SAP dont provide such a single report which will give u all the deatails that ur looking for.

    U have to create ur own Z report with the help of ur ABAP er. Refer various PO tables such as EKKO,EKPO,EKET,EKAN,etc

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2011 at 05:12 AM

    Hi

    There are some std reports in sap

    Purchasing Reports

    ME80FN General Analysis of Purchasing Documents

    ME5A List Display Of Requistions

    ME33L Display Scheduling Agreement

    ME4L List RFQ by Vendor

    ME4M List RFQ by Material

    ME4S List RFQ by Collective Number

    ME2L Purchasing Documents per Vendor

    ME2M Purchasing Documents per Material

    ME2K Purchasing Documents by Account Assignment

    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.