Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How can we determine a vendor is Bloc/Unblock from the table LFA1?

2138


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1939


How do you Export a session ?

1931


What are the attributes of the data? : abap data dictionary

1125


Explain the components of selection table?

1193


What is an update task?

1102


To find the date difference & excude saturday & sunday in between them

2091


What are the domains and data elements?

1667


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/

2354


In events, start-of-selection is a default event. When we have to use this event explicitly? Why?

1080


How are BAPI different from Normal function modules ?

2187


The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization

1158


Can i know some of the Realtime tickets that anyone has been faced ?

2219


What is the syntax for call transaction? : abap bdc

1126


What are interface/conversion programs in SAP?

1243