Define view for cluster table?

[Former Member]

Hi Experts,

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

Regards,

Vishal.

[ferry_lianto]

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

[Former Member]

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

[Former Member]

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

Rob

[ferry_lianto]

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

[Former Member]

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.