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 can we determine a vendor is Bloc/Unblock from the table LFA1?
What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary
How do you Export a session ?
What are the attributes of the data? : abap data dictionary
Explain the components of selection table?
What is an update task?
To find the date difference & excude saturday & sunday in between them
What are the domains and data elements?
I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/
In events, start-of-selection is a default event. When we have to use this event explicitly? Why?
How are BAPI different from Normal function modules ?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
Can i know some of the Realtime tickets that anyone has been faced ?
What is the syntax for call transaction? : abap bdc
What are interface/conversion programs in SAP?