Skip to Content
0
Former Member
Dec 14, 2007 at 12:21 PM

Select statement using alias names

31 Views

I have to fetch the maximum of lifnr and pass it to ITAB using TABLE alias names

Is this statement correct

Select * from Z123 A into table itab where lifnr = ( select max( lifnr ) from Z123 'B' where A.kunnr = B.kunnr) .