on 05-21-2007 12:54 PM
All,
In S012 table we can find the field 'posting period -SPBUP' . What is this stands for ?
How values can come to this field ?
In my case no values are coming in this field .
Kindly advise.
regards
hello,
the mean of SPBUP-Period to analyze - posting period
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Althea,
Thanks for this information .
But whether yours is a monthly report .
I believe you will sume up of Variance GR + Variance IR and get the final PPV .
But if GR happened in April for a material and IR in May , then which month the added PPV will come .
If in April PPV is coming for that material , it will be wrong , isnt it?
Kindly advise.
regards
Hi,
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.
Steve B
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.
Regards
Hi,
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.
This sort key / Allocation key is quite useful.
Steve B
Dennis,
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)
Hope this helps some
Althea
User | Count |
---|---|
106 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.