topic Key field in Data dictionary View in Application Development and Automation Discussions

Key field in Data dictionary View

Former Member — Mon, 11 Jun 2007 19:10:21 GMT

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

Re: Key field in Data dictionary View

Former Member — Mon, 11 Jun 2007 19:46:01 GMT

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

Re: Key field in Data dictionary View

Former Member — Mon, 11 Jun 2007 20:26:28 GMT

yups ..but no difference.

Re: Key field in Data dictionary View

Former Member — Tue, 12 Jun 2007 00:02:10 GMT

Hi Nirad,

Which all table you are joining?

Regards,

Atish

Re: Key field in Data dictionary View

Former Member — Tue, 12 Jun 2007 03:07:17 GMT

see follow the table sequence in the join condition..

example

KNA1

KNBK

T005..... Then join condition is

KNA1-KUNNR = KNBK-KUNNR

KNA1-KUNNR = KNC1-KUNNR

KNBK-BANKS = T005-LAND1 ....likewise declare it ..

don't give

KNBK-KUNNR = KNA1-KUNNR

T005-LAND1 =KNBK-BANKS 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

Re: Key field in Data dictionary View

Former Member — Tue, 12 Jun 2007 12:32:00 GMT

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

Re: Key field in Data dictionary View

Former Member — Tue, 12 Jun 2007 12:44:52 GMT

I have solved my problem at my own..

Nirad