Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Abinathsiva
Active Contributor
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.

  1. for getting Price Determination Structure – FM CKM8N_DOCUMENT_REPORT

  2. Cost components           - FM CKM8N_DOCUMENT_REPORT_CCS

  3. 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....
13 Comments