Lead Columns (SAP Library - Cost Center Planning (CO-OM-CCA))

Lead Columns

Use

When you enter planning data, and are using multiple lead columns, the R/3 System displays the overall total for all entries in the planning layout. You can also select the following:

Total

The system displays a subtotal for each characteristic of the lead column.

If, for example, there are two lead columns and you choose Total, the system adds up all value fields across the characteristic of the other lead column.

An exception to this are planning layouts with only one lead column. As standard, the R/3 System does not display an overall total. To display the overall total, choose Total

Hierarchies

The R/3 System displays a subtotal for the hierarchy nodes to which the selected lead column characteristic belongs. The system also displays an overall total for the top node of the hierarchy. This overall total is comprised of the subtotals of the lower-level nodes.

If the planning layout only contains one lead column, you can choose either No total, Total or Hierarchy.

If the planning layout contains more than one lead column, that is, there are multiple characteristic combinations possible for the lead columns, and you have selected Total for a characteristic, the system displays the subtotals for this characteristic by totaling the other lead column characteristics. The system displays these subtotals in addition to the characteristic combinations.

If you have selected Hierarchy for a characteristic, the system creates subtotals for the selected characteristic. It also adds up these subtotals along the hierarchy to which the characteristic belongs.

Note

You can set the display of subtotals as a default setting when you a define a planner profile during Customizing. You can change this settings for the length of the planning session when you enter the planning data in the application.

Example

You are using a planning layout with two lead columns. Cost center and cost element. The characteristic values of the cost center are: 4711, 4712, 4713. The characteristic values of the cost element are: 400000, 410000, 420000 . In the standard settings, the overview screen appears as follows:

Cost center	Cost element	Planning costs in CO area currency
4711	400000	10
	410000	20
	420000	30
4712	400000	40
	410000	50
	420000	60
4713	400000	70
	410000	80
	420000	90
*Cost center	*Cost element	450

The dialog box for setting the lead column display appears as follows:

Lead column	Hierarchy	Total	No total
Cost center			X
Cost element			X

If you have already entered values for all characteristics combinations, the planning overview screen appears as follows:

Cost center	Cost element	Value field 1	Value fields 2 etc.
4711	400000	10
	410000	20
	420000	30
4712	400000	40
	410000	50
	420000	60
4713	400000	70
	410000	80
	420000	90
*Cost center	*Cost element	450

If you choose Total for the cost center characteristic, the system displays the following:

Cost center	Cost element	Value field
4711	400000	10
	410000	20
	420000	30
	*Cost element	60
4712	400000	40
	410000	50
	420000	60
	*Cost element	150
4713	400000	70
	410000	80
	420000	90
	*Cost element	240
*Cost center	*Cost element	450

If you choose No total for the cost center characteristic, and Total for the cost element characteristic, the system displays the following:

Cost center	Cost element	Plan costs CAC	Plan costs TC
4711	400000	10
	410000	20
	420000	30
4712	400000	40
	410000	50
	420000	60
4713	400000	70
	410000	80
	420000	90
*Cost center	400000	120
	410000	150
	420000	180
	*Cost element	450

A group exists for the cost center characteristic, in which the characteristic values (cost centers) are assigned. The cost center group is structured as follows:

KOSTL

KOSTL1

4711

4712

KOSTL2

4713

If you choose Hierarchy for the cost center characteristic, and No total for the cost element characteristic, the system displays the following on the overview screen:

Cost center	Cost element	Value field 1	Value fields 2 etc.
4711	400000	10
	410000	20
	420000	30
	*Cost element	60
4712	400000	40
	410000	50
	420000	60
	*Cost element	150
KOSTL1	*Cost element	210
4713	400000	70
	410000	80
	420000	90
	*Cost element	240
KOSTL2	*Cost element	240
KOSTL	*Cost element	450

The overall total is the total of all the subtotals generated by the system for the characteristic for which you have selected Hierarchy or Total.

Note

The R/3 System always displays hierarchies bottom-up on the overview screen. The hierarchy levels are indicated in an additional column by a corresponding number of asterisks "*" (zero being the lowest hierarchy level).

Actions

To display subtotals and hierarchies in Customizing, as well as in the application component, choose Settings ® Lead columns.