topic Re: Join a cluster table + transparent table in Application Development and Automation Discussions

Join a cluster table + transparent table

Former Member — Wed, 27 Aug 2008 07:04:28 GMT

Hi,

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

Best regards.

Re: Join a cluster table + transparent table

former_member386202 — Wed, 27 Aug 2008 07:06:00 GMT

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.

Regards,

Prashant

Re: Join a cluster table + transparent table

Former Member — Wed, 27 Aug 2008 07:07:54 GMT

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.