Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Link between EQUI and VBAK table

Former Member

‎2010 Oct 14 11:55 AM

0 Likes
2,215

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2010 Oct 14 12:15 PM

0 Likes
1,529

Hi Varsha,

maybe the DB view

ROG_VBAPAK

may solve your problem!

Regards,

Klaus

Read only

kesavadas_thekkillath
Active Contributor

‎2010 Oct 14 1:24 PM

0 Likes
1,529

It goes this way

VBAK<->QMIH<->EQUI

Read only

former_member6142
Explorer

‎2022 Jul 12 8:32 AM

0 Likes
1,529

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