Tables in Cluster table

[Former Member]

Hi,

Please can any one tell me that how can we find transperent tables in the Cluster table.

Eg: KONV is cluster of which all tables.

Thanks

Sameer

[Former Member]

Do a where used list for the cluster.

Rob

[Former Member]

hi,

go to se11

put the table name: knov

click on display

then click on tab get entry/help check

there you find all the tables

like

T000, T681A, TCURC, T006, T687, SKA1, LFA1, KNA1

Sulabh

[venkat_o]

Hi Sameer,

<li>You are asking wrong question I believe. We cluster different tables into Cluster pool. Those individual tables are known as cluster tables.(Cluster table does not mean that clustering transparent tables).

<li>So in your case KONV is cluster table. Cluster pool for your cluster table is KOCLU. You can see that in Delivery and Maintenance tab.

I believe that you will understand.

Regards,

Venkat.O

[Former Member]

@ Venkat, how can we check which all tables are in cluster pool.

[venkat_o]

Hi Vikash,

Follow the steps.

<li>SE11->KONV->Display

<li>Click on Delivery and Maintenance tab

<li>Double click on Table Cluster KOCLU.

<li> Place cursor on KOCLU and use Where-Used List. You will find list of Cluster tables attached to Table Cluster. In your case only one entry is found.

<li>You can follow same procedure for BSEG,

<font color=red>Small correction:</font>Logically related cluster tables can be stored together in Table cluster(Not Cluster pool).

Regards,

Venkat.O

[Former Member]

Hi Sameer,

Each table assigned to table cluster is called cluster table not transparent table.

and you can see it in delivery and maintenance tab and if u want to see all cluster tables associated in

particular table cluster that you can see from 'Where-Used list'.

regards,

Anand

[Former Member]

There are 2 ways you can search the cluster/pool tables list of a specific Table Cluster/Pool :

First Method:

1) Go to SE11

2) Enter the Table Cluster/Pool name and then click on Disply.

3) Use the 'Where-Used-List'

Second Method:

1) Go to SE11

2) Enter table name 'DD02L' and click on Display.

3) Click on 'Table Contents' icon or press 'CtrlShiftF10'

4) Enter your Table Category 'CLUSTER/POOL on selection screen'

5) Enter your Table Cluster/Pool name on selection screen.