Clustertables

[Former Member]

Hi,

I have tried that Cluster tables BSEG and BSET cannot be joined using ABAP Quick Viewer.

i.e is SQ01, SQ02, SQ03------Tcodes.

Can anybody let me know, is it possible in any other way or through Quick viewr only is it possible.

Thanks

Manju.

[Former Member]

Hi Manju,

It is not possible to join cluster table like BSEG.

But you can perform a selection from BSEG into internal table IT_BSEG and then do the second selection on BSET using 'FOR ALL ENTRIES in IT_BSEG'.

Regards,

Ferry Lianto

[amit_khare]

Hi,

As a suggestion, try to avoid using select on cluster tables if you are not providing all the key fields in where clause, it will give major performance issue.

There are alternatives for that which your Functional person can suggest you.

Regards,

Amit

Reward all helpful replies.

[Former Member]

Hello,

To read BSEG efficiently,check this link:

Once you get this data,you can use "select for all entries of itab_BSEG".

regards,

Beejal

**reward if it helps

[Former Member]

Hi another way around is...

1. See all tables that are getting collected in a cluster BSEG... and Pick the table which contains data u want... Then do similar thing with BSET and then use Join condition to link two tables / or more table to get desired output

Darshan