Diagnosis In the view, not all of the mandatory fields were included as keyfields. The key of the view therefore is not unique. System Response All the fields are regarded as key fields in order to guarantee thatthe key lengths are unique. Procedure For views with a large number of fields, this could have a negativeeffect on the performance for the language construction describedbelow. In this case, all the mandatory key fields should be included inthe view. Notes The key information is relevant for the ABAP/4 language constructsSELECT SINGLE, SELECT ... ORDER BY PRIMARY KEY and SELECT ... FOR ALLENTRIES. In these cases, SELECT SINGLE is handled like a simple SELECT ...ENDSELECT, where the first (random) record found is returned. ORDER BY PRIMARY KEY and (indirect) SELECT FOR ALL ENTRIES sortaccording to all fields in these cases. |