topic Re: Cluster table in Application Development and Automation Discussions

Cluster table

Former Member — Mon, 14 Apr 2008 05:58:00 GMT

Hi everybody,

Can we fetch data from a cluster table and can we use the cluster table data for our application. Generally, i heard that we should not use cluster tables in our programs. why is it so? Can i use BSEG table for my reports, if not what is the alternative for that..pls help me regarding this....

Thanks,

santosh.

Re: Cluster table

Former Member — Mon, 14 Apr 2008 06:01:09 GMT

Hi,

You can write select statement on cluster tables, but you cannot use inner joins on Cluster tables. You can write select statement on BSEG table.

Thanks,

Sriram Ponna.

Re: Cluster table

peter_ruiz2 — Mon, 14 Apr 2008 06:07:47 GMT

hi,

Can we fetch data from a cluster table and can we use the cluster table data for our application.

yes

Generally, i heard that we should not use cluster tables in our programs. why is it so?

yes, this is true because a cluster table is a combination of more than 1 transparent tables. for example, BSEG entries are entries in BSID, BSAD, BSIM, BSIS, BSAS, BSIK, and BSAK.

Can i use BSEG table for my reports, if not what is the alternative for that..pls help me regarding this....

you may use these tables as an alternative for BSEG

BSIS - Accounting: Secondary Index for G/L Accounts

BSAS - Accounting: Secondary Index for G/L Accounts (Cleared Item

BSID - Accounting: Secondary Index for Customers

BSAD - Accounting: Secondary Index for Customers (Cleared Items)

BSIK- Accounting: Secondary Index for Vendors

BSAK - Accounting: Secondary Index for Vendors (Cleared Items)

BSIM - Secondary Index, Documents for Material

Re: Cluster table

Former Member — Mon, 14 Apr 2008 06:20:02 GMT

Hi Peter,

Thanks for your answer. Bit still i am little bit unclear on usage of cluster table. Even if a cluster table contains the data of many transparent tables...what type of problem we will get exactly if we use that...i will be very thankful to u, if i get the solution.

Thanks,

Santosh.

Re: Cluster table

peter_ruiz2 — Mon, 14 Apr 2008 06:25:52 GMT

hi santosh,

the main reason on why we limit the retrieval of data from a cluster table is because of speed. since a cluster table contains the data of several transparent tables, this means that the amount of records on a cluster table is too big to be processed immediately.

Regards,

Peter

Re: Cluster table

Former Member — Mon, 14 Apr 2008 09:20:00 GMT

Hi Santhosh...

You Can fetch data from cluster table but you cannot able to do the inner join in cluster table select query. so first you can retrieve the cluster table and then you can use the for all entries concept.

Regards,

Rahul Kanth Reddy