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