Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index ? Types of index and there uses ?
- 3 Answers
- 11859 Views
- Deloitte, I also Faced
- E-Mail Answers
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 components in sap application server?
What is a database view? : abap data dictionary
Example of table cluster and cluster tables.
How are the date abd time field values stored in sap?
What work you have done in HR module
What are null values? : abap data dictionary
What are the two levels in defining a match code? : abap data dictionary
What is sap locking?
What does the insert statement in extract datasets do?
How to display if the value entered contains records or not?
what is defference between repository and non repository Object?
What is the function module to popup contents in the internal table?
What is a match code? : abap data dictionary
How to convert normal function module to bapi?
How we can retrieve data using secondary index. Explain with simple example?
