Skip to Content
0
Sep 17, 2007 at 06:02 PM

Comma without preceding colon (after SELECT ?).

166 Views

Hi All,

I am not very good at ABAP. I am writing a report in which i used the following SELECT statement.

-


TYPES: BEGIN OF ITAB,

xkunnr LIKE KNA1-KUNNR,

xname1 LIKE KNA1-NAME1,

xlifsd1 LIKE KNVV-LIFSD,

xfaksd1 LIKE KNVV-FAKSD,

xcrblb LIKE KNKK-CRBLB,

END OF ITAB.

DATA: IT_ITAB TYPE TABLE OF ITAB.

DATA: LS_ITAB TYPE ITAB.

SELECT KNA1KUNNR KNA1NAME1 KNVVLIFSD KNVVAUFSD KNKK~CRBLB

INTO ( IT_ITAB-xkunnr, IT_ITAB-xname1, IT_ITAB-xlifsd1, IT_ITAB-xaufsd1,

IT_ITAB-xcrblb )

FROM KNA1

INNER JOIN KNVV ON KNA1KUNNR = KNVVKUNNR

INNER JOIN KNKK ON KNA1KUNNR = KNKKKUNNR

WHERE ( KNA1KTOKD = '0001' ) OR ( KNA1KTOKD = 'C001' ) .

ENDSELECT.

SORT IT_ITAB BY XNAME1.

-


I am getting the error ' Comma without preceding colon (after SELECT ?)' at the SELECT statement. Could anyone please let me know what am i doing wrong here?

Thanks in Advance,

Karuna.