Cost Element Value Categories for Hierarchy Reporting (PS and PM)
This document was created to assist the consultant in creating “Cost Clement value categories for Project reporting for standard SAP hierarchy reporting. I discovered that my cost elements were not assigned to the Value categories.
Value Categories are used to group cost for Standard SAP Hierarchy reports. The following are among the cost/revenue/payment values available for Value Category reports:
- Sales order
- Results analysis
- Internal business volume
- Transfer price
- Orders for projects
- Overall plan
The PS (Project Systems) Value categories work for PS ‘hierarchy’ reports only, and not for Cost Element and line item reporting. Value categories are used to report Cost, Revenues or specific Statistical key figures (SKF’s). All Cost Elements should be Assigned a group or range of Cost Elements to the Value Categories for cost reporting within PS.
Validate the Cost Element Value Categories, by displaying the exiting Value Category assignments to determine the next step:
- Is each Cost Element assigned to at least “one” Value Category?
- Which category does the Cost Element belong?
- Are there enough “Value Categories” to assign
the Cost Elements?
- Check this by using T-Code CJVC
Once, the unassigned Cost Elements have been identified, the next step is to assign these Cost Elements to a Value Category.
Meet with the Accounting Manager or Controller to receive reportingguidance on how the Cost Elements should be categorized. The primary components of assigning Cost Element/s to a Value Category require the following:
- Cost Element- Determine the type of Cost Element to create with the following transactions
- FS00 for General Ledger accounts – click “edit Cost Element” button to create primary, revenue and the external settlement
- KA01 to create Cost Element
- KA06 for creating secondary Cost Elements
- Cost Element Group – classify Cost Elements with similar characteristics and to reduce data volume
- KAH1 to create Cost Element Groups – to classify Cost Elements with similar characteristics
The following components (Nodes) are required to create the Cost Element group. Each node has exactly one parent node (predecessor). The “depth” (the level) of the node corresponds to the number of its predecessors increasing up to the root of one. This means that the roots have level 1.
- Cost Element
Create/Edit Value Category – OPI1 = configuration for Project systems Value Categories and OIK1 configuration for Plant Maintenance
When editing the “Value Category” ensure you are in the correct component, as some companies have multiple components in this example there are two.
Next select the Value Category to edit:
For this example select External Services. Assign Cost Element to the Value Category – OPI2 = configuration
Next step is to enter the Cost Elements that will be assigned to this Value Category. This can be done in two ways. The recommend method is #1
- Cost Element groups – The grouping of Cost Elements with similar characteristics. The Cost Element group is entered in the Value Category data field. Remember to update the Cost Element group when there are changes to the Cost Element.
- Individual Cost Element assignment – Enter a single value or a sequence using the “to” “from” data fields.
Once the Cost Elements have been assigned to a Value Category, execute CJVC to ensure all Cost Elements have been assigned. If any Cost Elements are unassigned return to Step 1.