topic Creating Indexes in Cluster Tables in Application Development and Automation Discussions

Creating Indexes in Cluster Tables

Former Member — Wed, 11 Apr 2007 11:20:34 GMT

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

Re: Creating Indexes in Cluster Tables

Former Member — Wed, 11 Apr 2007 11:28:11 GMT

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

Re: Creating Indexes in Cluster Tables

Former Member — Wed, 11 Apr 2007 11:35:26 GMT

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

Re: Creating Indexes in Cluster Tables

RaymondGiuseppi — Wed, 11 Apr 2007 11:39:51 GMT

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