Skip to Content
Former Member
Sep 03, 2009 at 12:17 PM

table for user status PLNA in work order


Dear All

I have one issue here , we are planning work order intially by planner if he creates PR for service through work order

this work order is intially set for user status PLND (All work is planned in work order & status USER status is PLANNED I.e.PLND )

So this Work order is apporved by supervisor Which he sets the user status as PLNA (all owk in the order is appoved by supevsior)

Now when planner releases the work order PR is generated after PLNA (Released work order is permitted only after PLNA user stasus is set)

Now my query is I want to track the user ID of the person who sets PLNA in work order

From whcih table I can get this user ID who is setting the status PLNA

The user ID of the creator of work order who is setting the user status PLNA can be seen by table AFIH

but how can I find the user status PLNA person user ID

Reason for this is we are sending this PR through work flow to the correct the person who has appoved the Work order

Can anybody tell me the way I can find the user ID who has apporved the work order