Vendor Comparison re Purchase Values 

Technical name: 0PUR_C01_Q0013

Based on InfoCube: 0PUR_C01

Use

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)

Free 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

Effective order value

0INVCD_AMNT

Invoiced amount

0GR_VAL

GR value in local currency

Invoiced PO value in percent = invoiced amount / effective order value X 100

Open invoiced PO value = effective order value - invoiced amount

Order value received in percent = GR value in local currency / effective order value X 100

 

The following additional queries are available for purchasing data: