Reg Database view

[Former Member]

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

[prasanth_kasturi]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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.

[manubhutani]

hi

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