Entering content frameFunction documentation Product Drilldowns Locate the document in its SAP Library structure

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 Structure link Drilldown Reporting in the cross-application topics.

Example

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?

Example

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.

 

Note

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.

 

Example

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

 

 

Leaving content frame