Database View cannot display contents

[former_member457651]

Dear:

I created a database view, which contains fields from 3 diffrerent Z-Tables.

The view is working fine if I call it by ABAP SQL, however, I am not able to broswe data if I use it through SE11.

The Utilities -> Contents is dimmed.

Is anything I forget to setup?

Thank you.

[former_member848108]

Hi,

Please check the maintenance statusof the view using tcode SE11.

It seems that you view has the status Display / Maintenance Not Allowed,

change it to Display / Maintenance Allowed.

Regards.

Ozcan.

[kesavadas_thekkillath]

+1

[samantak_chatterjee]

Hi Hung,

In the Database View, you have to mention the kind the access that you would like the view to have.

Generally, Database Views are only used to update a Table if they are created on a single Table. Else they are generally used to read data.

So, you have to create a Database View on a single Table. And in that you have to navigate to the Maintenance Status. There in the Access Section, you have to mention the kind of Access you need like - Read Only or Read and Change. And then Data Browser and Table Maintenance View - Display Maintenance Allowed.

If you maintain these above mentioned settings, then only you can be able to maintain entries in the Table.

Hope this helps.

Thanks,

Samantak.

[Former Member]

Hi,

Generally Data base view is used to read the data from multiple tables...please check did you consider all the primary keys of tables while joining them, did you activate the view properly? once the view is activated properly, you can access it from program by using select statement.

Hope this will help you..

Regads,

Kiran