7.1 A PPENDIX A. D ATA S OURCE R EFERENCE
This section describes the measures found in the newly developed SAP data sources.
7.1.1 FM Funds Management Commitments & Actuals Line Items (Document Journal) [Detail]
Data Source Type: BEx Query
This data source contains detailed transactional line items from the FM module. The line items contain actuals and commitments, without budget key figures. It will yield a set of results similar to the SAP Document Journal reports. This data contains real postings as well as statistical postings, so you must ensure that you are filtering the records should you choose to use the “Raw actuals”
Below is a description of each of the measures used in the query.
Measure Description
Purchase Requisition
Commitments The Purchase Requisition Commitments measure includes only amounts where funds have been committed/encumbered via Purchase
Requisitions Purchase Order
Commitments
The Purchase Order Commitments measure includes only amounts where funds have been committed/encumbered via Purchase Orders
All Commitments This measure includes the sum of both PR and PO commitments, as well as all other forms of commitments that can be entered in the FM module.
Parked FI Docs This key figure allows you to include the budgetary impact of parked journal entries in your report. Though these haven’t yet been posted, there may be value in reporting on these “expected” amounts.
Statistical Postings Statistical postings in this model represent those postings in the FM module that don’t carry real value. Because FM is the “Budget” module, you will find that postings to balance sheet accounts (commitment items) are considered statistical in FM.
Actuals This measure represents actual amounts recognized through various business processes.
Other Non-Actuals This is a junk measure that includes all value types that weren’t used in the previous measures. It should be zero in all cases for the City of
Page 40 Updated: 2/11/2016
Measure Description
Portland SAP implementation, but it is included should the city’s implementation change.
7.1.2 FM Funds Management Budget to Actual Figures [Medium]
Data Source Type: BEx Query
This data source contains aggregate Budget, Actuals, and Encumbrances data for the most commonly used FM account assignment dimensions. It does not contain detail to the document number or line item grain (because budget is not posted at that detail). Use this model when you must include budget figures in your reports.
Below is a description of each of the measures used in the query.
Measure Description
Purchase Requisition Commitments
The Purchase Requisition Commitments measure includes only amounts where funds have been committed/encumbered via Purchase
Requisitions Purchase Order
Commitments
The Purchase Order Commitments measure includes only amounts where funds have been committed/encumbered via Purchase Orders
All Commitments This measure includes the sum of both PR and PO commitments, as well as all other forms of commitments that can be entered in the FM module.
Parked FI Docs This key figure allows you to include the budgetary impact of parked journal entries in your report. Though these haven’t yet been posted, there may be value in reporting on these “expected” amounts.
Statistical Postings Statistical postings in this model represent those postings in the FM module that don’t carry real value. Because FM is the “Budget” module, you will find that postings to balance sheet accounts (commitment items) are considered statistical in FM.
Actuals This measure represents actual amounts recognized through various business processes.
Other Non-Actuals This is a junk measure that includes all value types that weren’t used in the previous measures. It should be zero in all cases for the City of Portland SAP implementation, but it is included should the city’s implementation change.
Page 41
Measure Description
Raw amount This amount includes all value types in raw form. Using this measure without filtering value type in some way will yield nonsensical results.
7.1.3 CO Plans, Actuals, and Encumbrances [Medium]
Data Source Type: BEx Query
This data source contains data from the Controlling module aggregated to common account
assignments over an accounting period. This is where the best costing data can be found. If you will be reporting on projects data, this is the best source for costing data.
Below is a description of each of the measures used in the query.
Measure Description
Plan Planning amounts posted to cost objects.
Actual Actual amounts posted to cost objects.
Encumbrances Encumbered amounts posted to cost objects.
Raw amount This amount includes all value types in raw form. Using this measure without filtering value type in some way will yield nonsensical results.
7.1.4 FI General Ledger Line Items [Detail]
Data Source Type: BEx Query
This data source contains line item details from the FI module. It will yield results similar to FAGLL03 reports in SAP ECC. This data model will be useful for financial reporting on Accounts Payable, Accounts Receivable, or any manually entered journal entries. Line items include accounts of all kinds, both income and expense, but also balance sheet accounts. Use this data when reporting using modified or full accrual bases of accounting. There are no budget figures in this model. There are no statistical postings in this model – postings to STBU (or other statistical orders) will be reflected in the same line item as its underlying cost center (as in the SAP FI module).
Below is a description of each of the measures used in the query.
Measure Description
Amount This amount includes the total of both debit and credit postings. This is not an account balance (unless you include the postings from the beginning of time).
Page 42 Updated: 2/11/2016
Measure Description
Total Debit Postings Only debit postings.
Total Credit Postings Only credit postings
Quantity Quantities posted (if relevant).