Creating Indexes in Cluster Tables

[Former Member]

Hi,

I want to enable the index for the a cluster table..how is it possible..As we see for transparent tables like MSEG ,index tab is enabled but tables like BSEG the option is disabled..Please help me find a solution..

Regards

Maria

[Former Member]

Hi,

I want to enable the index for the a cluster table..how is it possible..As we see for transparent tables like MSEG ,index tab is enabled but tables like BSEG the option is disabled..Please help me find a solution..

Regards

Maria

[Former Member]

Hi Maria,

We cannot create index on the cluster tables. So when you are using these tables make sure that you are using primary key of Cluster tables.

Regards,

Shahu

Message was edited by:

shahuraj shirure

[Former Member]

Hi Maria,

SAP does not allow creation of an index for a cluster table.

Cluster tables are clusters of transparent tables, so if you want to use an index, can you identify which of the component tables contains the data you require?

If so, you could access that table directly via an index.

Hope that helps.

Regards

Robin

[RaymondGiuseppi]

You cannot create index on cluster table in SAP.

BSEG is a cluster table, so no index, but hopefully there are "database indexes" on BSEG, which are actual database table : BSIS, BSAS, BSID, BSAS, and so on.

BSEG Access

BSAD Accounting: Secondary index for customers (cleared items)

BSAK Accounting: Secondary index for vendors (cleared items)

BSAS Accounting: Secondary index for G/L accounts (cleared items)

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary index for G/L accounts

Create index on these tables.

Look also at

Regards