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

Access with index

Hi,

what is the purpose for the secondary index in ABAP dictionary?

Regards,

Luke

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Dec 04, 2007 at 03:34 AM

    hi

    whenever u r using non primary key field in a select statement of where condition

    system checks for secondary index and assigns automatically

    its speed up data retrieving.

    Regards

    Nagesh.Paruchuri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:53 AM

    Thank you very much

    Regards,

    Luke

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:44 AM

    DATA MODELER

    SAP-SERM:

    SAP SERM = (Structured Entity Relationship Model). It supports the user during modeling and when mapping the created model to the ABAP/4 Dictionary.

    TOP DOWN Model:

    First an overall model is created for the area to be modeled. Attributes are defined for the individual entity types. If the technical and semantic characteristics of the attributes are clear data elements (and domains) can be created or existing ones can be used, based on the data model.

    BOTTOM UP Model:

    The Data Modeler can also be used for (subsequent) modeling of an application, which already exists. In this case, entity types are created for tables and views, which already exist, and the tables and views are assigned to these entity types. The entity types obtain their attributes in this way.

    HOW IS THE LINK BETWEEN THE DATA MODELER AND THE ABAP/4 DICTONARY CREATED?

    Assigning entity types to tables are views creates the link between the Data Modeler and the ABAP/4 Dictionary. New tables or views can be created from the entity type. The attributes of the entity type can be transferred as fields of the table, and the data elements created can be used again.

    Once this assignment has been made the fields of the view or table are displayed as attributes of the entity type, and are overlaid on the attributes (with the same name) which were previously entered for the entity type. Changes in the assigned Dictionary objects (for example adding, removing or changing fields) therefore take immediate effect, and are visible in the Data Modeler. This ensures the consistency of the data model and Dictionary, in that they access the same information.

    The relationship of the entity types that were modeled in the data model are stored in the Dictionary as semantic foreign keys in the foreign key relationships. They therefore directly reference the particular modeled reference type or the specified reference type cardinality.

    Thanks

    Siva Kumar

    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.