topic Problem with Key defination in views in Application Development and Automation Discussions

Problem with Key defination in views

praveen_hannu — Tue, 25 Nov 2008 07:28:53 GMT

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

Re: Problem with Key defination in views

ThomasZloch — Tue, 25 Nov 2008 07:50:59 GMT

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

Thomas

Re: Problem with Key defination in views

praveen_hannu — Tue, 25 Nov 2008 08:02:56 GMT

Hi Thomas

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

Regards

Praveen

Re: Problem with Key defination in views

ThomasZloch — Tue, 25 Nov 2008 08:29:48 GMT

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