Problem with Key defination in views

[praveen_hannu]

Hi Friends

I have created a database view which includes 3 tables(KNA1, VBAK and VBAP), while adding the fields in the fields list, it is considering all fields as key fields. I have done check and uncheck of modification of data element check box, it is showing as uncheck the key column, but once I activate the view, then it is selecting all fields are key fields. I have a problem when I am accessing this view from third party systems cause with these many key fields. Please tell me is there any way to choose key fields in the data base view.

Awaiting for your response.

Regards

Praveen

[ThomasZloch]

Try adding all primary key fields of these three tables to the view (MANDT, VBELN, POSNR, KUNNR).

Thomas

[praveen_hannu]

Hi Thomas

Thanks for your reply, I have added all key fields in the view, but still contains the same problem.

Regards

Praveen

[ThomasZloch]

Those fields should be on top of the view's field list. Also, the join conditions must be complete, e.g. also include MANDT, as far as I know.

The system defines all view fields as key fields, if it cannot otherwise determine a unique key based on the join conditions and the primary keys of the joined tables.

If that's not it, I have no further idea.

Thomas