Skip to Content
author's profile photo Former Member
Former Member

View on table PA0021

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 05:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 10:00 PM

    Thanks problem solved

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.