Cluster tables

[Former Member]

Hi all,

I need to create a query from Oracle to read BSEG table, but this table is a cluster table.

We are looking for information about how to know which transparents tables make it this cluster table but we don´t find anything.

Anybody have documentation about how to know which transparent tables form a cluster table? and how do you find out?

Very thanks in advance,

Néstor.

[vinod_vemuru2]

Hi,

Transperant tables won't form the cluster table. Both are siblings i can say. Means Transperant, cluster, pooled etc are different types of tables which comes under same hierarchy.

In case of cluster tables, data is stored as a cluster.

Say if you have 4 cluster tables in a table cluster, there will be a common key between these 4 tables. When ever an update happens, it happens at cluster level but not at the individual table level. Same thing happens even when you query these tables. All the data related to all the tables in the cluster which satisfy the WHERE clause is selected even if you query a single table. Thats the reason why these are slow in responce

You can check the table cluster name for a cluster table in delivery and maintenance tab of SE11.

Thanks,

Vinod.

[Former Member]

But I have a problem with this because if I try looking for these objects (cluster tables) in the Oracle database, the answer is that the object not exist.

For example:

SQL> select * from bseg;

ERROR: ORA-00942: table or view does not exist

SQL> desc bseg;

ERROR: ORA-04043: object bseg does not exist

I would like to consult this tables types from SqlPlus, rather, their associated fields...

Thanks again.

[vinod_vemuru2]

Hi,

In SAP's oracle database table name is stored with the cluster name which is RFBLG. So modify your query to select the data from RFBLG. Ideally it should work fine.

Thanks,

Vinod.

[Former Member]

You won't be able to write a query on either BSEG or RGBLG. Fortunately, you should be able to get the data from other related tables. You can start with the secondary index tabes:

BSIS

BSAS

BSID

BSAD

BSIK

BSAK

Rob

[Former Member]

Is there a way to get the tables of cluster tables? Through the transaction, documentation,...

I would like to know KONV table too.

Very thanks.

[Former Member]

For RFBLG, go to SE11 and display RFBLG. On the display screen, go:

Utilities - > Where used list.

Click on "Tables"

Rob

[Former Member]

OK, that's right, but in KONV table, the pool table is KOCLU.

SE11 -> KOCLU -> Where-used List -> only table is KONV... and this is wrong for me.

Any other ideas?

Thanks for your help

[Former Member]

>

> only table is KONV... and this is wrong for me.

I don't really understand. What would be correct?

Rob

[Former Member]

KONV is a cluster table too and if I attemp to access it from sqlplus...

ORA-04043: object KONV does not exist

Regards.

[Former Member]

I'm not that familiar with KONV, but what I might do is notice that KNUMV is the first keyfield in NONV. You can do a where used list on this data element and see if you find any tables that are useful.

Rob

[Former Member]

Thanks a lot for your help and your time.

Néstor.

[Former Member]

HI Nestor,

Please check the below thread
go to DD02L and pass SQLTAB = RFBLG
in case of CDPOS pass SQLTAB = CDCLS " This way you can find the values for any Cluster Table
in case of KONV pass SQLTAB = KOCLU " Similarly for any Cluster Table

Regards

Ram