on 10-14-2008 2:30 AM
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!
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
the proper way to do this is in your transformations.
use the formula on UOM field to tranform the Hours as single indicator like H or HR.
Eg: to change HR to H
IF ( 0UOM = 'HR', Substring (0UOM, ,1) , )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
Sorry, may be I didn't explain my problem well.
What we need is the conversion factor so that calculation will be correct. Example, if the transaction is posted with MIN (minutes) UoM, when we load this transaction into Cube, how can we convert it into Hour?
i.e. 45 MIN
If we replace the MIN into H (based on the IF logic you suggested), it will be 45 HR, which is wrong.
Do we have any function in BW that support this kind of conversion? What need to be done?
I know it is bit difficult (not possible in BW), but hope you can share some light.
Thank you.
I am wandereing that you are looking for this :
http://help.sap.com/saphelp_nw04s/helpdata/EN/1c/1b5d427609c153e10000000a1550b0/frameset.htm
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.