If you are using standard pricing to control your materials then you can generate the PPV report from the price variance GL. This is especially useful if you set the sort key (allocation key) to be the material number.
All price variances hit the PPV account and if each posting has the material number in the allocation field then the report should be easy to obtain (even using the standard GL enquiries).
If you use MAP for your materials this solution does not work.
Our report is run for any specified period of time, usually one week at a time, and reviewed.
A large GR Variance tells us that either the Wrong Price is on the PO or the Standard should be changed.
A large IR Variance tells us that either the Wrong Price is on the PO (this will off set with the GR Variance) or the vendor is not charging us what was agreed to.
Both are important pieces of information.
Our report is written so that we can see whether in entry is GR or IR and we can subtotal it by PO and line item so that GR/IR variances will net to the Total. If we see that the GR and IR are not in the same month, we run the report for the specific material, vendor, or Purchase order so that we get the total Variance.
I have been tasked with developing a PPV report and in reading your reply it sounds like you have completed this. I was wondering if you could share the details of the report i.e. tables, processes. Any information would be appreciated.
One way to get a PPV report is to make sure that the sort key (allocation key) used by the PPV GL account, is set to contain the material master record number. (Most of the time this is set to contain the posting date which is useless because the posting date is captured anyway)
This way the standard enquiries against this GL can be sorted intomaterial number sequence.
In at least one of the companies I have been involved in, this was sufficient detail for the PPV report / enquiry.
Our requirements included netting PPV by material by Purchase order (GR and IR) and by Vendor.
I had a very excellent ABAP programmer who took my requirements, helped me spec it and we came up with a report that we try to never touch the program.
BSEG was the main table, Purchase order was found in BSEG-EBELN. the material number and all material master data was referenced from the Purchase order. The Acct Doc number identified Invoice vs GR vs journal entries. We also searched BSEG for all the line items in the Acct documnet and brought the value of the inventory posting and the clearing account into the PPV report. Each account number that we wanted to report on was specified in the program. Then material master data was included - price control, standard, Purchasing Group, special procurement key. The report is ALV so it can be subtotaled, filtered, sorted.
These are the other tables that we used:
EKBE
EKPO
MARC
MARA
MAKT
MBEW
EKKO
We have used this PPV report for 5 years now. It was written in 4.0 and came through the conversion to 5.0 with minimal adjustments required (to everyone's relief)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.