topic Re: Tableview AUFK AFVU in Application Development and Automation Discussions

Tableview AUFK AFVU

Former Member — Wed, 04 Jun 2014 08:14:43 GMT

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

Re: Tableview AUFK AFVU

Kiran_Valluru — Wed, 04 Jun 2014 08:41:47 GMT

Hi,

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

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

Regards,

Kiran

Re: Tableview AUFK AFVU

former_member183073 — Wed, 04 Jun 2014 09:41:28 GMT

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)