join select from cluster tables

[Former Member]

It seems join select does not function from cluster tables. How to avoid that.(maybe you have an example).

I get message:"You cannot use comparisons with column column references in pool and

cluster tables: "KONV~KNUMV". column references in pool and cluster

tables: "KONV~KNUMV". column references in pool and cluster tables:

"KONV~KNUMV". references in pool a..."

when I use SELECT konv_{knumv konv}kposn konv_{stunr konv}kschl konv~kwert

INTO CORRESPONDING FIELDS OF TABLE S000 from konv

JOIN vbrk ON

vbrk_{knumv = konv}knumv

JOIN VBRP ON

VBRP_{POSNR = KONV}kposn and

vbrp_{vbeln = vbrK}vbeln

WHERE vbrk_{fkdat le datumhigh and vbrk}fkdat ge

datumlow.

modify zresult from table s000.

[Former Member]

<b>Hi

U cant use JOIN in POOLED or cluster tables.

Use FOR ALL ENTRIES IN ITAB for that.

SELECT konv-knumv konv-kposn konv-stunr konv-kschl konv-kwert

INTO CORRESPONDING FIELDS OF TABLE S000 from konv.

select * from vbrk into corresponding fields of table itab for all entries in S000 where knumv = s000-knumv

Like this.

Regs

Manas Ranjan Panda</b>

Message was edited by:

MANAS PANDA

Message was edited by:

MANAS PANDA

[Former Member]

You cannot use joins on cluster tables.

You will have to select the data individually either by using FOR ALL ENTRIES or SELECT with in the loop.

1. SELECT data from 1 table, SELECT data form 2 table using FOR ALL ENTRIES

2. SELECT data from 1 tab

loop at the internal and get data from the 2nd one.

Regards

Ravi

Note please mark all the helpful answers

[Former Member]

Don't think Join will work for Cluster tables.

Go for For all entries statement.

[anversha_s]

hi,

join will not work for pooled and cluster table.

use <b>FOR ALL ENTRIES</b> insted of JOIN

Rgds

Anver