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
What are the basic object types? : sap abap hr
how to modify the standard method as per your requirement
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
Tell me a scenario where did you use secondary index?
What is a subroutine?
What are different data types in abap/4?
Give an example of interface from your project explaining why you used it?
What are the check tables and value tables?
Why do we use FOR ALL ENTRIES and what is the pre-requisite
How many main windows are allowed in sapscript?
How many types of size categories and data classes are there?
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
What are two methods of modifying sap standard tables?
If yes then why do we require logical database
What is an update task? : abap modularization