can i create a view based on Cluster table ?

[Former Member]

Hi,

I have a requirment to create a view based on KONV ( cluster table) and VBRK ( database table). it says we cant create. so how it is possible?

Thanks,

Ravi

[Former Member]

Hi,

Check

http://help.sap.com/saphelp_nw2004s/helpdata/en/d0/999246b2aa11d1a5700000e82deaaa/frameset.htm

[Former Member]

Hi Ravi,

It actually depends on the type of view you are trying to create.

Projection view it is possible - See the standard views ENT5067, V_BAM_KONV where KONV is used.

Database view - Cluster tables not allowed

Definition by SAP " Database views

The view defined in the ABAP Dictionary is reproduced in the underlying

database. You can use both ABAP Open SQL and ABAP Native SQL to access

such views from ABAP programs, but you can only define them using

transparent tables. If you define a database view using only one table,

you can make changes to the view. For database views containing several

tables, however, only read accesses are allowed."

Regards,

Rajvansh

[Former Member]

Hi,

Of course, you can create a view based on cluster table.

You can create a database view for these two tables 'KONV' AND 'VBRK'.

sorry I made a mistake.

I have check the table 'KONV' and 'VBRK', I found there is no relationship between.

actually table ' VBAK' has the relationship with 'KONV'.

Do you misspell it?

Regards,

Chris Gu

Edited by: Gu Chris on Nov 19, 2008 7:54 AM

[Former Member]

Hi Gu,

I don't think Database view is possible for Cluster table KONV

Kindly Check this link

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

It says "Since a database view is implemented in the database, a database view may only contain transparent tables"

Regards

Rajvansh