SQVI EKKO/SWWWIHEAD - How to make it work?

[phfranca]

Hello everyone!

I am trying to create a query using T-CODE SQVI that includes the tables EKKO, SWW_WI2OBJ, and SWWWIHEAD. However, I need one or more tables that I can use to establish relationships between EKKO and SWW_WI2OBJ and SWWWIHEAD. Has anyone encountered this situation before? Could someone guide me on how to create the relationship between these, or possibly other, tables? Ultimately, I would like to query the order and receive data from the SWW_WI2OBJ and SWWWIHEAD tables. The query should include EKKO, SWW_WI2OBJ, and SWWWIHEAD.

Thanks a lot!

[junwu]

are you working on R3 4.7? it is 2025 now....

[phfranca]

Hello @junwu,

No, I'm just facing a problem and want to compare the fields SWWWIHEAD-WI_STAT and EKKO-PROCSTAT.

[junwu]

then go with cds. forget about sqvi.

[phfranca]

Hello @junwu! I think CDS is the best option. But I can't use it at the moment. Would you know how to find the path through SQVI?