topic Re: VIEWS in Application Development and Automation Discussions

VIEWS

Former Member — Wed, 02 May 2007 03:46:55 GMT

Hi PPL,

Could you please tell me whether we can update database records using views.

Thanks and regards,

Ashok

Re: VIEWS

Former Member — Wed, 02 May 2007 03:52:21 GMT

Hi,

Yes we can update the database tables using Views.

Rgds,

P.Naganajna Reddy

Re: VIEWS

Former Member — Wed, 02 May 2007 04:05:47 GMT

If the database view only contains a single table, the maintenance status can be used to determine if data records can also be inserted with the view. If the database view contains more than one table, you can only read the data.

<b>Only read access is permitted for database views that are defined through several tables.</b>

Hope this will give u an idea.Check out this link..

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecab446011d189700000e8322d00/frameset.htm

Please reward graciously if found helpful.

Re: VIEWS

Former Member — Wed, 02 May 2007 05:21:40 GMT

Hi ,

You can only edit/insert the database records through views only if the view does not have any join ( ie., a single table or a join on a single table) . If you have multiple tables on the view then you will have only read access.

Hope this helps

Sunil.M

Re: VIEWS

Former Member — Wed, 02 May 2007 07:49:20 GMT

hi,

yaa we can update database records using views but the type of view must be maintenace

Re: VIEWS

Former Member — Wed, 02 May 2007 08:07:16 GMT

Hai,

You can do like this:

tables:

view_name.

Data:

begin of itab occurs 0,

include structure view_name.

Data:

end of itab.

select *

from view_name

into itab.

loop at itab.

wa-f1 = itab-f1.

...

db_tab = wa.

insert db_tab.

endloop.

Regds,

Rama chary.Pammi

Re: VIEWS

Former Member — Wed, 02 May 2007 11:36:30 GMT

yes you can update the containt of database table using views

i.e : By using <b>MAINTAINANCE VIEW</b>.

Regds,

subodh

Message was edited by:

subodh gholkar

Re: VIEWS

Former Member — Wed, 02 May 2007 11:40:20 GMT

Hi,

IF database view contains only one table or tables with inner joins only can be used for data additions. view wiith outer joins/other joins are not allowed.

Jogdand M B