PO, Goods Receipt, & Invoice Variance report

[Former Member]

Experts,

Is there a transaction, report, or tables to build a query that could give me the Purchase Order Value$, Goods Receipt Value$, and Invoice Value$ for a specific time period? I want to find the variance between all three, thanks for your help.

[Former Member · Accepted solution]

HI

These are some std reports in MM

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

[Former Member]

Thanks

[Former Member]

hi.......

table name ekbk is the exact table where u get all the details like PR PO GR and IR value and quantity

and for pending PO GR and Invoice value and quantity t code me2l selection parameter WE103

hope this solve ur problem

thanks

neha

[Former Member]

hi.......

table name ekbe is the exact table where u get all the details like PR PO GR and IR value and quantity

and for pending PO GR and Invoice value and quantity t code me2l selection parameter WE103

hope this solve ur problem

thanks

neha

[Former Member]

sorry its table name EKBE

[Former Member]

Hi,

Other way is get PO document byME2Lor ME2M . In PO click on PO history, this will give MIGO and MIRO details. ME80FN Won't give period specific report. Criteria can plant, material number.Thanks.

Edited by: Padmasri Garapati on Sep 16, 2011 9:07 AM

[former_member223262]

Refer Tcode ME80FN click on Change Veiw & select Purchase Order History with this you can get PO-GRN-INVOICE Qty & Value details

[ravindra_devarapalli]

CAN YOU TELL ME WHERE THAT BUTTON CHANGE VIEW

[former_member223262]

Last button on Application tool Bar it is in line of filter, total etc icons

[Former Member]

Hi,

As such there is no standard report in SAP to fulfill your requirement. To get PO, GR, invoice values in a report, build a query by combining the tables of PO,MIGO and MIRO in SQVI.

Tables for PO: EKKO, EKPO, EKBE

Tables for MIGO: MSEG, MKPF

Tables for MIRO: BSEG, RBKP and BKPF. I hope this will resolve you issue. Thanking you.

Edited by: Padmasri Garapati on Sep 16, 2011 6:01 AM

[Former Member]

Nick,

build a query / report using EKKO, EKPO and EKBE. EKBE has all the details of GR and IR and you can compare the two for a given PO item.

Thanks

Mira

[Former Member]

This message was moderated.