topic Re: Reg Database view in Application Development and Automation Discussions

Reg Database view

Former Member — Tue, 13 May 2008 05:37:45 GMT

hi gurus

I am creating a database view . In that , i am getting duplicate records.

So i wan to do maintenance .,' but its not allwing me to do that.

How can i ? please very urgent .,,

ie Table maintenance Generator

is in disable mode

Regards

karthik

Re: Reg Database view

prasanth_kasturi — Tue, 13 May 2008 05:46:07 GMT

hi,

first do maintenance generator for the tables

and then create the database view

in the database view u cannot create a table maintenance generator because you cannot maintain values through database view. its only possible through maintenanace view.

in database view u can only change the existing(1 table case) but cannot update(create) new records.

if database view has more than one table you can only dispaly.

hope its clear

REGARDS

PRASANTH

Edited by: prasanth kasturi on May 13, 2008 9:02 AM

Re: Reg Database view

Former Member — Tue, 13 May 2008 05:59:22 GMT

Hi karthikeyan pal... ,

when you are creating a database view first check the tables you are combining and their keys relationship.If you use same fields as relation between those two tables,then you won't get duplicate records.

Hope this might be helpful.

Please reward points if found helpful.

Thanks and reagrds,

Rajeshwar.

Re: Reg Database view

Former Member — Tue, 13 May 2008 06:05:51 GMT

Hi ,

When you are creating a database view first check the tables

and their key fields ,then you won't get duplicate records.

Also in the attributes of the table there is maintence tab

in this you will have toset the permissions accordingly

Sandesh

Re: Reg Database view

Former Member — Tue, 13 May 2008 06:16:38 GMT

From SE11 create the DB view and join the tables with the key fields

Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

Please have a look at below link. It will help you.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm

for more detailed info look on:

http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+dictionary&;

Reward points for useful Answers

Regards

Raj.

Re: Reg Database view

manubhutani — Tue, 13 May 2008 06:24:22 GMT

if u have more than 2 database tables, then u can only read values.

if u have 1 table,then u can change as well.

if u wana maintain values,then use maintenance view.

Please reward points