Line Item Database and Rollups

Use

You can also define whether a rollup should update the line item database. If a rollup updates the line item database, a line item is written for each record that is rolled up.

When line items have been written to the line item database for a rollup, you can reverse the rollup .

Using rollup line items, you can also drill down from the summary rollup data to the original data stored in the source ledger.

In the following steps, you can define whether a rollup should update the line item database.

Creating a Rollup Header

Execute Rollup

The line item update information you entered in the rollup header is proposed as a default when you execute a rollup.

Note Note

If line items are not created, you cannot reverse the rollup.

If you do not plan to reverse the rollup (or if you are rolling up large quantities of data), you should leave the Write line items indicator blank to avoid unnecessary database updates. Line item updates are only useful in exceptional cases and slow down processing dramatically. For the reasons listed below, line item updates are not normally necessary:

End of the note.

  • They can overwrite existing data

  • They can reset data

For more information, see Creating a Standard Rollup Header and Drilling Down to Rollup Line Items .

To post line item data for rollups, you must install a line item database for your 1) actual rollup data, and 2) plan rollup data. For more information about installing line item databases, see the Implementation Guide (IMG) for Special Ledger .