Answer / suman

2 types of indexes
1. Basic index - default it will exist for tables.
2. Secondary index - we need to create on requirement.

Answer / 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

Answer / yarru sreenivasa rao

grouping of fields

index contain idexfields and pointer to data record in that
table


unique index
nonunique index

speed up the data retrieval due index fields r sorted

VVVV.Urgent- How can i develop more than 30 interactive lists in reports.

4 Answers   HCL,

---

What is the purpose of sum statement?

0 Answers  

---

How can I get ascii value of any letter? Is there any function?

0 Answers  

---

what is the use of control_form?

2 Answers  

---

How do you do effort estimation? Based on which parameters?

2 Answers   KPIT,

---

---

LSMW?

1 Answers   EDS, Wipro,

---

What is the keyword used to access a program from global memory?

1 Answers   HCL,

---

Does the call transaction method allow multiple transactions to be processed by sap?

0 Answers  

---

A company asked me to reply the below question Please send the one page note on your understanding of your module--- topics and duration)???

0 Answers  

---

Normally how many and what files get created when a transaction program is written?

0 Answers  

---

Tcode for create Basic ALE settings?

1 Answers   Intel,

---

How to get the status of an IDOC in a report without using WE02 transaction ?

1 Answers  

---