topic Re: join cluster table in Application Development and Automation Discussions

join cluster table

Former Member — Mon, 25 Sep 2006 15:40:23 GMT

I would like to make a joint with a table cluster (bseg) but the system put an error compilation. what a solution? Thank you for answer.

Even the creation of a view does not make with the tables cluster.

Re: join cluster table

Former Member — Mon, 25 Sep 2006 15:41:31 GMT

Hi,

You cannot write join for cluster tables like BSEG..Instead you can use FOR ALL ENTRIES options..

EX..

DATA: T_BKPF TYPE STANDARD TABLE OF BKPF,

T_BSEG TYPE STANDARD TABLE OF BSEG.

SELECT * FROM BKPF

INTO TABLE T_BKPF

WHERE....

IF NOT T_BKPF IS INITIAL.

SELECT * FROM BSEG

INTO TABLE T_BSEG

FOR ALL ENTRIES IN T_BKPF

WHERE BUKRS = T_BKPF-BUKRS

AND BELNR = T_BKPF-BELNR

AND GJAHR = T_BKPF-GJAHR..

ENDIF.

Thanks,

Naren

Re: join cluster table

Former Member — Mon, 25 Sep 2006 15:41:43 GMT

You cannot join a cluster table.

Re: join cluster table

Former Member — Mon, 25 Sep 2006 15:49:29 GMT

hi,

Joins donot work on cluster tables use FOR ALL ENTRIES instead of joins..

Regards,

Santosh

Re: join cluster table

Former Member — Mon, 25 Sep 2006 15:50:08 GMT

Do as Written below :

DATA: IT_BKPF TYPE STANDARD TABLE OF BKPF,

IT_BSEG TYPE STANDARD TABLE OF BSEG.

SELECT * FROM BKPF

INTO TABLE IT_BKPF

WHERE ...conditions

IF NOT IT_BKPF[] IS INITIAL.

SELECT * FROM BSEG

INTO TABLE IT_BSEG

FOR ALL ENTRIES IN IT_BKPF

WHERE BUKRS = IT_BKPF-BUKRS AND

BELNR = IT_BKPF-BELNR AND

GJAHR = IT_BKPF-GJAHR.

ENDIF.

Re: join cluster table

Former Member — Mon, 25 Sep 2006 15:56:03 GMT

Hi,

You can not use joint for cluster table BSEG.

Have you looked to use logical database (SE36)?

Regards,

Ferry Lianto

Re: join cluster table

Former Member — Mon, 25 Sep 2006 16:03:47 GMT

Hi,

inner join cant be used on cluster tables

and views whic is alos simulation of inner join.

use all entries logic to get values from bseg

select * rrom bsef in into table i_bseg

for all entries in i_bkpf

where ...

Regards

amole

Re: join cluster table

Former Member — Tue, 26 Sep 2006 13:12:44 GMT

yes its good. Thanks for all your answers.