Tableview AUFK AFVU

[Former Member]

Hello everybody,

i have to make a report, to push some maintenance workorders.
I have to select from aufk with conditions aufnr auart astnr.

but i also have to select if the order is assigned to a team or a person.

i found these fields in afvu (zz_persno and team_guid).

but i dont know how to join these two tables.

Does anybody have an idea?

Thank You.

Björn

[Kiran_Valluru]

Hi,

Check this: Link using AFKO table, AUFK -> AFKO -> AFVU

AUFK-AUFNR = AFKO-AUFNR then AFKO-AUFPL = AFVU-AUFPL

Regards,

Kiran

[former_member183073]

Please Validate the requirement once again, AFVU might not be the correct table as per your requirement as it holds details of the Users at Operation Level, and even it is Operation which is assigned to a person or group not Order. Please check with the Functional Owner what exactly is required or where the Assigned user data is stored.

In AFVU you will have multiple records for each Order(i.e. at the Operation Level)