Cost roll-up issue and impact with Value Category / Cost Element Assignment

[Rima]

Hello experts,

Thought posting this message in finance might give me a solution as the issue is related to PS (my core area of expertise) and fianance:

We’re having issue with cost not rolling up to WBS / Project level in hierarchy reports like CN41N and CN41, for the projects that are settled to objects like WBS element, network, or order. I’ve raised an OSS message earlier to SAP and they told to assign all available cost elements to a value category in CJVC and run CJEN (entire reply is attached towards the end of this message). I tried this, but this is not resolving the problem (cost roll-up to WBS / Project level).

Then what I did is I just assigned the settlement cost elements to value categories in CJVC and ran CJEN. This fixed the cost roll-up issue. But we’re worried that if we assign only the settlement cost elements and remove all other assigned cost elements in CJVC might bring some new issue in other areas (like transactions in finance, PS). Having said this, here are my questions:

1. Can the cost roll-up issue be resolved without assigning only the settlement cost elements to value categories in CJVC?
2. If we have only option of assigning the settlement cost elements to value categories in CJVC to resolve this cost roll-up issue, is it going to affect other areas (like reports / transactions in Finance, PS)?

************************************************** ************************************************

Reply from SAP:

Please adjust your value category customizing according to the followingsettings:

1) In transaction CJVC, all yellow and/or red lights have to eliminated
by assigning each cost element/commitment item/statistical key figure according to the following rules:

1.1) Each cost element/commitment item/statistical key figure should
be assigned to a value category, EVEN if its values should NOT
be updated to table Project Information Database, table RPSCO.
In this case please create an assignment to a value category
and activate its 'suppress' indicator. All values basing on an
assignment to this value category won't be updated to RPSCO.

1.2) 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.

1.3) Only
1.3.1) cost elements of the same cost element type,
1.3.2) commitment items of the same item category and
1.3.3) statistical key figures of the same unit of measure
and the same KF category are allowed to be assigned to
one value category. Mixed assignments will lead to
unpredictable results, like mixing costs and revenues in
columns or rows.

2) If all yellow and/or red lights in transaction CJVC are eliminated,
please rebuild the Project Information Database (table RPSCO) by
transaction CJEN. Without this, changes from 1.1)-1.3) won't have
any effect.

3) Please rebuild the assigned values by transaction CJBN.


Thanks in advance for your inputs.

Rima