Skip to Content
avatar image
Former Member

Schedule called orders and Manually Called Order tables

Dear Team.

My requirement is to segregate maintenance orders for a particular plan based on system called and manual called orders thorough tables and need to print the same in permit print. I have checked all the tables but not found the required one. Can any one guide me that in which table i can check the difference of two?

Regards,

Bhanu.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 22, 2014 at 03:44 AM

    Hello

    You can use MHIS table in schedule type field (Field name TERMA)  there are four Values M, T, N and Z.


    M-->called manually


    T--scheduled by the scheduling function


    N-->restarted


    Z-->rescheduled in the current cycle


    So you can fetch requested data by passing above in put values M, T, N and Z.


    Br

    Rakesh


    Capture.JPG (48.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2014 at 12:52 PM

    Hello Bhanu,

    Table MHIS

    Manual calls are bearing the Call numbers >= 90,000,000, whereas Scheduled calls are having Call numbers 1,2,3 and so on. So query the MHIS table like in picture1 below for Manual calls and like in picture2 for scheduled calls. (ABNUM is for call number).

    Picture1 (Gives you Manual Calls)

    Picture2 (Gives you Scheduled Calls)

    Also see the my reply in this similar discussion


    KJogeswaraRao


    manual.PNG (8.7 kB)
    scheduled.PNG (8.9 kB)
    Add comment
    10|10000 characters needed characters exceeded