Skip to Content

Issue in Left outer join

Hi All ,

I have used below select query to get data from ADR2, ADR3 and ADR6 tables using Left outer join ....

but im not getting any data into itab . Can anyone tell me what is wrong in select query ?

select a~ADDRNUMBER

a~COUNTRY

a~TEL_NUMBER

a~TEL_EXTENS

a~TELNR_LONG

a~TELNR_CALL

c~ADDRNUMBER1

c~SMTP_ADDR

into corresponding fields of table itab

from ADr2 as A

LEFT Outer Join ADR6 AS C ON a~addrnumber = c~addrnumber\

where a~addrnumber = t_but020-addrnumber.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 31, 2013 at 04:29 AM

    Hi Smitha,

    Please check where condition..

    Also you missed for all entries option..

    It's seems to be wrong.

    Arivazhagan S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 04:30 AM

    hi,

    try like this..

    select a~ADDRNUMBER

    a~COUNTRY

    a~TEL_NUMBER

    a~TEL_EXTENS

    a~TELNR_LONG

    a~TELNR_CALL

    c~ADDRNUMBER1

    c~SMTP_ADDR from adr2 as a left outer join adr6 as c on a~addrnumber = c~addrnumber i

    into corresponding fields of table itab where a~addrnumber = t_but020-addrnumber.

    Regards

    gopi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi smitha,

      in where condition give parameter name which used in the program in the place of t_but020-addrnumber. First check values is coming to internal table. after that u can check with where condition.

      Regards,

      gopi

  • Posted on Dec 31, 2013 at 06:35 AM

    PLease check if data does exist in the table for the join condition and the where clause.

    Best Regards,

    Shankar.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2013 at 07:19 AM

    Before posting, did you check (via debug) the actual values stored in internal table t_but020 (conversion exit or garbage data ?), also did you check existence of data in table ADR2 for some of the extracted values ?

    Regards,

    Raymond

    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.