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

what is diff between ECC 5.0 AND ECC 6.0

3320


In SAP Script,How to display a single field(like matnr)at the right end of the form.

2451


Explain how do you move on to the next screen in interactive reporting?

1034


In sap script how to print bar code in vertical manner

3959


What are the pooled and cluster tables?

1038


Proxy Programming with ABAP - How to develop the Proxy identification through programming

2356


Explain the difference between tables and structures?

996


In a loop of an internal table, what is the use of at first & at last statements?

1978


What are the advantages/ dis-advantages of logical databases?

984


Module Pool Programming: Events and Table Control handling.

1399


what is leave to TRANSACTION?

1502


How to create a button in selection screen ?

2014


What are th control break events in abap?

1107


What is web dynpro for abap?

1056


What is the syntex used to call a screen as dialog box (pop up)?

1188