Key field in Data dictionary View

[Former Member]

Dear friends,

I have been trying to join 3 table and create a view.Everything works fine except one thing.When i activate view in DDIC ,i get message that all fields are evaluated as Keys ,but i have not defined all fields as keys .After that all fields are marked as keys.Please tell me how to solve this .

P.S: I guess if all fields are marked as keys then it will be necessary to have data in all field thane and then i can get output.Am i Right?

Nirad

[Former Member]

Hi Nirad,

Did you follow the same sequence of steps as defined here:

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

?

Regards,

Ravi

[Former Member]

yups ..but no difference.

[Former Member]

Hi Nirad,

Which all table you are joining?

Regards,

Atish

[Former Member]

see follow the table sequence in the join condition..

example

<b>KNA1

KNBK

T005.....</b> Then join condition is

<b>KNA1-KUNNR = KNBK-KUNNR

KNA1-KUNNR = KNC1-KUNNR

KNBK-BANKS = T005-LAND1 </b> ....likewise declare it ..

don't give

<b>KNBK-KUNNR = KNA1-KUNNR

T005-LAND1 =KNBK-BANKS</b> and remember all the tables should have join condition ...

activate it ....

then in the next screen fields selection ...

by defualt there will be primary keys because you had activated the join so it come in the screen .... then go for the field selection ... it should not be repeated from the different table s.

Activate it again ...

then in the next screen for maintaince acesss like read/write/change/delete ..etc .

Girish

[Former Member]

I have solved my problem at my own..

See if a field is primary key in two table out of joined three tables and we are gonna show that field in the view then we have to join two tables on that primary key also,otherwise all fields will be evaluated as Key fields.

Nirad

[Former Member]

I have solved my problem at my own..

See if a field is primary key in two table out of joined three tables and we are gonna show that field in the view then we have to join two tables on that primary key also,otherwise all fields will be evaluated as Key fields.

Nirad