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
Showing results for 
Search instead for 
Did you mean: 
Read only

Hi

Former Member
0 Likes
677

Hi,

How can i link b/w two tablev VBPA and LIPS

Arindam

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
660

vbpa-vbeln = lips-vgbel.

Hi,

How can i link b/w two tablev VBPA and LIPS

Arindam

5 REPLIES 5
Read only

ak_upadhyay
Contributor
0 Likes
660

Hi,

Check this....


Select-options: vbeln for vbpa-vbeln.

Select i~vbeln i~posnr
 l~vgbel l~vgpos 
into table itab from vbpa as i 
inner join lips as l on
i~vbeln = l~vgpos 
where i~vbeln in vbeln. 

Reward points if useful....

Regards

AK

Read only

Former Member
0 Likes
660

hi,

by using inner join or left outer jion

regards,

pankaj

Read only

Former Member
0 Likes
660

Hi,

You can link the VBPA & LIPS with VBELN& VGBEL.

VBPA-VBELN

LIPS-VGBEL

Reward points if found useful

Read only

Former Member
0 Likes
661

vbpa-vbeln = lips-vgbel.

Read only

Former Member
0 Likes
660

Hi,

U can link using VBPA-VBELN = LIPS-VBGEL

Regards

Sandipan