cancel
Showing results for 
Search instead for 
Did you mean: 

View on table PA0021

Former Member
0 Kudos

Hi mates,

I am trying to creat view on table PA0021 and Table T500C.I am getting follwing

warnings. I could not activate View.

Check view ZDS_PA0021 (USER27/04/26/07/11:43)

Key field T500C-ENDDA missing

All fields are evaluated as key field

View ZDS_PA0021 is consistent .

I have already in add PA0021-ENDDA in view fields.

Any inputs plz.

hari

null

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks problem solved

Former Member
0 Kudos

Hi Hari,

When you activate the view, it gives you the warning about the inconsistencies you may face at the later stage with the object. However, if you click on back button you will find that the view has been activated by the system and you can start working with the same.

I myself tried to create the view as per your scenario and found some inputs from SAP help...... here they are:

Key field T500C-MANDT missing

Message no. MC763

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 the 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.

Notes

The key information is relevant for the ABAP/4 language constructs SELECT SINGLE, SELECT ... ORDER BY PRIMARY KEY and SELECT ... FOR ALL ENTRIES.

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 sort according to all fields in these cases.

Cheers!

Amit