topic Re: join select from cluster tables in Application Development and Automation Discussions

join select from cluster tables

Former Member — Thu, 23 Nov 2006 09:14:32 GMT

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.

Re: join select from cluster tables

Former Member — Thu, 23 Nov 2006 09:16:48 GMT

<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

Re: join select from cluster tables

Former Member — Thu, 23 Nov 2006 09:17:27 GMT

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

Re: join select from cluster tables

Former Member — Thu, 23 Nov 2006 09:17:55 GMT

Don't think Join will work for Cluster tables.

Go for For all entries statement.

Re: join select from cluster tables

anversha_s — Thu, 23 Nov 2006 09:19:41 GMT

hi,

join will not work for pooled and cluster table.

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

Rgds

Anver