Skip to Content
0
Jan 27, 2021 at 09:20 AM

Select fields from 2 tables

40 Views

Greeting,

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

Roger