Skip to Content
0
Former Member
Mar 06, 2009 at 04:46 AM

Getting error in select query

51 Views

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.