Line Item Reports - SAP Documentation

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.

Features

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/Actuals

This reporting evaluates Commitment and actual documents. Funds Management differentiates the data according to how advanced processing is in the system. All data which is 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.

The commitment/actual line item reports are based on report Document Journal (RFFMEPGAX). Depending on the initial transaction, the initial screen is reconciled to the line item selection. You can use Business Add-In FMRM_ACCOUNT_AUTH to implement authorization checks for displaying customer, vendor and G/L accounts when displaying FI posting data. For more information, see the report documentation

Note Note

Two lines are always displayed for postings that have been affected by Year-end closing . One of the lines shows the amount type Carryforward previous year (commitments) and the first special period (such as 13) for the old fiscal year, while the other line shows the amount type Carryforward subsequent year (commitments) and period 1 for the new fiscal year. These documents are saved in the database in period 000 . It is indicated in the field Year-end closing transfers , if a posting belongs to the year-end closing.

The field Year-end closing transfers is found in the line items segments of logical database FMF and it is therefore available for user-defined reports. In the line item reports delivered in the standard, this field is contained in the field list.

End of the note.

Commitments/Actuals for the Assigned Budget

These reports show the relationship between commitment/actual values and assigned values.

If the posted FM account assignment and the budget object element do not match (for example, because budget is only available on a higher hierarchy level), the report commitments/actuals for consumed budget 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.

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

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

Moreover, the Commitments/actuals for budget report enables you to analyze the differences between the 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. In addition, the value for the current budget is identified in a third column.

Other special features of reports for Commitments/actuals for assigned budget:

There are no separate reports for payment and commitment budget. You can decide on one of the two reports on the report selection screen.

Unlike most of the reports delivered, these two reports are not based on the SAP List Viewer, which means they cannot be extended using display variants.

Integration

The line item reports reference the logical database FMF. You can use this logical database to create reports, which meet your individual requirements. For details, read Executing Your Own Reports with the Logical Database .

For the structure and description of the database, call up transaction SE36.

You execute the line item reports for the budget and the commitment/actual report using the SAP List Viewer which offers a number of advantages over other reports as regards individual evaluations: for example, you can control the selection and list structure as you wish. See SAP List Viewer for more information.

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.