Issue in Left outer join

[Former Member]

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.

[arivazhagan_sivasamy]

Hi Smitha,

Please check where condition..

Also you missed for all entries option..

It's seems to be wrong.

Arivazhagan S

[Former Member]

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

[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

[former_member188251]

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

Best Regards,

Shankar.

[RaymondGiuseppi]

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