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: 

Retrieve data from LIPS

Former Member

‎2005 Dec 12 12:06 PM

0 Kudos
228

I need to retrieve data from LIPS starting from MCH1...

select *

into itab

from mch1 as m

inner join lips as p on

****

But i need the join the be done only on the last record of LIPS do you this it is possible that way or not ?

I don't think so but just to be sure...

2 REPLIES 2

former_member188685
Active Contributor

‎2005 Dec 12 12:13 PM

0 Kudos
95

can you clearly specify what do you want...

manuel_bassani
Contributor

‎2005 Dec 12 12:57 PM

0 Kudos
95

Hi Stephan,

i presume you want to do the join


select *
into corresponding fields of table itab
from mch1 as m inner join lips as p on p~matnr = m~matnr
                                   and p~charg = m~charg
where p~posnr = ( select max( posnr ) from lips
                   where vbeln = p~vbeln ).

This select statement should read every lips record linked to mch1 (given matnr/charg) and considers only those lips record with the greatest posnr

But i'm not sure if for each mch1 record (matnr/charg) it exists only 1 occurrence of likp...

I hope it will help.

Please consider to reward points for useful answers.

Regards, Manuel