topic Re: databease view in Application Development and Automation Discussions

databease view

Former Member — Mon, 11 Jun 2007 16:50:01 GMT

Hi ,

I am getting some warnings while creating a database view.

say i am creating join between table1 and table2

since iam not adding all the primary fields of both the tables iam getting a warning but its getting activated.

is should be ok while transporting right

let me know

thanks

Re: databease view

Former Member — Mon, 11 Jun 2007 16:52:23 GMT

Hello Venki,

If u r not using all the key fields of both the tables then you wiull get the correct data from both the tables.

The records will be repeated which leads to data redundany.

So try to use all the key fields

Vasanth

Re: databease view

Former Member — Mon, 11 Jun 2007 16:53:15 GMT

i THINK nOT OK

Re: databease view

Former Member — Mon, 11 Jun 2007 16:54:46 GMT

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.

Re: databease view

Former Member — Mon, 11 Jun 2007 16:59:15 GMT

Hi venki,

YOu have to link up the tables based on the common Primary Key fields .

Otherwise, it defeats the basic purpose of creating a view over the two tables..

You would get duplicate records which obviously isn't right.

Regards,

Ravi

Re: databease view

Former Member — Mon, 11 Jun 2007 17:00:31 GMT

Hello Venki,

There is no problem if all keys are not specified in the join condition . u can still use the view . but when u select from the view you will get duplicates entries . it is better to use all the keys in the join condition.

Re: databease view

Former Member — Mon, 11 Jun 2007 17:05:13 GMT

Hi,

The view ignores client-dependency of the base tables

Key field LFA1-MANDT missing

All fields are evaluated as key field

View ZZ_LF is consistent

by adding mandt it should overcome the warning right

I see all the primary keys of two tables in my database view except Mandt

LET ME KNOW

Re: databease view

Former Member — Mon, 11 Jun 2007 17:09:05 GMT

Hi Venki ,

Yeah even mandt should be added to join conditions since the base tables are client specific .

let me know this works ..

Regards

Sridhar S

Re: databease view

Former Member — Mon, 11 Jun 2007 17:11:17 GMT

hi,

it should be ok, while transporting, but there is a scope to affect the perfomance in furthur usage or in further releases....

At activation, a log is written; it can be displayed with<b> Utilities----> Activation log.</b> If errors or warnings occurring when the view was activated, they are displayed directly in the activation log.

using the log, try to avoid the errors which are occured during the view activation.

regards,

Ashokreddy

Re: databease view

Former Member — Mon, 11 Jun 2007 17:18:04 GMT

Hi all,

Thanks for ur valuable advise

Thansk again