topic Re: view on cluster table in Application Development and Automation Discussions

view on cluster table

Former Member — Fri, 03 Apr 2009 06:00:25 GMT

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

GauthamV — Fri, 03 Apr 2009 06:05:47 GMT

No, you cannot create views for cluster tables.

Former Member — Fri, 03 Apr 2009 06:06:43 GMT

We can not create views for cluster tables...

Former Member — Fri, 03 Apr 2009 06:09:33 GMT

thanks alot

GauthamV — Fri, 03 Apr 2009 06:25:08 GMT

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.

JoffyJohn — Fri, 03 Apr 2009 06:28:20 GMT

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 — Fri, 03 Apr 2009 06:42:58 GMT

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