cancel
Showing results for 
Search instead for 
Did you mean: 

table for user status PLNA in work order

Former Member
0 Kudos

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

Regards

chandrashekhar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

JCDS

Answers (1)

Answers (1)

Former Member
0 Kudos

Have you had a look at the change documents and action log in the order.

Also check that *change documents* are active for status changes in the IMG

Pass you order object number to JEST table to get the exact user status

Babu

Former Member
0 Kudos

hi

I know the table where can see the user status PLNA

I can see in the action log & change documents

but from which table I can come to know who has set the user Status PLNA i.e I want two things the user ID of the person who has set the user status PLNA & table where if I put order number I can get user ID of the person who has set the user status PLNA

Regards

chandrashekhar

Former Member
0 Kudos

Have you checked JEST and JSCD tables?

Babu

Former Member
0 Kudos

Done