Material Price analysis report – CKM3N – Costing cockpit for Multiple Plants / Materials
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.,
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….
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….