Skip to Content
0

(SQVI request) work order and workcenter

Mar 01 at 12:54 PM

46

avatar image
Former Member

Hello,

I have done the following table jointure :

AFKO-AUFK

AFVC-AFKO

AUFK-AFPO

AUFK-AFRU

CRHD-AFVC

My goal is to enter a list of work order and that the request show all the operation and the workcenters of the work orders.

I have shown that I had to put the CRHD-OBJTY value to 'A' but when i execute the request, the result work only for confirmed work order on not the other.

Could you please help me?

Thank you very much

10 |10000 characters needed characters left characters exceeded

Please share some screen shots of how you have done the joins.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nic Teunckens Mar 01 at 01:55 PM
0

You might want to use the DB-View "VIAUFK_AFVC" for this (in SAPQuery or Trx."SE16" or ...) : It joins tables "AFIH AUFK AFKO AFVC AFVV ILOA AFVU" and you would be able to distill ALL possible Order and / or Operation-Related WorkCenters for your Orders ...

See "VIAUFK_AFVC-GEWRK" / "VIAUFK_AFVC-VAPLZ" as WorkCenters ...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 03 at 04:38 PM
0

Use Logical database AFI to create query for Order and operation Data

Share
10 |10000 characters needed characters left characters exceeded