Skip to Content
Author's profile photo Ali Akbar Mirnia

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.

/wp-content/uploads/2016/06/1_972882.png

Note:  Data source -Table join

/wp-content/uploads/2016/06/2_972953.png


Insert table: CKMLHD, ,CKMLPRKEPH,CKMLPRKEKO

/wp-content/uploads/2016/06/3_972954.png

/wp-content/uploads/2016/06/join_972955.png

from ckmlhd select Material Number , Price determination

/wp-content/uploads/2016/06/4_972965.png

from CKMLPRKEKO select base unit , Lot size

Lot size show you  per how many material cost component calculated

/wp-content/uploads/2016/06/5_972966.png

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)   

/wp-content/uploads/2016/06/6_972967.png

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

/wp-content/uploads/2016/06/7_972974.png

Execute one material  for  proving

/wp-content/uploads/2016/06/8_972975.png

Now Execute for on period

/wp-content/uploads/2016/06/9_972976.png

Result

/wp-content/uploads/2016/06/10_972995.png

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kamal Kumar SAP Consultant/Trainer
      Kamal Kumar SAP Consultant/Trainer

      Very good for any consultant required this type of report...

      Only one request if you can make the cost field header with description like material,Lab etc as per CCS

      Kamal

      Author's profile photo Ali Akbar Mirnia
      Ali Akbar Mirnia
      Blog Post Author

      Hi Kamal,

      You can add Table MAKT for material description .

      But I suggest if you want to deploy fields write the program  with your ABAPER based this DOC tables.

      Ali Mirnia

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      Good document.

      Thanks

      Author's profile photo Mohammad Mousavi
      Mohammad Mousavi

      Well Done !

      Author's profile photo DIVYESH BHARUCHA
      DIVYESH BHARUCHA

      Deal Ali,

      For me, I have been looking for this report for very long time. Excellent document.

      I have just added CKMLPP-LBKUM.

      A million thanks for such descriptive notes.