Multiple material cost components report with SQVI

[Former Member]

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