cancel
Showing results for 
Search instead for 
Did you mean: 

Table for total planned hrs and total confirmed hrs in prodution order

Former Member
0 Kudos

Hi guys,

I am creating a report for which i need total planned hrs (set up + machine + any other) and confirmed hrs.

For eg., a production order has 10 qty. Standard values are Set up time is 20 min and machine time 5 min for a base quantitiy of 1. So here the planned hrs are 20 + (5*10) = 70 min.

In which table can i find this planned hrs. I can see the standard value in AFVV table. But what logic can i use for calculating the total planned hrs.

Is there any function module for this ?

Thanks

Srini

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

Do any guys give solution to this problem...

Thanks

Srini

Former Member
0 Kudos

Hi ,

Do any guys give solution to this problem... it is urgent..

Thanks

Srini

former_member184627
Active Contributor
0 Kudos

Hi Srini,

The following details are available in the table AFVV,

Standard value, operation qty & Base qty.

With this values create a formula Standard value * operation qty/ Base qty , this will equal to the planned hours for that particular activity type. Similarlt planned hours for other activities can be calculated.

The actual/confirmed hours are available in the table AFRU.

Regards,

Senthilkumar

Former Member
0 Kudos

Hi senthil,

Thanks for your reply. The problem in this formula, where setup time comes into picture. For setuptime we should not multiply by operation qty. So the same formula doesnot work. You know that the prod. order picks up std. values from workcentre. There may be many std. values. The position of setup time varies in the std. value depends on how we give in the workcenter. Now the problem is how we can identify "Setuptime" and give a formula for the setup time.

Hope u could understand this..

Thanks

Srini