on 06-21-2016 3:03 PM
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 UNIT | TARGET UNIT | FACTOR |
kWh | MWh | 0.001 |
kWh | MJ | 3.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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.