How to Create Drill-Down Reports for the Material Ledger

  • by Mehulkumar Patel , Senior System Engineer, Conagra Foods
  • June 26, 2015
Learn five key steps to create drill-down reports in the material ledger so that you can view actual costing information for all materials in one plant or for all materials in all plants assigned to all company codes at same time.
Learning Objectives

By reading this article, you will learn how to:

  • Maintain key figures and a global variable
  • Create, change, or display forms
  • Create, change, or display reports
  • Run a report
Key Concept
In the material ledger, it is very important to understand the Material Price Analysis transaction (transaction code CKM3N). This transaction displays all the material ledger-related transactions for one plant or material.

In the Material Price Analysis transaction (transaction code CKM3N) of the material ledger, you can view transactions of only one plant or material at a time as shown in Figure 1.


Figure 1
The Material Price Analysis screen
 

However, sometimes you want to see actual costing information for all materials in one plant or for all materials in all plants assigned to all company codes at same time. I explain how to create similar reports for all plants or materials with drill-down functionality in your SAP system. If you have this information, you can easily reconcile your trial balance inventory with the material ledger actual inventory. I walk you through the following steps:

  1. Maintain key figures
  2. Maintain a global variable
  3. Create, change, or display forms
  4. Create, change, or display reports
  5. Run a report

In the “Transaction Code Tips” sidebar, I pass on some tips to use when you want to create transports for reports or forms or create a client copy for reports or forms.

The five steps listed above are the same as those for creating Report Painter or Profitability Analysis (CO-PA) reports, but for the material ledger, SAP provided a new set of transaction codes. These transactions codes are not found in the SAP Easy Access menu or in an SPRO path. You have to remember them. I explain which transaction code to use for each step that I describe.

Mehulkumar Patel

Mehulkumar Patel is a senior system engineer and certified SAP controlling (CO) consultant with approximately 10 years of experience in SAP FI/CO. He has done multiple end-to-end SAP implementations of SAP applications. He holds bachelor’s and master’s degrees in computer science and an MBA in finance. He also is certified in SAP CO.

 

See more by this author


Comments

9/30/2015 5:44:48 AM
MWH Allanhe

Thank you for very informative and instructional article.
Are you able to give any advice in terms of reporting where we could drill down to the component level in the above report? We are looking to retrieve information on components which are driving the highest influence in actual costing terms on Assemblies entered in the selection parameter.
Your thoughts will be greatly appreciated!

Please log in to post a comment.

To learn more about subscription access to premium content, click here.