Cluster table

[Former Member]

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.

[Former Member]

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]

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

[Former Member]

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.

[peter_ruiz2]

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]

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