Line Item Tables 

Definition

The line items for the business transactions that are transferred to or entered in the special purpose ledger are stored in the line item table. Managing a line item table within a table group is optional.

Use

The line item table is used in the following cases:

·        If you want to enter data directly in the FI-SL system. For example, if the data comes from external systems or is used exclusively by the FI-SL system.

·        You want to create a detailed audit trail for the document that is posted to the FI-SL system.

·        If you want to store line items for your rollups. For example, to reverse the rollup after execution and/or to drill down from the rollup totals data to the original data in reporting.

Using the line item table you can display the individual documents from the original application and from the FI-SL system. By storing documents in a line item table, you can also access the documents and display detailed information in the FI-SL system.

In Customizing for Special Purpose Ledger, you can define at which levels an FI-SL line item database should be updated:

·        For a company

·        For a ledger

·        For a ledger/transaction combination

·        For a ledger/company code or ledger/company combination

·        For a ledger/company code/transaction or ledger/company/transaction combination

·        For a transaction

The line item table is updated when you set the line item indicator at one of the above-mentioned levels in the system (company, ledger, and so on). However, the line item table is only updated for the selected object(s).

If you set the line item indicator for a specific transaction (for example, RFBU), only documents with this transaction update the line item table.

One data record is written in the line item table for each line item. How often you set the line item indicator configuration is irrelevant.

Structure

The actual line item table contains:

·        Fixed Dimensions

You cannot change fixed dimensions.

Client, record number

·        Variable Dimensions

The variable dimensions are the same as those defined in the summary table.

·        Derived Fields

The derived fields are the same as those defined in the summary table.

·        Additional Fields

These optional fields are only defined in the line item table if you want to enter additional information for a document, for example, the line item description.

The plan line item table contains detailed information about the line items for plan documents in the FI-SL system. You use this table for storing plan data from previous plans, as well as changes to the plan data.

·        Fixed Dimensions

You cannot change fixed dimensions.

Client, record number

·        Variable Dimensions

The variable dimensions are the same as those defined in the summary table.

·        Derived Fields

The derived fields are the same as those defined in the summary table.

·        Additional Fields

These optional fields are only defined in the line item table if you want to enter additional information for a document, for example, the line item description.

Table GLREFP (only for local ledgers) is an example of a plan line item table delivered with the standard system. If you want to use this table in your system, you have to copy it and change it in accordance with your requirements.