Application Development 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: 

Relation between LIPS and MSEG

Former Member

‎11-29-2007 6:24 AM

0 Kudos

Hi friends,

How to get the WERKS , LGORT field from LIPS table with respect to MSEG table...

can anyone tell the relationship between these 2 tables...

i heared that

" Select WERKS LGORT into v_supp_plant v_supp_sloc from LIPS where VGBEL = wa_mseg-ebeln "

whether this relation is correct? if not give the correct relation...

thanks in advance...

1 REPLY 1

Former Member

‎12-03-2007 5:41 AM

0 Kudos

Hi Sasikanth,

Both lips and mseg has werks and lgort but since lips is an item table u may get many records so the code wht is there might work but or else try to use delete adjacent dulicates in select stmnt and see . Hope tht it will work.

Regards,

sana.