on 04-26-2007 5:41 PM
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
Thanks problem solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.