join cluster table

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

You cannot join a cluster table.

[Former Member]

hi,

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

Regards,

Santosh

[Former Member]

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.

[Former Member]

yes its good. Thanks for all your answers.

[Former Member]

Hi,

You can not use joint for cluster table BSEG.

Have you looked to use logical database (SE36)?

Regards,

Ferry Lianto

[Former Member]

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