09-19-2008 3:43 PM
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????
09-19-2008 6:34 PM
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
09-19-2008 6:34 PM
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
09-22-2008 3:15 PM
09-22-2008 3:19 PM
Sunil! Your solution for Orders is correct.
Could you please help me to know the Personnel number for notifications as well.
09-22-2008 5:15 PM