STEP 1

Use the transaction KE30 and choose the report ZZZ-SOLV01

 

 

Enter 

  1. the reporting currency = 10
  2. the period
  3. the company code
  4. the plant code
  5. the IECRA (when applicable)
  6. select : "Classic drilldown report"

 

 

 

STEP 2

To have the detail of the value field D47 Ec/T030 => click on the amount, right click and select "Line items" or click F9

 

 

 

STEP 3

Use the lay out /D47 PPV to have the variance by material code

 

 

 

 

STEP 4

Explain the main variances

Display the standard costing of the material with CK13N. 

Enter :

  1. The material & plant code
  2. The costing variant
  3. The validity date

and   

The standard cost of the material code 128715 is

18 099,12 CNY / 1 000 kg

 

 

STEP 5

Display the actual purchase price of the same material with the transaction MB51. 

Enter:

  1. the material code 
  2. the plant code
  3. the movement type = 101 to 102
  4. posting date = 1 month

 

 

The list of purchase orders to be analysed is displayed

 

 

STEP 6

Display a purchase order to calculate the purchase price variance 

 

 


a - Quantity purchased

b - Purchase price

c - Delivery costs

d - TOTAL costs = b + c

e - Actual unit price = d / a

f - Standard cost (from CK13N)

h - Purchase price var = (f - e) / a