topic Re: Problem with JOIN in Application Development and Automation Discussions

Problem with JOIN

Former Member — Wed, 05 Dec 2007 13:13:28 GMT

Hi. I have such problem

DATA: a_edidd LIKE edidd OCCURS 0 WITH HEADER LINE.

SELECT * FROM edid4 
JOIN edidc ON edidc~docnum = edid4~docnum     <= ERROR
INTO CORRESPONDING FIELDS OF TABLE a_edidd 
WHERE edid4~credat EQ '20071123'.

ERROR:

You cannot use comparisons with column references in pool and clustertables: "EDID4~DOCNUM".

What can I do with it?

Re: Problem with JOIN

Former Member — Wed, 05 Dec 2007 13:14:50 GMT

Can't use "JOIN" statement with pool & cluster table !

EDID4 is a cluster table ( join isn't allowed on this table ) You can see that in SE11.

Use "for all entries" statement instead .

Hope this helps,

Erwan

Re: Problem with JOIN

Former Member — Wed, 05 Dec 2007 13:15:18 GMT

Hi,

You can not join on Cluster tables.

Regards,

Satish

Re: Problem with JOIN

JozsefSzikszai — Wed, 05 Dec 2007 13:15:33 GMT

hi Piotr,

change:

DATA: a_edidd LIKE edidd OCCURS 0 WITH HEADER LINE.
 
SELECT * FROM edid4 <b>AS edid4</b>
JOIN edidc <b>AS edidc</b>
ON edidc~docnum = edid4~docnum     <= ERROR
INTO CORRESPONDING FIELDS OF TABLE a_edidd 
WHERE edid4~credat EQ '20071123'.

UPDATE: edid4 is cluster table so it won't work (but AS is a necessary statemet for joining tables)

Re: Problem with JOIN

Former Member — Wed, 05 Dec 2007 13:16:42 GMT

edid4 is a claster table. U can't join with that table. But U may select twice - one from eddic, second - from edid4 for all entryes in eddic.

Or find transparent table of that cluster. Sorry for may language...

Re: Problem with JOIN

Former Member — Wed, 05 Dec 2007 13:31:22 GMT

Hi,

You cannot join transparent table and cluster table..

Instead you can use FOR ALL ENTRIES to get the cluster table data..

Check this example..BKPF is a transparent table and BSEG is a cluster table.

SELECT BELNR GJAHR BUKRS

INTO TABLE T_BKPF

WHERE ERDAT = SY-DATUM.

IF NOT T_BKPF[] IS INITIAL.

SELECT BELNR GJAHR BUKRS BUZEI

FROM BSEG

INTO TABLE T_BSEG

FOR ALL ENTRIES IN T_BKPF

WHERE BELNR = T_BKPF-BELN

AND BUKRS = T_BKPF-BUKRS

AND GJAHR = T_BKPF-GJAHR.

ENDIF.

Regards