topic Re: Link between EQUI and VBAK table in Application Development and Automation Discussions

Link between EQUI and VBAK table

Former Member — Thu, 14 Oct 2010 10:55:16 GMT

Hi,

I need to fetch data from both EQUI and VBAK tables and display the data together. But I am not finding a convenient link. I tried using aufnr from AFIH to link VBAK and EQUI, but it didnt workout for me. Please let me know the possible combinations to link VBAK and EQUI.

Thanks & Regards,

Varsha

Re: Link between EQUI and VBAK table

Former Member — Thu, 14 Oct 2010 11:15:18 GMT

Hi Varsha,

maybe the DB view

ROG_VBAPAK

may solve your problem!

Regards,

Klaus

Re: Link between EQUI and VBAK table

kesavadas_thekkillath — Thu, 14 Oct 2010 12:24:46 GMT

It goes this way

VBAK<->QMIH<->EQUI

Re: Link between EQUI and VBAK table

former_member6142 — Tue, 12 Jul 2022 07:32:11 GMT

Hi,

you can get the mapping from equipment data (which is maintained in transaction iq03) to the sales order data with table EQBS.

VBAK / VBAP-VBELN

-> EQBS-KDAUF

EQBS-EQUNR

-> V_EQUI-EQUNR