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
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
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
Good document.
Thanks
Well Done !
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.