Skip to Content
Former Member
Jun 12, 2007 at 04:07 AM

System status in plant maintenance


Hi :

I still have doubt in using FM status_read and tables jest and tj02t.

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 .