How to set key fields in a Database view

Former Member · ‎2010 Apr 13

Hi guru's

iam balaji,plz guide me with how to set key fields in a view.......that field is a non key field in the base table....

thanks in advance,

Balaji.S

Former Member · ‎2010 Apr 13

take a look at this:

Diagnosis

In the view, not all of the mandatory fields were included as key

fields. The key of the view therefore is not unique.

System Response

All the fields are regarded as key fields in order to guarantee that th

key lengths are unique.

Procedure

For views with a large number of fields, this could have a negative

effect on the performance for the language construction described below

In this case, all the mandatory key fields should be included in the

view.

regards

Former Member · ‎2010 Apr 13

For example:

in a view between VBAK-VBAP, make sure that your field list contains

VBAP MANDT

VBAP VBELN

VBAP POSNR

That will be the key.