Skip to Content
0
Former Member
Jan 14, 2008 at 05:35 PM

select statement!!

21 Views

Hi,

can anyone please tell me how this select statement works?

SELECT LIPSLFIMG LIPSMATNR LIPSVBELN LIPSVRKME LIKP~KUNNR

LIKPLFART LIKPVBELN LIKPVSBED LIKPVSTEL LIKP~WADAT_IST

KNA1~NAME4

INTO (LIPS-LFIMG , LIPS-MATNR , LIPS-VBELN , LIPS-VRKME , LIKP-KUNNR

, LIKP-LFART , LIKP-VBELN , LIKP-VSBED , LIKP-VSTEL

, LIKP-WADAT_IST, KNA1-NAME4 )

FROM ( LIPS

INNER JOIN LIKP

ON LIKPVBELN = LIPSVBELN

INNER JOIN KNA1

ON KNA1KUNNR = LIKPKUNNR )

What I dont understand is we are selecting some fields and then putting them back in the same fields of the same table? why would we do that?

Thanks in advance.

goldie