topic Tables in Cluster table in Application Development and Automation Discussions

Tables in Cluster table

Former Member — Tue, 09 Nov 2010 14:12:23 GMT

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

Re: Tables in Cluster table

Former Member — Tue, 09 Nov 2010 14:37:59 GMT

Do a where used list for the cluster.

Rob

Re: Tables in Cluster table

Former Member — Wed, 10 Nov 2010 04:14:47 GMT

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

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

Sulabh

Re: Tables in Cluster table

venkat_o — Wed, 10 Nov 2010 05:55:51 GMT

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

Re: Tables in Cluster table

Former Member — Wed, 10 Nov 2010 07:34:06 GMT

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

Re: Tables in Cluster table

Former Member — Wed, 10 Nov 2010 12:20:30 GMT

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

Re: Tables in Cluster table

venkat_o — Thu, 11 Nov 2010 02:07:31 GMT

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

Re: Tables in Cluster table

Former Member — Sun, 05 Dec 2010 20:03:57 GMT

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.