cancel
Showing results for 
Search instead for 
Did you mean: 

0CO_OM_WBS_6 (showing negative amounts)

Former Member
0 Kudos

Hello, I am trying load cost around Project using the 0CO_OM_WBS_6 datasource. I am storing this data in the 0COOM_C02 cube. When I run the report in BW to see the cost around a Project, it's showing the opposite amout of what R/3 shows. For example, r/3 transaction shows $9,000 (positve) and BW will show $9,000 - (negative). Do you know why this is happening? In R/3, I am using the transaction S_ALR_87013532.

Am I using the wrong datasource for getting cost around Project?

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Sam,

The datasource transfers correct values and is being used by thousands of companies.

I guess that maybe S_ALR_87013532 uses reverse sign or something - it might depend on the column header and many other things. Did you try to change the sign setting for the key figure in the query designer? If you set it as "Reverse Sign" is your BW report correct?

BR

Stefan

Former Member
0 Kudos

Hi Stefan,

do I need to do the "reversal" in the query? Is that how all these people using this? Do you use this datasource?

Thanks.

former_member181964
Active Contributor
0 Kudos

Hi

Check in CJ* Tcodes in TSTC Table and use the requred TCode.

Eg: CJ30 like that.

Thanks

Reddy

Former Member
0 Kudos

Hi Surendra,

I want to understand how the Keyfigure "SWG"(Amount) is fetching data from "WKG" "WOG" "WTG".


Is SWG the total of values "WKG" "WOG" "WTG" ?

For example:

"WKG= 10,000.00

"WOG=13,529.00

"WTG"= 13,529.00.

The value should be 37058 but it is taking only "13,529.00". from table COVP

http://help.sap.com/saphelp_bw33/helpdata/en/27/3d4acd8ae7574f8de1f72e100d16f6/content.htm

Please let me know what is the calculation behind it .

Thanks,

Bobby.

former_member199630
Contributor
0 Kudos

Hi Sam,

Have you done a check extractor in the RSA3 T-Code in R3? Do you see also a negative value?

Did you see the mapping in the Update Rule or Transformation? is it a direct mapping?

Take a look to the extractor [0CO_OM_WBS_6|http://help.sap.com/saphelp_nw04/helpdata/EN/27/3d4acd8ae7574f8de1f72e100d16f6/frameset.htm], there you can see each field from what tables are coming, and what it is the relationship.

Regards, Federico

Former Member
0 Kudos

Federico, I also see negative values in RSA3. Am I using the correct datasouce for getting cost around Prjects?

Thanks.

former_member199630
Contributor
0 Kudos

Hi Sam,

Have you try using T-Code CJI3 in R3 to tie out the data?

Anyway, I think it is the correct datasource, I checked in help of SAP, there is other datasoruce, this one provides more data (plan, actual and commitment). Take a look to the links below, and try to see the tables from the datasource extract the information.

0CO_OM_WBS_1 WBS Elements: Costs

This DataSource provides all costs and quantities (plan, actual, and commitment) of the WBS element

http://help.sap.com/saphelp_nw04/helpdata/EN/28/92a0311a36a640a48820ec3bbf4d90/content.htm

0CO_OM_WBS_6 Actual Cost Line Items (DELTA)

This DataSource provides the actual costs and actual quantities of the WBS element.

http://help.sap.com/saphelp_nw04/helpdata/EN/27/3d4acd8ae7574f8de1f72e100d16f6/frameset.htm

Regards, Federico