Using Fiori apps Project Cost Overview and Project Cost Line Items for Project Reporting
With SAP S/4HANA 2022 FPS1 new dedicated apps for Project Cost Reporting in private cloud/on Premise were introduced for Project System. The apps enable you to monitor actual and planned costs of a project and its WBS elements, the assigned networks, and plant maintenance orders with header account assignment. With SAP S/4HANA 2022 FPS2 support for internal orders as well as support for actual postings for statistical WBS elements has been added.
The planned costs are derived from the central financial planning table (ACDOCP), actual costs are derived from the universal journal (ACDOCA). This blog will introduce the apps, explain the features and provide an insight into the considered data. Both apps are included in the Project Financial Controller role.
Note: For planning cost for projects in ACDOCP, you can either use the Fiori app Import Financial Plan Data (F1711), integration scenarios leveraging an API to write the values e.g. when planning financials via SAP Analytics Cloud or by using the integration of Easy Cost Planning (see also this blog) or Network Costing into ACDOCP.
Project Cost Overview (F6991)
Filters can be used to adjust the data set that is displayed, filter criteria include cost-related filters (e.g. plan category for plan costs, controlling area, G/L account hierarchy, posting date etc.) as well as object-related filters (e.g. Project Definition, WBS Element or orders).
Cost-related filters are used to define the cost line items selected from ACDOCP or ACDOCA. For plan cost the plan categories the following application types and usages are supported:
- Periodic Planning & Consolidation: No Specific Usage, Project Budget
- Project Management : Easy Cost Planning for Projects, Network Costing, Project Reporting
- Maintenance Order
- Virtual Plan Category
Virtual plan categories are used to dynamically combine the data of different plan categories and are maintained in Customizing Controlling -> General Controlling -> Planning -> Maintain Category for Planning with application type 08 Virtual Plan Category.
In the second step Controlling -> General Controlling -> Planning -> Assign Plan Categories to a Virtual Category, existing plan categories are assigned to the virtual plan category, e.g. in the example below the virtual plan category is assigned to plan categories for Ongoing Plan (PLN), project-related (Network Costing and Easy Cost Planning) as well as maintenance order related plan cost. All assigned costs get aggregated to the virtual plan category and will be considered in the reporting.
In addition object-related filters can be used to restrict the project objects and assigned orders in the hierarchy of the project cost overview report. You can filter on WBS element, network, maintenance or internal order.
Setting a filter on WBS element or network will include the selected WBS element(s), it’s direct parents in the hierarchy as well as the network (in case of header assigned networks), network activities (in case of activity assigned networks), network activity elements and assigned internal orders and maintenance orders. Selecting an internal or maintenance order will display the order(s) and the parent hierarchy.
Filtering on a WBS Element includes the cost of the selected WBS Element and its assigned orders only, but not the cost on higher level WBS elements or WBS elements that are children of the filtered WBS element. Filtering on a network or other orders will only consider the elements of the network, i.e. cost which are posted to a WBS element that are not considered.
When selecting multiple object filters, these will be interpreted in the selection as a AND condition when Selecting the data, i.e. when entering e.g. a WBS element AND Network AND Internal Order the result set will always be empty.
When an object filter is set, only the cost of the selected objects are considered for display. As in the below example a filter is set to 2 networks of the project, here only the cost of the Networks, their Network activities and elements are displayed. Costs of WBS elements (e.g. in the below example, there are 5000 EUR planned on WBS element E-09051.2.2) are not displayed, due to the filter on networks.
The costs can either be analyzed using an aggregated or non-aggregated view. To see the total cost, you can use the aggregated cost view in which the cost of WBS elements, assigned networks and orders are aggregated by the project hierarchy as displayed in the example below. By default cost are displayed in global currency while additional user-specific currencies can be added via the settings, object currency is currently not supported. The app displays the cost in different currencies and calculates the variance, giving a visual indication if the variance is positive or negative.
All internal settlements, including settlements from assigned orders to WBS are excluded from the report to enable analysis of the full project costs.
For analysis of the cost situation for a single object, use the non-aggregated view, where the costs will be displayed at the level of the account assignment object without aggregation.
In both views the same functions and navigations are available. You can navigate to related apps by clicking on the object link in the hierarchy you get a list of further navigation options for the particular object. The project hierarchy can be expanded/collapse either directly in the tree, via the expand/collapse all or via the expand to level button. For expand to level (available only as of SAP S/4HANA 2022 FPS2), you can use a value between 1 and 99, whereas 1 will only display the project header in a collapsed state. The entered value can be saved as part of the variant.
For navigation to the Project Cost Line Items app, select a single WBS element object or multiple other objects via checkbox. The selected objects are passed as filter criteria in the object-related filter when starting the Project Cost Line Items app. When navigating from the aggregated cost view, the selected object(s) and all lower-level objects will be displayed in the Project Cost Line Items app; for non-aggregated view only the selected accounting object(s) are considered.
Project Cost Line Items (F6992)
The Project Cost Line Items provides a detailed view on the planned costs and actual costs line items for a selected project and the assigned entities. The app provides filter capabilities and a configurable chart and table area for analysis of the line items.
Similar to the filters described for the Project Cost Overview, the Project Cost Line Items app also offers cost-related and object-related filters
In addition to the filters described for the Project Cost Overview, you can use more detailed filters for the selected G/L account hierarchy, e.g. to narrow the search to leaf nodes of the hierarchy (cost component) or individual G/L account(s). If you want to reduce the results table to just display a specific plan category or actuals only you can use the category description filter.
The filter include settlements controls if settlement postings are considered in the result set.
If it is set to No only settlements from external senders which are not assigned to the project (e.g. cost center, not assigned orders) are shown. Costs settled from or within the project are not included in the result set and the overall value shown matches the value shown in the project cost overview.
If you set it to Yes all settlement costs including settlements within or from the project are shown.
Object-based filtering supports filter on projects, WBS elements, networks, network activities as well as internal and maintenance orders, the behaviour is aligned with what is described for the Project Cost Overview.
If you are using WBS element as a filter the Include WBS Hierarchy flag controls if only the selected WBS element (i.e. Include WBS Hierarchy = No) or also all child WBS elements (i.e. Include WBS Hierarchy = Yes) are displayed. In both cases the assigned objects are selected as defined in the Include Objects filter.
The Project Cost Line Items app uses the Fiori floorplan Analytical List Pages with a hybrid view, meaning it displays the result set in a configurable graphic and table area . More details on the features of the Analytical List Page can be viewed here.
The table area displays the line items selected based on the filter criteria. However the list of individual items shown in the table area also depends on the selected columns, i.e. the application automatically combines items in case no differentiating characteristic is shown in the table. Besides the standard features provided by the tableview of the analytical list page you can use navigation to related apps to view the details of e.g. journal entries or objects.