topic Re: Hi in Application Development and Automation Discussions

Hi

Former Member — Wed, 19 Mar 2008 09:00:34 GMT

Hi,

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

Arindam

Re: Hi

ak_upadhyay — Wed, 19 Mar 2008 09:38:01 GMT

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

Re: Hi

Former Member — Wed, 19 Mar 2008 09:51:00 GMT

hi,

by using inner join or left outer jion

regards,

pankaj

Re: Hi

Former Member — Wed, 19 Mar 2008 09:58:43 GMT

Hi,

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

VBPA-VBELN

LIPS-VGBEL

Reward points if found useful

Re: Hi

Former Member — Wed, 19 Mar 2008 09:58:47 GMT

vbpa-vbeln = lips-vgbel.

Re: Hi

Former Member — Wed, 19 Mar 2008 10:15:37 GMT

Hi,

U can link using VBPA-VBELN = LIPS-VBGEL

Regards

Sandipan