Skip to Content
Technical Articles

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.

  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….

8 Comments
You must be Logged on to comment or reply to a post.
  • 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.

  •  

    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

    • Code is not public, Definitely I can help you in all means. This I have collected from various community Question and answers as mentioned in Blog and developed the custom report.

      • I see. Thanks for Answering..I would appreciate if you could just add to your blog post for everyone how to get the data for one item only using the mentioned FMs...