topic Re: Clustertables in Application Development and Automation Discussions

Clustertables

Former Member — Mon, 26 Feb 2007 15:36:36 GMT

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.

Re: Clustertables

Former Member — Mon, 26 Feb 2007 15:42:36 GMT

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

Re: Clustertables

amit_khare — Mon, 26 Feb 2007 15:47:02 GMT

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.

Re: Clustertables

Former Member — Mon, 26 Feb 2007 15:52:38 GMT

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

Re: Clustertables

Former Member — Mon, 26 Feb 2007 16:24:55 GMT

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