topic Re: Define view for cluster table? in Application Development and Automation Discussions

Define view for cluster table?

Former Member — Tue, 01 May 2007 17:22:59 GMT

Hi Experts,

Can we create a database view with a cluster table? Please let me know how.

Regards,

Vishal.

Re: Define view for cluster table?

ferry_lianto — Tue, 01 May 2007 17:27:34 GMT

Hi,

It is not possible to create database view for cluster table.

Because cluster table mainly contains records in compressed form and views can not be created by mere selection for fields.

Regards,

Ferry Lianto

Re: Define view for cluster table?

Former Member — Tue, 01 May 2007 17:43:09 GMT

Hi Ferry,

Thanks for your answer. There would be the base tables from which a cluster is defined. I am not a tech guy, but only a functional person. Just wanted to know how could we know what tables are attached to a cluster table. for e.g. table REGUP.

regards,

Vishal Thakur

Re: Define view for cluster table?

ferry_lianto — Tue, 01 May 2007 18:10:12 GMT

Hi,

Please try this and use BSEG as an example.

1. Go to SE12.

2. Enter BSEG

3. Click Display button

4. Go to Delivery and Maintenance' tab.

5. You should be able to see Pool/cluster RFBLG.

6. Double click RFBLG and then click Where-Used list button (CTRLSHIFTF3).

7. Select Table option and click Execute button.

8. System will show all the table that belong to this pool/cluster.

For Pool/Cluster REGUC, it is only used in table REGUP.

Regards,

Ferry Lianto

Re: Define view for cluster table?

Former Member — Tue, 01 May 2007 18:18:38 GMT

That is my problem. I had already done this and found that for REGUC there is only REGUP. Kind of circle back to the same thing.

Regards,

Vishal.

Re: Define view for cluster table?

Former Member — Tue, 01 May 2007 18:45:27 GMT

Do a where used list of the cluster (REGUC) in tables.

Rob