Line Item Reports

Definition

Detailed view of the individual business transactions from a Funds Management viewpoint in table format.

Use

You use line item reports if you want to look at the data available at document level. You can then branch from the report list to the document display transaction by double clicking.

Structure

Various types of line item reports are delivered in the Funds Management application component:

Budget

Budget reports identify all budgeting documents in ascending order. This way you can see how a particular budget came about. These reports are therefore particularly suitable for monitoring the budgeting process. They cannot be used to display how much budget a particular FM account assignment actually has.

Commitments/Actual

These reports evaluate commitments and actual documents. Funds Management differentiates the data according to how advanced processing is in the system. All data entered up until the point of invoice receipt or invoice issue is commitment data (such as purchase orders and purchase requisitions). All other data is actual data.

Commitments/Actuals for the Assigned Budget Budgets

These reports show all commitment/actual postings for annual or overall budgets for an assigned value.

If the FM account assignment posted to and the budget object element do not match (for example, because of the setting selected in Customizing and definitions in the budget structure, budget is only available at a higher hierarchy level), the Commitments/actuals for assigned budget report can, unlike other reports, identify the posting and funds assignment. In this report, the budget object element is displayed at the top of the page. The subsequent line items refer to the FM account assignments posted to, which have contributed to the formation of the assigned value.

Commitments/actual postings are recorded in two places in the system: As the assigned value within availability control and as commitments/actuals within budget execution. The total of the commitment/actual values posted must match the assigned value on the budget object element assigned to these FM account assignments posted to. In the report Commitments/actuals for the assigned budget, it is possible to display both values for each individual budget object element and to compare them to each other.

For the FM account assignments which were posted to but have not received any budget, the commitment/actual values are accumulated and compared with the current budget for the FM account assignment which also has the funds assignments. The value of the assigned budget must therefore correspond to the commitment/actual value.

In addition to that, the report commitment/actual for assigned budget can be used to perform a deviation analysis of commitment/actual values and assigned values. To do this, you select Only diffs betw. assigned budget and cmmts/actuals on the report selection screen. Only the budget object elements for which there are differences between the commitment/actual value and assigned budget are then listed in the report.

Integration

The line item reports reference the logical database F1F. You can use this logical database to create reports which meet your individual requirements.

The structure and description of the database can be accessed using transaction SE36.

You execute the line item reports for the budget and the commitments/actuals report using the ABAP List Viewer which offers you a number of advantages over the other reports as regards individual evaluations. You can for example control the selection and the list setup individually.

Note Note

The system displays the document number of the invoice in the line item display, in the area Commitment/actual and Commitment/actual for assigned budget. The document number of the invoice is also displayed for payments. Double-click a line with a payment line item to branch to the document display of the invoice.

End of the note.