Inner join command is not supporting pooled table

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

endloop

just a rough idea

.

Regards,

Atish

[Former Member]

used for all entries.

else.

loop at itab into wa.

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

endloop.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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