Show TOC

Work Breakdown Structure Element Period Cost By Value Category QueryLocate this document in the navigation structure

Use

The query view for WBS element cost based on the value category is WBSElementPeriodCostByValueCategoryQuery.

This virtual data model provides the prerequisites for answering the following business questions:

  • Extract the total planned, actual, and commitment costs for each WBS value category for a selected date range

Structure

To support the analysis possibilities listed above, this query view contains the following grouping of reuse views:

  • Provides the total planned, actual, and commitment costs for each WBS value category for a selected date range (WBSElementPeriodCostByValueCategoryQuery)

    • Provides planned and actual costs for a certain duration (ProjectPeriodCostItem)

    Measures and Attributes

    Some important measures and attributes are:

    • Provides the total planned, actual, and commitment costs for each WBS value category for a selected date range (WBSElementPeriodCostByValueCategoryQuery)

      • Key attributes in this view include WBSElement, Project, ControllingArea,

      • Key measures in this view include

      • Variables used to narrow down the selection of data:

        V_SAPClient — (single value, single entry, mandatory)

        V_Project — (interval, multiple entries, mandatory)

        V_WBSElement — (interval, multiple entries, optional)

        V_PlannedBdgtPlngVersion — (single value, single entry, optional)

        V_ActualBdgtPlngVersion — (single value, single entry, optional)

      • An input parameter P_ControllingValueTypeForCmtmts is provided that supports the values 21 and 22 for controlling value types.

    Used Tables and Views

    This view selects data from the following tables and views, for example

    • ProjectPeriodCostItems

More Information

For more information about auto documentation, see Auto Documentation.