Material Price analysis report – CKM3N – Costing cockpit for Multiple Plants / Materials
Quick intro:
This blog explains to get consolidated Price analysis for materials. This business requirement made me to work around and triggered me to write this blog. MIS team of any FMCG/ Manufacturing industry require this tool to analysis cost of Production / overheads etc.,
Obtainable:
Material Price analysis report / Price History View report CKM3N/CKM3 is used to analyse the price consumed for a particular Material in a plant along with overheads.
SAP Standard report has the restriction to draw the report with 1 Material, 1 Plant & 1 Period at a time.
Business Requirement/Understanding/Presentation :
Many organisation/people ( especially in manufacturing industry ) to do the analysis on material price to be drawn across all plants & Material at one go for a period. This has become a major requirement of all Costing & profitability analysis team and MIS team. To fulfill the need/demand from the team I have developed a comprehensive report/tool with below parameters & options..
Comparable view of CKM3N for multiple materials/plants has been achieved through below mentioned function Modules.
- for getting Price Determination Structure – FM CKM8N_DOCUMENT_REPORT
- Cost components – FM CKM8N_DOCUMENT_REPORT_CCS
- Material Ledger data – FM MLCCS_KEPH_MLCD_READ
CALL FUNCTION 'MLCCS_KEPH_MLCD_READ'
EXPORTING
it_kalnr = it_kalnr
i_from_bdatj = p_bdatj
i_from_poper = p_poper
i_to_bdatj = p_bdatj2
i_to_poper = p_poper2
IMPORTING
et_keph_mlcd = it_final.
Screen shot below describes the report/tool which was build with ALV containers which can be drawn with bifurcated view of both Consolidated & detailed break-up of Cost component split & ancillary component split for each materials.
This new report been consumed by our costing team & appreciated…..which resulted in managing the cost across plants at a single go….
Conclusion:
Presently this tool is developed using report structure, Developer/functional people who are having the requirement as “Organisation which needs their overhead/manufacturing expenses based on production plant/Material wise”. can go through this..
Further for any clarifications please comment so, that same can be explained in detail….
Useful Abhinath! Thank you
Hi Abhinath,
I am also having similar requirement to do in 1809 hana box.. I was trying to check the FM referred here; could not find the table MLREPORT with entry for the material i am looking for. Can you please help whether the same FM’s are useful in 1809 hana box too.
Hi Shruthi,
Will check and revert by checking alternate FM for HANA..
I am looking for this information too. CKM3N has changed dramatically in HANA 1809. Our previous developed report has changed and is not giving true values.
We are waiting for you Abhinath!
Hi Ahamed
Sorry for delay in response will try find the FM for above requirement.. right now I too don’t know about Hana FM
Abinath. S