SAP - DDIC - Table Indexes

Index in DDIC - An index is a copy of a database table that is reduced to few fields. This table copy is always in a sorted form. Sorting helps to access the data records of the table faster. For example - when you use a binary search.

To create secondary index go to SE11 table creation screen and then go to Indexes. Each index has a unique one to three character identifier, or id in R/3. An index can consist of more than one field. The ID 0 is reserved for the primary index.

The index name on the database adheres to the convention "< Table_Name >/< Index_ID >".

      Important Questions
        Q. How you use the secondary index in the ABAP program?
        A. There are two ways where secondary index is used:

             1. In SELECT statement with WHERE clause.
             2. READ TABLE statements write INDEX < indexname >.

        Q. What is the use of 'table index'?
        A. Index is used for faster access of data base tables.

Control table - is a type of delivery class in DDIC which has separate key areas for SAP and customer.
For example - Table TSADRV is a control table.

Note: The Control Tables specify that it is the table where data is not changed frequently and pertains to information for the flow of the system.

        The following are the delivery classes:
           A: Application table.
           C: Customizing table, maintenance by customer only.
           L: Table for storing temporary data.
           G: Customizing table, entries protected against overwriting.
           E: Control table, SAP and customer have separate key areas.
           S: System table, maintenance only by SAP.
          W: System table, contents can be transported via own TR objects.







                                                      Copyright © 2011 All rights reserved.