databease view

[Former Member]

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

[Former Member]

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

[Former Member]

i THINK nOT OK

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi all,

Thanks for ur valuable advise

Thansk again