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 😊