More Reports: Line Items

Line item reports enable you to analyze posted values in detail. The line items in the reports are based on the items of documents generated by postings. Line item reports are available in the following areas:

Product Cost by Order
Product Cost by Period
Product Cost by Sales Order

You can access the original documents (such as the FI or MM document) from the individual items in the report ( Start of the navigation path Environment Next navigation step Source Document / Accounting Document End of the navigation path ).

In Cost Object Controlling, line item reports are of limited importance because the posting amounts from production confirmations are generally high, making analysis at the line item level worthwhile only in exceptional circumstances.

You can restrict the line items displayed through the cost element or cost element group and by specifying a time frame.

Line item reports are available for the following account assignment objects:

Manufacturing Orders

Line items actual
Line items for WIP calculation
Line items variance
Line items commitment

Product Cost Collectors

Line items actual
Line items WIP calculation (if the corresponding settings in the results analysis version were made, see also Prerequisites)
Line items variance

Sales Document Item

Line items actual
Line items for results analysis
Line items commitment

Line item reports are supplied with a predefined layout. You can also create custom layouts so that you can see other fields of the CO line item, such as the value type. You can usually display all the fields of the Controlling document in the line item report. These fields are grouped into:

Account assignment
Time characteristics
References
Value key figures
Technical fields
Organizational units
Partner account assignment
Object
Other objects
Quantity key figures
Investment management
Not assigned

Integration

By default, only actual line items are updated. Line items in WIP calculation, results analysis and variance calculation, and for commitments are only updated if they are activated in Customizing for the application.

If you want to write the commitment values to the sales order items that carry costs and revenues, you must set the with commitments management indicator in the fiscal-year-dependent control parameters of the controlling area.

Line items for results analysis data of WIP calculation and results analysis are only saved if you have set the appropriate indicator in Customizing for the results analysis version.

Line items for variances are updated if you switch on the update of line items in the variance key.

Check the following settings in Customizing:

Results analysis version for the lines items of WIP calculation and results analysis
Variance key for the line items of variance calculation
Order type – commitments management for line item commitments
Control parameters of the controlling area

Prerequisites

Line items for WIP calculation, results analysis, and variance calculation need to be updated in your live system. For this reason, make sure the relevant indicator in Customizing is set.

Manufacturing Orders

Line items for WIP calculation
Line items for WIP calculation are only updated if the corresponding setting has been made in Customizing.

You make this setting in Customizing for Product Cost by Order under Period-End Closing Work in Process Define Results Analysis Versions . Go into Extended Control.
Line items for variance calculation
Line items for variance calculation are only updated if the corresponding setting has been made in Customizing.

You make this setting in Customizing for Product Cost by Order under Period-End Closing Variance Calculation Define Variance Key .
Commitment line items in orders are only updated if you have activated commitments management for the controlling area and order type.

Product Cost Collectors

Line items for variance calculation
Line items for variance calculation are only updated if the corresponding setting has been made in Customizing.

You make this setting in Customizing for Product Cost by Period under Period-End Closing Variance Calculation Variance Calculation for Product Cost Collectors Define Variance Key .

Sales Document Item

Line items for results analysis
Line items for the results analysis are only updated if the corresponding setting has been made in Customizing.

You make this setting in Customizing for Product Cost by Sales Order under Period-End Closing Results Analysis Define Results Analysis Versions . Go into Extended Control.

More Information

A detailed description of line item reports can be found in the documentation Overhead Cost Controlling.

For information on commitments, see:

Commitments

For information on actual costs, see:

Actual Costs in Cost Object Controlling

For information on WIP calculation and results analysis, see:

Work in Process in Product Cost by Period

Work in Process in Product Cost by Order

Results Analysis

For information on variance calculation, see:

Variance Calculation

For information on performance improvement, see:

Performance in Product Cost Controlling