Skip to Content

Join between two tables with the same column name

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 20, 2016 at 09:37 PM

    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 ...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.