Vendor Comparison re Purchase Values
Vendor Comparison re Purchase Values
Technical name: 0PUR_C01_Q0013
Based on InfoCube:
0PUR_C01Use
This query enables you to identify discrepancies between the values of goods as per the purchase order and the values invoiced or received.
Filter
|
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
 0VTYPE |
Value type (=ACTUAL) |
Freely-Defined Characteristics
|
InfoObject |
Description |
|
0PLANT |
Plant |
|
0PURCH_ORG |
Purchasing organization |
|
0MATL_GROUP |
Material group |
|
0MATERIAL |
Material |
|
0CALMONTH |
Calendar year/month |
Rows
|
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
|
0VENDOR |
Vendor |
Columns
|
InfoObject |
Description of InfoObject (or Restriction or Calculation Formula) |
| 0PO_QTY |
PO quantity |
| 0ORDER_VAL |
Purchase order value |
| 0INVCD_AMNT |
Invoiced amount |
| 0GR_VAL |
GR value in local currency |
|
Invoiced PO value in percent = invoiced amount / order value * 100 |
|
|
Open invoiced PO value = order value - invoiced amount |
|
|
Order value received in percent = GR value in local currency / order value X 100 |
|
The following additional queries are available for purchasing data: