UoM HR and H conversion
In the R/3 transaction, the UoM entered can either be H or HR. Example, I have the following two transactions entered for the same Workorder
in R/3:
Workorder...UoM...Actual Work
10005876....H..... 2.5
10005876....HR.... 3.3
When these transaction extracted into BW, I can see the following in PSA, and in the InfoCube as well:
Workorder...UoM...Actual Work
10005876....H..... 2.5
10005876....HR.... 3.3
I created the query for this and have the following display on the result also for the same Workorder:
Workorder...UoM...Actual Work
10005876....H..... 2.5
............HR.... 3.3
Question:
1) Is there a way how can I do the conversion of UoM in Query Designer so that when I display, I only have the following:
Workorder...UoM...Actual Work
10005876....HR.... 5.8
2) I guess a proper way would do the UoM conversion in the Update Rule, but how?
Please help, thank you!