view on cluster table

[Former Member]

hi all,

I am trying to create a view for the tables bkpg and bseg.but am unable to as the error is "bseg is cluster table".

can't we create view for cluster table. if can, how

[Former Member]

Follow the forum rules by assigning points to helpful answers so that it

will be helpful to others in future to identify the soultions.

Note: You have not assigned even in one single thread.

[GauthamV]

No, you cannot create views for cluster tables.

[Former Member]

thanks alot

[GauthamV]

Follow the forum rules by assigning points to helpful answers so that it

will be helpful to others in future to identify the soultions.

Note: You have not assigned even in one single thread.

[Former Member]

We can not create views for cluster tables...

[JoffyJohn]

You cannot create 'Database view ' for cluster table. As database view create a view in the database also.

The search technique for cluster table is different. so it cannot be used.

You can create other views like projection view, maintainence view etc. as they don't create views in database also.

[RaymondGiuseppi]

You cannot create a view because BSEG is in a cluster table

For this reason SAP has provided some "secondary index" tables, look for :

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

Regards