cancel
Showing results for 
Search instead for 
Did you mean: 

(SQVI request) work order and workcenter

Former Member
0 Kudos

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

TammyPowlas
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

piyush_potey
Participant
0 Kudos

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

NTeunckens
Active Contributor
0 Kudos

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