Join a cluster table + transparent table

[Former Member]

Hi,

can you give me an example to join between a cluster table + transparent table.

Best regards.

[former_member386202]

Hi,

Join doesnt work on cluster table use FOR ALL ENTRIES for that

refer below code

SELECT bukrs

zuonr

gjahr

belnr

budat

bldat

blart

shkzg

dmbtr

xref3

FROM bsis

INTO CORRESPONDING FIELDS OF TABLE it_bsis

WHERE bukrs EQ p_bukrs

AND hkont EQ p_hkont

AND blart IN s_blart

AND budat IN s_budat.

IF NOT it_bsis[] IS INITIAL.

SELECT belnr

gjahr

awkey

FROM bkpf

INTO TABLE it_bkpf

FOR ALL ENTRIES IN it_bsis

WHERE bukrs EQ it_bsis-bukrs

AND belnr EQ it_bsis-belnr

AND gjahr EQ it_bsis-gjahr.

IF sy-subrc EQ 0.

SORT it_bkpf BY belnr gjahr.

ENDIF.

ENDIF.

Regards,

Prashant

[Former Member]

Cluster tables cannot be used in an ABAP join. For this reason, you have to select the key from the transparent table first and then select the cluster table with 'for all entries' syntax.

You may also check if a logical database is available by se36.