Multiple material cost components report with SQVI

Hi

As you know with t.code MLCCSPD can see cost component per material.

Sometimes you need see Multiple Materials in SAP Standard there is no this report .

with Join table CKMLHD, CKMLPRKEKO , CKMLPRKEPH in SQVI you can create multiple material cost component report.

1- Go SQVI and create on the quick viewer.

Note:  Data source -Table join

Insert table: CKMLHD, ,CKMLPRKEPH,CKMLPRKEKO

from ckmlhd select Material Number , Price determination

from CKMLPRKEKO select base unit , Lot size

Lot size show you  per how many material cost component calculated

from CKMLPRKEPH select  posting date yyyy,posting period, type of perice ( this field show you : standard,periodic unit price , ….)

Currency type and valuation view, Currency key and cost filed 1 to 40 ( this difficult steps because you don’t no cost component header and in result you must create correct layout)   

Execute

Note:  in field Type of price you can choise Period unit price ( this actual perice if M.L run) standard price , …)

Indicator lower level must null like picture. 

Material Price determination = 3

Execute one material  for  proving

Now Execute for on period

Result