Product Drilldowns
Use
The product drilldown is a tool for interactive evaluation and presentation of data in Product Cost by Period and Product Cost by Order.
Examples of characteristics used in data summarization are material, plant and product groups. This enables you to see data at a higher level (such as all planned costs and actual costs for a particular order type) and then go to a deeper level of that dataset (such as the planned costs and actual costs for the individual orders).
Product drilldown reports offer easy-to-use functions for navigating in the dataset (such as the next level, or the next object within a level). There are also a number of interactive functions in the report (such as hiding columns, sorting within a column, top node selection, and so forth).
Since product drilldown reporting is based on the same technique as drilldown reporting in Profitability Analysis (CO-PA), you can find detailed information on navigation functions in the documentation
Drilldown Reporting in the cross-application topics.
You have a report that summarizes the data by the characteristics plant and material.
Suppose you manufacture materials M1 and M2 in plants A and B (i.e., each material is manufactured in both plants). With product drilldown you can analyze them from different perspectives:
Which materials accounted for which production costs in plant A?
Plant A
– Material M1 USD 1000
– Material M2 USD 3000
What were the production costs for material M1 in the two plants?
Material M1
– Plant A USD 1000
– Plant B USD 6000
Integration
You can go from the characteristic level Material to a product drilldown report with the additional characteristic Order. This enables you to see the data for all orders for a material.
From there you can call up a cost element itemization for a single order.
Prerequisites
The following points refer to the use of product drilldowns:
Import Product Drilldown Reports
Import the product drilldown reports of the standard system in Customizing for Product Cost Controlling under Information System
® Cost Object Controlling ® Settings for Summarized Analysis/Order Selection ® Product Drilldown ® Import/Transport Reports ® Import Reports.Import Form
You also import the form 7GLOBALVARIS (global variables) in Customizing for Product Cost Controlling under Information System
® Cost Object Controlling ® Settings for Summarized Analysis/Order Selection ® Product Drilldown ® Import/Transport Reports ® Import Forms.Create Product Group Type
The characteristic product group is used in the drilldown reports in the standard system. The value of this characteristic can be derived in different ways. You specify the method by selecting a product group type. If you want to use the characteristic product group type, choose the product group type that you want to use in Customizing for Product Cost Controlling under Information System
® Control Parameters .You can find more information under
Product Groups in Product Drilldown.Check Cost Component Structure for Product Drilldown
You create a cost component structure for displaying cost elements grouped into cost components in the Information System. You must first create this cost component structure in Customizing for Product Cost Planning for the Information System. You specify this cost component structure in Customizing for Product Cost Controlling under Information System
® Control Parameters.
Why is a special cost component structure needed here?
Work in process is derived from the results analysis cost elements for both objects with settlement type "Periodic" and objects with settlement type "Full settlement". If the results analysis cost elements are not assigned in the cost component structure for product drilldown, the work in process appears in the cost component Other (if defined) or as not assigned.
Check Order Types for Summarization of Product Drilldown
Check the order types that are to be summarized in the data collection, and change them if necessary in Customizing for Product Cost Controlling under Information System
® Control Parameters.
Create Your Own Reports
If the reports provided in the standard system do not meet your requirements, you can define your own reports.
You define reports in Customizing for Product Cost Controlling under Information System
® User-Defined Reports. There you can also access information on the procedure for doing so.Data Collection Run
Execute a data collection run to select current data for your reports.
If you later change the product group type, the cost component structure, the order types to be summarized, or other settings, you must then execute the data collection run for the entire time frame in order to update the dataset.
For more detailed information on the Customizing activities, see the Implementation Guide for the Product Cost Controlling Information System.
Features
The standard system provides a number of drilldown reports designed to meet your requirements.
Each standard drilldown report is supplied as a periodic report and as a cumulative report.
Periodic Reports
In this format the report key figures are by period. These reports are useful for fast navigation between periods and are intended for monthly reporting. These reports also offer a view of up to 16 past periods for each combination of characteristics.
To call up the report, enter the plant if you want to limit the selection to a particular plant.
You must enter the period/fiscal year that is to be at the beginning of the report. You can use the arrows Next Column and Previous Column to go from one period to the next. The selection screen includes the specified period and the 15 preceding periods.
Two views can be selected:
The detail list for a periodic report shows the same key figures in the columns as in the drilldown list. However, the detail list shows all 16 available periods for the selected object. The drilldown list shows the values of the selected characteristic.
Drilldown List
January 2000
Material (Characteristic) |
Planned costs |
Actual costs |
ROH1 ROH2 ROH3 |
100 140 120 |
120 200 130 |
Detail List
Characteristic: ROH1
Period |
Planned costs |
Actual costs |
January December November |
100 1040 1320 |
140 200 130 |
Cumulative Reports
Cumulative reports show you summarized values for a specified time period. You specify this time period when you access the report. For example, you can see the key figures for:
Enter the following data:
In a cumulative report, the detail list and the drilldown list offer you a similar result as with periodic reports. Instead of reporting by periods, the values are reported by the categories debit, credit, settlement credit, delivery credit.
The standard product drilldown reports summarize the dataset across the following characteristics:
Cumulative Reports |
Periodic Reports |
Plant Product group Material Period / year Cost component |
Plant Product group Material Cost component |
See also:
Access to Drilldown Report with Characteristic Order Differences in the Summarization Methods