topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Sat, 07 Jun 2008 12:20:33 GMT

What to do to make possible to write 'inner join' statement using

pooled and normal table?

Re: inner join

Former Member — Sat, 07 Jun 2008 12:25:38 GMT

report test .

tables: pa0002,pa0008,pa0021.

data: begin of it_final occurs 0,

pernr like pa0002-pernr,

begda like pa0002-begda,

endda like pa0002-endda,

vorna like pa0002-vorna,

nachn like pa0002-nachn,

ansal like pa0008-ansal,

lga01 like pa0008-lga01,

bet01 like pa0008-bet01,

famsa like pa0021-famsa,

fanam like pa0021-fanam,

favor like pa0021-favor,

end of it_final .

select-options:s_pernr for pa0002-pernr.

select a~pernr

a~begda

a~endda

a~vorna

a~nachn

b~ansal

b~lga01

b~bet01

c~famsa

c~fanam

c~favor

from ( ( pa0002 as a inner join pa0008 as b on a_{pernr = b}pernr )

inner join pa0021 as c on a_{pernr = c}pernr and b_{pernr = c}pernr )

into table it_final

where a~pernr in s_pernr.

sort it_final by pernr begda descending.

loop at it_final.

write:/ it_final-pernr,

it_final-begda,

it_final-endda,

it_final-vorna,

it_final-nachn,

it_final-ansal,

it_final-lga01,

it_final-bet01,

it_final-famsa,

it_final-fanam,

it_final-favor.

endloop.

Re: inner join

Former Member — Sat, 07 Jun 2008 12:32:07 GMT

all tables participating in your 'inner join' statement are normal tables.

i am asking another

Re: inner join

Former Member — Sat, 07 Jun 2008 12:35:16 GMT

we can join transparent tables only .

we can't join pooled and cluster tables

Re: inner join

Former Member — Sat, 07 Jun 2008 12:39:48 GMT

i know. but may be there is some table or some program or some transaction

or utility which allows to configure something about pooled tables and

then to use them within 'inner join' statement.

Re: inner join

Former Member — Sat, 07 Jun 2008 12:41:36 GMT

try to make database view and relate pool and normal table there. because database view always use inner view.....

Re: inner join

Former Member — Sat, 07 Jun 2008 12:48:30 GMT

i tried to make as you said.

same error message appears as in abap editor.

Re: inner join

Sm1tje — Sat, 07 Jun 2008 13:06:54 GMT

Well there is something you can do, but not sure if one should really do this:

[Converting Pooled Tables to Transparent Tables|http://help.sap.com/saphelp_nw70/helpdata/EN/cf/21eb13446011d189700000e8322d00/content.htm]

Re: inner join

Former Member — Sat, 07 Jun 2008 13:14:26 GMT

it's useful link.

but i must not change pooled table.

Re: inner join

Sm1tje — Sat, 07 Jun 2008 13:16:44 GMT

I know, but you want to use it in an INNER JOIN, which is not possible for pooled/cluster tables, however a transparant table can. So by converting it, you can use it in your INNER JOIN.