Hi,
I have creatd a simple program to display customer wise sales details.but I am getting a error "wrong expression INNER in FROM clause: .the following program is:
TABLES: kna1,vbak.
SELECT-OPTIONS: customer FOR kna1-kunnr.
TYPE-POOLS:ztg1.
DATA: wa TYPE ztg1_wa,
itab TYPE ztg1_itab.
SELECT kna1kunnr vbakvbeln vbakerdat vbaknetwr INTO wa FROM kna1 innner JOIN vbak ON kna1kunnr = vbakkunnr WHERE kna1~kunnr IN customer.
APPEND wa TO itab.
ENDSELECT.
LOOP AT itab INTO wa.
AT FIRST.
WRITE:/ 'CUSTOMER SALES DETAILS'.
ENDAT.
AT NEW kunnr.
WRITE:/ 'CUSTOMER NUMBER',wa-kunnr.
ENDAT.
WRITE:/ wa-vbeln,wa-erdat,wa-netwr.
AT END OF KUNNR.
SUM.
WRITE:/ 'TOTAL AMOUNT:',WA-NETWR.
ENDAT.
AT LAST.
SUM.
WRITE:/'GRAND TOTAL:',WA-NETWR.
ENDAT.
ENDLOOP.