Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Orders/Notifications assigned to a personnel Number

Former Member
0 Kudos

I need to get all the orders and notifications assigned to a personnel in plant maintenance. Can anybody suggest me the tables where I can query and get the orders and notification assigned on personnel Number. This Personnel Number get populated against the order in TRANSACTION -IW37 .

Any Idea????

1 ACCEPTED SOLUTION

Former Member
0 Kudos

That transaction is using AFVC and the view VIAFKOS. u have personnel number in AFVC and the Order in VIAFKOS.

Join conditions are AFVC-AUFPL = VIAFKOS-AUFPL & AFVC-APLZL = VIAFKOS-APLZLT

4 REPLIES 4

Former Member
0 Kudos

That transaction is using AFVC and the view VIAFKOS. u have personnel number in AFVC and the Order in VIAFKOS.

Join conditions are AFVC-AUFPL = VIAFKOS-AUFPL & AFVC-APLZL = VIAFKOS-APLZLT

0 Kudos

Thanks Sunil, my problem is resolved.

0 Kudos

Sunil! Your solution for Orders is correct.

Could you please help me to know the Personnel number for notifications as well.

0 Kudos

In VIAFKOS ,we have notification (QMNUM) as well.