on 08-14-2014 2:25 PM
Hi,
Can you please help to understand the use for value category from OPI2/OPI8? In CJVC we have all cost elements assigned to cost element group and cost element group assigned to value category. What is this Value category?
Exista any table in SE16 which can export all value categories, cost element groups and cost elements? This is half PS and half CO.
Thank you.
Rodica
Hi,
the value category customizing is essential for PS reporting (see note 676123; following lines
are quotes from this note). :
...
Heading 1: Value category customizing
In the project information database the value category plays the role,
that cost elements, commitment items and statistical key figures have in
the controlling tables, report-writer reports / report painter reports
and line item reports.
The value category customizing controls this re-keying process from the
controlling tables to the project information database. It is essential!
This customizing must be set up correctly and completely. Otherwise you
will get unpredictably wrong values in the hierarchy reports, the
structure overview, earned value analysis and in the project planning
board.
....
Heading 1: * Project Information Database*
The *project information database *- table RPSCO - is the value table
(no quantities!) that serves as common database for:
o Hierarchy Reports
o Structure Overview
o Progress Analysis (earned value)
o Project Planning Board.
It contains values from controlling (costs, revenues, commitment) and
PS cash management (expenses, receipts, cash commitment, planned
payments ...).
For earned value analysis table RPSQT contains the necessary quantities.
The values in this table occur from statistical keyfigure records in
controlling.
That way you can design hierarchy reports that are able to report on all
these values in one single report.
...
The value categoy customizing is done using transaction CJVC. As stated in note 676123
....
1. Please use transaction CJVC to check your value category
customizing.
All red AND yellow lights shown there have to be eliminated
by correcting and completing your value category customizing. In order
to do that, please review your customizing following these guidelines:
a) Each cost element/commitment item/stat. key figure HAS TO BE
ASSIGNED exactly once to a value category. Assigning them to more
or less than one value category will lead to unpredictable
results.
b) This is nessessary EVEN, IF YOU NEVER WANT TO SEE those values.
In that case you can block the update to table RPSCO. To block
the update please create an assignment line to a value category
and activate the 'suppress' indicator on the assignment detail
screen.
c) Only
- Cost elements of the same cost element type
- Commitment items of the same item category and
- Statistical key figures of the same unit of measure and the
same key figure category
are allowed to be assigned to the same value category. Other
and/or mixed assignments will lead to unpredictable results like
mixing costs and revenues in columns or rows!
d) When you create the value categories, that replace the cost
element/commitment item/statistical key figure in the project
information database, check for the correct setting of the radio
button:
COSTS: for value categories meant to be used for cost elements of
type 1 ('costs'); for value categories meant to be used for
commitment items for expenses
REVENUES: for value categories meant to be used for cost elements
of type 11 or 12 ('revenues'); for value categories meant to be
used for commitment items for receipts.
If you want to assign STATISTICAL KEY FIGURES to the value
category, you indicate, whether the value category should contain
key figures with totals values characteristic or fixed values
characteristic.
These settings are valid for all cost elements/commitment
items/statistical key figures you assign to the value category.
2. If all red and yellow lights in transaction CJVC are eliminated,
please rebuild the Project Information Database (table RPSCO) by
transaction CJEN. Without this, changes carried out in your value
category customizing won't have any effect. That is necessary after
all changes in value category customizing, that affect values
already posted. Running CJEN is not dangerous.
3. Please rebuild the assigned values using transaction CJBN
afterwards, if you use budgeting.
4. Performance tip:
You can create more than one assignement line for one value
category. This is possible, because the assignment lines do not only
contain the controlling area and the value category but also a
counter (1-999).
If you assign cost elements or cost element intervals to the value
category instead of cost element groups, you save the time, that
otherwise would be consumed for the explosion of the cost element
group.
For being able to do that easily, please consider the following:
Please use allways the same number of digits for all cost elements
and revenue elements - to have a reserve eventually 1 or two digits
more than you initially need. The field for cost element is an
alphanumeric field and is lexically sorted. If you do not do it that
way, you will have problems defining intervals. So please use the
same number of digits for all cost elements. The same is for
commitment items and statistical key figures.
This setup should be checked regularly to make sure, that all values are
updated to the project information database in the correct way! There
should be a special focus on newly created cost elements / commitment
items / statistical key figures.
Regards
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rodica,
Check below table
TPIK3 - Assignment Table: Cost Elements -> Value Categories
RPSCO - Project info database: Costs, revenues, finances
Regards
Tushar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rodica,
Go through this note,
676123 - Project Information Database / Value Category Customizing
I believe it has all the required information you need.
Regards,
Gokul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.