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

Can ‘where’ clause be used when updating database entries?

1 Answers  

---

defination of workarea? and header line

1 Answers  

---

Polymorphism real time scenario

0 Answers   Infosys,

---

any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?

0 Answers   KPIT,

---

After transferring of data from flat file to application server i found that it is showing wrong data .Say i had currency in flat file as 1000.00 USD. After transferring i found it is showing as 100.000 in the application server. How will you handle this case?

1 Answers   Thomson Reuters,

---

SAP Date Format?

4 Answers  

---

what is the difference between rfc and function module

2 Answers  

---

What are the two levels in defining a match code ?

0 Answers  

---

what are userexits?? how to use it?? whats the importance of them?? can it be used in interactive reporting to directly come to basic list??

2 Answers   Essar,

---

where are the passwords for ITS stores?

0 Answers  

---

How do you call a report from a transaction ?

3 Answers  

---

What is table maintenance generator?

7 Answers   Cap Gemini, CSC,

---