how to fetch data from cluster tables

[Former Member]

hi

i need to know how to fetch data from cluster tables please update me if any

i know that we cannot use joins in cluster table we use view etc

but i need detailed inforation on methods for fetching data from cluster tables

regards

Nishant

[Former Member]

You cannot use joins involving cluster table , so use for all entries. If your going to fetch only from that table , select statement is the same similary to that of transperent tables . No change at all

[former_member585060]

Hi,

Check the following links

http://fuller.mit.edu/hr/cluster_tables.html

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8...

[former_member181995]

Nishant,

BSEG is clster table.is there any chance in your SAP career to fetch data from BSEG?

Exactly we use Select query for cluster table.

Ps:Use As much as possible key for cluster tables for saving you from performance issue

Amit.

[Former Member]

hi Amit

i know Bseg is cluster table and as stated above i also know that we cannot use joins with cluster table hence we need to use for all entries only

but i want to know some other methods or document on fetching data from clustear tables mean waht are the all the ways which we can use for fetching data from cluster tables.

and some otehr tips if any realted to this topic

regards

Nishant

[former_member181995]

You can use For all entries but as i mention above use as much as key in FAE for cluster table.

[Former Member]

is there any other ways to fetch data from cluter tables i suppose in HR abap its done frequently and they use some function modules not sure but some other methods are there to fetch data from cluster tables besides th normal abap one using select

[Former Member]

closed