topic Re: Issue in Left outer join in Application Development and Automation Discussions

Issue in Left outer join

Former Member — Tue, 31 Dec 2013 04:14:47 GMT

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.

Re: Issue in Left outer join

arivazhagan_sivasamy — Tue, 31 Dec 2013 04:29:13 GMT

Hi Smitha,

Please check where condition..

Also you missed for all entries option..

It's seems to be wrong.

Arivazhagan S

Re: Issue in Left outer join

Former Member — Tue, 31 Dec 2013 04:30:02 GMT

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

Re: Issue in Left outer join

Former Member — Tue, 31 Dec 2013 04:36:55 GMT

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

Re: Issue in Left outer join

former_member188251 — Tue, 31 Dec 2013 06:35:33 GMT

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

Best Regards,

Shankar.

Re: Issue in Left outer join

RaymondGiuseppi — Tue, 31 Dec 2013 07:19:17 GMT

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