topic Re: Inner join command is not supporting pooled table in Application Development and Automation Discussions

Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:08:19 GMT

Hi Forum,

I'm new to abap. I tried passing fields of two tables into a single table using inner join command. But one of the tables is a pooled table so the command "inner join" is not supporting that. How to pass the fields in those two tables into a single table? Kindly help me out.

Rgrds,

Mahathi

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:10:41 GMT

Hi,

You can use FOR ALL ENTRIES in such case.

You will get data in two tables. Then LOOP at one internal table and read the another internal table and move the data to third internal table.

Regards,

Atish

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:12:25 GMT

used for all entries.

else.

loop at itab into wa.

read table itab into wa with key field wa-field.

endloop.

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:39:10 GMT

Hi ....

U can't perform JOIN with Pooled or Cluster tables

trying to join A018 and KONP .... here A018 is Pooled table... Look at below threads...

Hope it will solve your problem..

<b>Reward points if useful.</b>

Thanks & Regards

ilesh 24x7

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:54:04 GMT

Could you please give an example..Suppose two table BSEG & BKPF. out of two BSEG is a spooled one. Now pls tell me who to write code for this.

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:55:00 GMT

Could you please give an example..Suppose two table BSEG & BKPF. out of two BSEG is a spooled one. Now pls tell me how to write code for this.

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 04:55:27 GMT

Could you please give an example..Suppose two table BSEG & BKPF. out of two BSEG is a spooled one. Now pls tell me how to write code for this.

Re: Inner join command is not supporting pooled table

Former Member — Wed, 14 Nov 2007 05:00:27 GMT

Hi,

You will have three internal tables

data it_bkpf type table of bkpf.

data it_bseg type table of bseg.

data it_final <define the fields from both the table which you want.

select * from bkpf into it_bkpf.....

if it_bppf is not initial.

select * from bseg into it_bseg for all entries in it_bkpf where....

endif.

loop at it_bkpf.

loop at it_bseg where..

move data here in final table

endloop

just a rough idea

Regards,

Atish