I am learning ABAP and trying to select fields from 2 tables(AFKO & RESB), following is my script:
SELECT A-AUFNR B-MATNR B-WERKS B-LGORT B-BDMNG
FROM AFKO AS A
LEFT JOIN RESB AS B ON A-RSNUM = B-RSNUM
However, when I click on 'Check' button, system showed an error message: Field "A-RSNUM" unknown, is there any experts could tell me where I need to modify?
Thanks in advance