cancel
Showing results for 
Search instead for 
Did you mean: 

Unit Conversion

0 Kudos

Hi,

Please help me with the design for my requirement detailed below:

The unit from the source needs to be converted to selected unit in report. I know this can be achieved by creating conversion types in RSUOM but my issue is that the conversion factors are neither stored in T006 nor we can create an infoobject like 0MATERIAL and store the conversions in a DSO.

I get the conversion from a DB connect source as below:

SOURCE UNITTARGET UNIT FACTOR
kWhMWh0.001
kWhMJ3.5

I can create a datasource on the DB connect view and store the data in a Infoobject or DSO. But I am not sure how can I get these data to do the conversion at report level.

Any thoughts ??

In the meanwhile I am evaluating if I can achieve this by using Formula Variables. and dont tell me that this can only be done by VKFs

Thanks,

Dinesh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

If it is just two UOMs, you can create those UOMs in BW system directly (CUNI) and try to maintain the conversion factor.

Thanks

Francis

0 Kudos

There are around 400 records!

Also it can not be loaded to CUNI because the length of unit field is 3 in standard SAP but from DB Connect we are getting units with length 4.

Former Member
0 Kudos

in that case you will not be able to use even the dso/info object approach.

your best option would be to implement your own version of UOM conversion in the transformation routine using the conversion factor data from your dbconnect source system. the drawbacks you have in converting during data load will apply, you will have to find a way to work around those.

Thanks

Francis

0 Kudos

Any possible way to do the conversion during reporting ?

Former Member
0 Kudos

UOM conversions can get tricky. so you would need a ABAP routine to handle those complexities.

but you know the data better, if you think all conversions are just simple c = a * b type of conversions then you can probably do it through a CKF and a formula variable (with replacement path).

Thanks

Francis

0 Kudos

Thanks a lot for the help.