Join between two tables with the same column name

former_member355261 — Wed, 20 Jul 2016 21:26:31 GMT

Hi,

I want to use the JOIN statement to select the fields VBAP-NETWR and VBAK-NETWR from tables VBAP and VBAK.

I can achieve this by using AS and (VBAP~NETWR and VBAK~NETWR) but the problem is in the table that is going to hold the results.

in: INTO CORRESPONDING FIELDS OF TABLE itab

itab can't have the field NETWR more than once !

So, how can I solve this ?

Thanks in advace.

Re: Join between two tables with the same column name

Sandra_Rossi — Wed, 20 Jul 2016 21:37:12 GMT

You may simply name them differently in the itab.

EDIT: for instance name them netwr1 and netwr2, and in the SELECT do: select VBAP~NETWR as netwr1, VBAK~NETWR as netwr2 ...