topic Re: Select fields from 2 tables in Application Development and Automation Discussions

Select fields from 2 tables

former_member588495 — Wed, 27 Jan 2021 09:20:55 GMT

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

Re: Select fields from 2 tables

FredericGirod — Wed, 27 Jan 2021 09:24:34 GMT

SELECT A~AUFNR B~MATNR B~WERKS B~LGORT B~BDMNGFROM AFKO AS ALEFT JOIN RESB AS B ON A~RSNUM = B~RSNUM

Tilde not minus

Re: Select fields from 2 tables

former_member588495 — Thu, 28 Jan 2021 00:26:26 GMT

Dear Frederic,

I got it, thank you.

Best Regards

Roger