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

MM Reports- Pls advice

Dear Friends,

My client wants standard report for the following areas in MM

Overview of PO value per Requester

Product Category ID

Product

Vendor

Cost Center

Chart of accounts

G/L Account

Company code

Tracking Number

Requester

Transaction Type

Calendar Day

Approved Shopping Cart Value

Purchase Order Value

Cost Center Overview

Cost Center

Material group

WBS Element

Chart of accounts

Requester

G/L Account

Company code

Tracking Number

Purchase Order Value - Quarter

Shopping Cart Value - Quarter

Purchase Order Value u2013 Current Month

Invoice Value u2013 Current Month

Invoice Value Previous Year

Procurement Summary Report

Purchase Order No.

Supplier

Company code

Tracking Number

Shopping Cart Quantity in Shopping Cart Unit

Net Shopping Cart Value in Default Currency

Order Quantity in Base Unit

Net Order Value in Default Currency

Confirmed Quantity in Base Unit

Net Confirmed Value in Default Currency

Invoiced Quantity in Base Unit

Net Invoiced Value in Default Currency

Workload per purchasing group

ERP Purchasing Group

SRM Purchasing Group

Purchase Order No.

Product

Vendor

Calendar Week

SRM Purchasing Organization

ERP Purchasing Organization

Company code

Tracking Number

Processing Status

Product Category ID

Total Order Value

No. of Purch. Orders

No. of Order Items

Delivery Delays

Item No.in Order Doc

Limit GUID

Confirmation number

Item No. Confirmatn

Purchase Order No.

Name of PO

Invoice Number

Item No. in Invoice

Seq. No. Acct.Assign

Calendar Day

Company code

Delayed Delivery

Delivery Time (Purchase Order to Confirmation)

Date of Confirmation

Purchase Order Date

Invoice Date

Requested deliv.date

Confirmation document Overview

Confirmation number

PO number

Name

Approval Status of Goods/Service Confirmation

Processing Status Goods and Services Confirmation

Product Category

Product Category ID

Company code

Transfer Status Goods and Services Confirmation

Calendar Day

Number of Confirmed Items

Confirmed Value

Confirmed Quantity

Open Item (Confirmations)

Calendar Day

Product

Supplier

Catalog

Item No.in Order Doc

G/L Account

Company code

Tracking Number

Purchase Order Number

Name

Goods Recipient

Open Order Value

Open Delivery Value in %

Open Order Quantity

Excessive Invoices

Purchase Order No.

Name of PO

Calendar Day

Requester

Vendor

Item No.in Order Doc

Invoice Number

Company code

Tracking Number

Invoice value is too high

Open Item (Invoices)

Purchase Order No.

Name of PO

Calendar Day

Product Description

Product

Vendor

Material

Company code

Tracking Number

Item No.in Order Doc

Product Category ID

Open Invoice Value

Open Invoice Quantity

Variance Invoice Value/Order Value

Product

Product Description

Vendor

Calendar Day

Purchase order number

Name of PO

Company code

Product Category ID

Requester

Order Quantity in Base Unit

Net Order Value in Default Currency

Expected Net Order Value in Defalt Currency

Confirmed Quantity (BUoM) for Order Date

Net Confirmed Value in Default Currency for Order Date

Quantity Variance Confirmation

Price Variance Confirmation

Invoiced Quantity (BUoM) for Order Date

Net Invoiced Value in Default Currency for Order Date

Quantity Variance Invoice

Price Variance Invoice

Deadline monitoring u2013 Current values of required delivery date

Requested Deliv.Date

Purchase Order No.

Name of PO

Product Description

Product

Vendor

Requester

Purch. Organization

Product Category

Product Category ID

Company code

Tracking Number

Perform to

Performed from

Open Order Value

Open Delivery Value in %

Net Order Value in Default Currency

Expected Net Order Value in Defalt Currency

Net Limit in Default Currency

Net Confirmed Value in Default Currency for Order Date

Net Invoiced Value in Default Currency for Order Date

Purchase order status

Processing Status of Purchase Order

Purchase Order Number

Transaction Description

Calendar Day

Category

Product Description

Company code

Item No.in Order Doc

Product Category

Product Category ID

Order Value

Order Quantity

Net Limit

Unit Price

Purchase Order per product/product category (UNSPSC)

Product

Processing Status of Purchase Order

Company code

Product Category ID

Name

Calendar Day

Purchase Order No.

Product ID

Item No.in Order Doc

Vendor

Net Order Value in Order Currency

Order Quantity in Base Unit

Unit Price

Net Limit

Kindly help me in getting MM standard reports for the above funtionalities.

Product means --> material

Product ID means--> material ID

Product category ID, UNSPSC means--> material Group

