Price Trends Over the Last Three Months (SAP Library

Price Trends Over the Last Three Months

Technical name: 0PUR_C01_Q0019

Based on InfoCube: 0PUR_C01

Use

This query allows you to examine the average price (per unit of measure) for materials in a material group. The average price enables you to draw conclusions about the negotiation skills of your purchasing organization, or, if you take the plant into account during valuation, about regional price differences.

To enable you to assess short-term price changes, you are always shown the average prices for the last three months (including the current month).

If you perform this evaluation in April 2000, the data for February, March, and April 2000 are evaluated.

Filter

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
0VTYPE = 10	Value type = Actual

Free Characteristics

InfoObject	Description
0PURCH_ORG	Purchasing organization
0PLANT	Plant
0VENDOR	Vendor

Rows

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
0MATERIAL	Material
0MATERIAL_0MATL_GROUP	Material group

Columns

InfoObject	Description of InfoObject (or Restriction or Calculation Formula)
0CALMONTH	Calendar year/month
0PUR_C01_CK008	Price

For the characteristic 0CALMONTH, a variable is used that selects data from the last three months (including the current month).