Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Cluster table

Former Member
0 Kudos
175

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
147

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.

5 REPLIES 5

Former Member
0 Kudos
148

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.

peter_ruiz2
Active Contributor
0 Kudos
147

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

0 Kudos
147

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.

0 Kudos
147

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

Former Member
0 Kudos
147

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