how to decide system status cnf teco clsd

[Former Member]

Hi ,

My requirement is to select work orders( auart), planned hrs( arbei), actual hrs( ismnw ) based on 'date range', 'work order type', func location ( tplnr ), 'abc indicator ( abckz).

i have to list all work orders:

for a particular planning plant say '1000' , systm status including CNF, TECO, CLSD, excluding PCNF , CRTD , DLFL and REL, I have to include all work orders except SM02 and CP01 and also exclude work orders scheduled outside query period .

When the above is done, i need to sum planned work work hours scheduled for that week , divided by sum of planned work hrs.

I am done with select statement part, how can i find system status or how to calculate system status .

thanks.

Raghu

[Former Member]

use JEST table or STATUS_READ Function module by passing values

[Former Member]

u mean for particular 'auart', do i need to pull system status from JEST or do i need to calculate based on planned hrs and actual hrs.

if itab-arbei > itab-ismnw

status = cnf or teco or clsd

else

status = pcnf or crtd or dlfl or rel.

thx.

Raghu

[Former Member]

I done similar requirement like production order status report ,when ever you want to get status we use status_read function module.

But ur req is diffrent ,can you please explian little bit more

[Former Member]

Hi Seshu,

I have to extract auart, arbei, ismnw based on date range, work order range, func.location range ( tplnr) , abc indicator( abckz).

list all work orders ( auart) with planning plant '1000', system status including CNF, TECO, CLSD , excluding PCNF CRTD DLFL and REL, including all work order types except ' CP01' .

Then i have to sum planned work hrs scheduled for that period and divide by sum of planned work hrs .

say if sum of earned hrs is 10 and planned work hrs scheduled are 20 then

10/20.

Here i have to find earned hrs from AUFK table.

Basically i would like to know about system status , whether it depends on planned hrs and earned hrs or just i have to extract it from JEST or use status_read.

Thanks.

Raghu

[Former Member]

you could use status_read function module .

call this function module and see the results ( please pass required parameters )