Confirmations means--> Goods reciept

Thanks in advance.

Regards,

William

Edited by: william wales on Aug 24, 2011 6:09 AM

Edited by: william wales on Aug 24, 2011 6:12 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 24, 2011 at 04:16 AM

    Hi William,

    Check all the MM reports in T-code SAP1 ans SAP2 , check if any report statisfies your requriment if no, go for development of custom report with the help of your technical report.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2011 at 04:48 AM

    Hi

    Here are some std. reports in SAP check if it is useful

    MM Reports

    Materials Management: Master Data Reports

    *Master Data *

    MM03 Display Material Master

    MK03 Display Vendor u2013 Purchasing

    MK04 Purchasing Vendor Changes

    XK03 Display Vendor u2013 Central

    XK04 Central Vendor Changes

    ME1L Info Records by Vendor

    ME1M Info Records by Material

    ME1P Purchase Order Price History

    ME1E Quotation Price History

    ME13 Display Info Record

    ME14 Display Info Record Changes

    ME03 Display Source List

    ME04 Display Source List Changes

    MEQ3 Display Quota Arrangement

    MEQ4 Display Quota Arrangement Changes

    MKVZ Display Purchasing Vendor List

    MKVG Display Vendor Condition Groups

    MSC3N Display Batch

    MEKA Display Purchasing Conditions

    MN03 Display Message Condition u2013 RFQ

    MN06 Display Message Condition u2013 Purchase Order

    MN09 Display Message Condition u2013 Scheduling Ag.

    MN12 Display Message Condition u2013 Delivery Sched.

    MM60 Display Materials List

    Materials Management: Procurement and Stock Reports

    *Logistics Information Reports (Stock) *

    MCBA Plant

    MCBC Storage Location

    MCBE Material

    MCBR Batches

    MC.9 Material Stock

    MC.A Material Receipts / Issues

    MC.B Inventory Turnover u2013 Material

    MC.1 Plant Stock

    MC.2 Plant Receipts / Issues

    MC.3 Plant Inventory Turnover

    MC.5 Stock u2013 Storage Location

    MC.6 Storage Location Receipts / Issues

    MC.7 Storage Location Inventory Turnover

    *Purchasing Information System *

    MCE1 Purchase Group Analysis

    MCE3 Vendor Analysis

    MCE5 Material Groups Analysis

    MCE7 Material Analysis

    MC$G Material Purchasing Values

    MC$I Material Purchasing Quantities

    MC$O Material Frequencies

    MC$4 Vendor Purchasing Values

    MC$6 Vendor Purchasing Quantities

    MC$: Vendor Frequencies

    MC$0 Purchasing Group Values

    MC$2 Purchasing Group Frequencies

    MC$< Material Group Purchasing Values

    MC$> Material Group Purchasing Quantities

    MC$E Material Group Frequencies

    Purchasing Reports

    ME80FN General Analysis of Purchasing Documents

    ME81N Analysis of Order Values

    ME23N Display Purchase Order

    ME53N Display Purchase Requisition

    ME5A List Display Of Requistions

    ME33L Display Scheduling Agreement

    ME39 Display Delivery Schedule

    ME43 Display RFQ

    ME4L List RFQ by Vendor

    ME4M List RFQ by Material

    ME4S List RFQ by Collective Number

    ME48 Display Quotation

    ME2L Purchasing Documents per Vendor

    ME2M Purchasing Documents per Material

    ME2K Purchasing Documents by Account Assignment

    ME2W Purchasing Document by Supplying Plant

    ME2V Expected Goods Receipts

    MD13 Display Planned Order Single

    MD16 Display Planned Order Collective

    Invoice Reports

    MB5S List of GR/IR balances

    MIR6 Invoice Overview

    MIR4 Display Invoice

    MIR5 Display Invoice List

    Stock Reports

    MMBE Stock Overview

    MB51 Material Document List

    MB03 Display Material Document

    MB54 Vendor consignment stocks

    CO09 Material Availability

    MB5C Batch Where Used Pick Up List

    Physical Inventory Reports

    MI22 Physical Inventory Document u2013 material

    MI23 Physical Inventory Data u2013 material

    MIDO Physical Inventory Overview

    MI03 Display Physical Inventory Document

    MI06 Display Count Document

    MRP Reorder Point

    MD21 Display Planning File Entries

    MDRE Planning File Entries Consistency Report

    MD04 Stock Requirements List

    MD05 MRP List Material Display

    MD06 MRP List Collective Display

    MD07 Stock Requirements List Collective

    Thanks

    Edited by: Nijamudeen**MM on Aug 24, 2011 10:18 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2011 at 06:33 PM

    thank you so much

    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.