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.