Fields for Available capacity in SAP

[Former Member]

We are trying to generate Z report on Availabile capacity

Under normal transaction : by going in CR03 we can have Start time / Finish Time based on which we get operating time in hours, we need to capture the Avaialble capacity we are not getting this field in any SAP table

Max we go in KAKO by capacity ID of resource and get Start time, Finish Time , Breaktime in Seconds & % utilization how do i convert this in Hours,i have tried various combinations but it does not matches in CR03

Can anyone suggest how to convert this seconds or any other table from which i can get Availability Capacity in hrs

[Former Member]

Dear Bhavesh,

Check this logic,

Available Capacity = From table KAKO take the fields BEGZT(shift start), ENDZT(shift end) and PAUSE(break time),divide this

value by 3600 and you will get it hours.

For example if BEGZT - 25200,then 25200/3600 = 07:00:00 start time.

ENDZT - 54000,then 54000/3600 = 15:00:00 end time.

Check this logic a.capacity = {(BEGZT - ENDZT) - PAUSE}NGRADAGNOR /100

Regards

Mangalraj.S

[Uttam4]

When trying to load  '240000' as ENDZT  in staging table using BODS , it is throwing error message 
"SAP DBTech JDBC: [677]: check constraint violation: CHK_/1LT/DSDS1001910_ENDZT_TIME_IS_VALID: "ENDZT" = TO_TIME("ENDZT", 'HH24MISS') "
Could please help how to load '240000'