Orders/Notifications assigned to a personnel Number
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 .
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