Skip to Content
0
Former Member
Feb 12, 2009 at 04:53 AM

calculate Hour per Unit

2288 Views

I have this project for almost a month now and I cannot find a solution:

The project is called PA HPU calculation.

  • *Actual HPU = Actual Hours / Actual Units*

  • I have a cube: hour Cube will give me the Actual Hours.

Actual Units will be calculated from a table that a replicate from R/3 called zcars.

the fields of the table are: category_type example(M5, M7, Z3, F8) and the builT_day which is the day in the month the cars are built. here our the tables look like:

Built_day | Category_type| Vinnumber

01/02/2008 M5 G555

01/02/2008 M5 L567

01/02/2008 F8 T433

01/03/2008 M5 R544

01/03/2008 Z3 h675

.etc..

How to find the Actual Units per months and put it in another cube to calculate the key figures Actual HPU? Do I have to design an ABAP program? I am very confused. I need help. Hope some one will help.