MM Reports- Pls advice

[Former Member]

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

[former_member329706 · Accepted solution]

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.

[Former Member]

thank you so much

[Former Member]

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