How to generate a report in MM

[Former Member]

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..

[Former Member]

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

[former_member533946]

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

[Former Member]

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

[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.

[Former Member]

Check

ME2L

ME2M

ME2C

ME2B

ME2N

ME80FN

You have the option top export to excel as well