What is an index ? Types of index and there uses ?
Answer Posted / aditya sharma
There are two types of indexes:
1.Primary Index
2.Secondary Index.
While creating a table or in an existing standard table the
key fields are the default primary indexes.
If we require to fetch records from non key fields we need
to provide Secondary Indexes.i.e., we need to explicitly
make non key fields as indexes.
This can be done by clicking on Index and adding the fields
for secondary index.
For Some major standard table SAP has provided secondary
Indexes like
Eg: BSEG table. As BSEG is a cluster table data retreival
using non key fields like Customer/vendor/GL account data
makes the response slower.So SAP has provided standard indexes.
Secondary index tables:
For Customer BSID and BSAD.
For Vendor BSIK and BSAK
For Material BSIM
For GL AccountBSIS
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to select valid lines for secondary list?
Double click function on the lists, identifying the line selected by the user on the list?
Rp_provide_from_last contains how many parameters ? : abap hr
Can you set up background processing using call transaction?
How do you find the information on the current screen?
What are conditional chain statement?
How many types of size categories and data classes are there? : abap data dictionary
What are the different types of locks? : abap data dictionary
What are the differences between interactive and drill down reports?
What is meant by exclusive, not cumulative lock? : sap abap data dictionary
What is step-loop? Explain all the steps?
How to Raise a Particular Ticket in Realtime ?
how 2 create the normal form by using functional module
What is the meaning of sap r/3?
Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button