Skip to Content
avatar image
Former Member

(SQVI request) work order and workcenter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 01 at 01:55 PM

    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 ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03 at 04:38 PM

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

    Add comment
    10|10000 characters needed characters exceeded