cancel
Showing results for 
Search instead for 
Did you mean: 

UoM HR and H conversion

p_m8
Participant
0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

p_m8
Participant
0 Kudos

Thank you.

Former Member
0 Kudos

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) , )

p_m8
Participant
0 Kudos

Though we're on BI7, but we're not using Transformation... we still use InfoSource and Update Rule.

As workaround, is there a way to do the conversion in the Query Designer?

Former Member
0 Kudos

Hi,

You can use this in 3.x data flow as well.

In update rules use the formula for UoM field.

If you want to apply in Query, there will be some VBA coding required. I m not sure though.

and the performance of the query will aslo be effected.

Cheers

Praveen

p_m8
Participant
0 Kudos

In BI7, I heard that we can do the conversion directly in Query Designer without any programing/ABAP code required.

Do you know how? Does anyone work on this before?

p_m8
Participant
0 Kudos

Sorry, my mistake, I want to convert the H to HR actually.

So how can we achieve this via the Formula that you mentioned in the Update Rule?

Please help, thank you.

BTW, do you know actually what is the difference between H and HR?

p_m8
Participant
0 Kudos

somebody please help me on this...:(

I need the solution urgently...

Former Member
0 Kudos

Eg: to change H to HR

IF ( 0UOM = 'H', 'HR', )

p_m8
Participant
0 Kudos

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.

Former Member
p_m8
Participant
0 Kudos

All,

Unfortunately not.

We would need to do the conversion in the Update/Transfer Rule... the incoming UoM can be in Day, Week, MIN but the output must be in HR.

How can we do the conversion in Update/Transfer Rule???

Please help...need to solve this urgently...