topic Re: In VIew Keyfield is missing in Application Development and Automation Discussions

In VIew Keyfield is missing

Former Member — Mon, 09 Apr 2007 08:47:02 GMT

Hi Friends,

I created one view and attached to one transaction..its giving dump..becuase its showing like <keyfield> is missing inthat view.. where we will use this view.. please suggest me.. its urgent..please give me thre right solution..

regards,

sampath

Re: In VIew Keyfield is missing

Former Member — Mon, 09 Apr 2007 08:51:45 GMT

Check if you have followed the correct procedure to create a Database View.

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

Regards,

Ravi

Re: In VIew Keyfield is missing

Former Member — Mon, 09 Apr 2007 22:14:27 GMT

What type of view is this and what is the transaction for?

Re: In VIew Keyfield is missing

Former Member — Tue, 10 Apr 2007 11:20:29 GMT

Hai,

The join condition shound be on the key fileds.

Check atleat one key fields(including MANDT/CLIENT field) are paricipated in the join conditon from each table.

reward points if it helps you.

Regds,

Rama chary.Pammi

Re: In VIew Keyfield is missing

Former Member — Tue, 10 Apr 2007 12:01:05 GMT

Hai,

Make sure that u have included all key fields in both the table.

for ex....

if i want to join two table name : MARA and MAKT.

then the keyfields of both the table should has to be specify...

Mara-Mandt = Makt-Mandt

Mara-Matnr = Makt-Matnr

Regds,

Purshoth

Re: In VIew Keyfield is missing

Former Member — Tue, 10 Apr 2007 12:01:53 GMT

Hai,

Make sure that u have included all key fields in both the table.

for ex....

if i want to join two table name : MARA and MAKT.

then the keyfields of these tables should has to be specify on the join condition

Mara-Mandt = Makt-Mandt

Mara-Matnr = Makt-Matnr

Regds,

Purshoth