Answer / sharath

1 Primary Index and 21 secondary Index totally 22 Index we can create in ECC6.00.

Answer / gopi paruchuri

16 Primary indexes and 9 secondary indexes

Answer / damodar reddy

For any table we can create 1 primary index and maximum of
15 secondary indexes.

Answer / niranj

You should not create more than five indexes for any one
table because:

Whenever you change table fields that occur in the index,
the index itself is also updated. The amount of data
increases. The optimizer has too many chances to make
mistakes by using the 'wrong' index.


If you are using more than one index for a database table,
ensure that they do not overlap.

Answer / vadamalai a

Only 9 Indexes allowed

Answer / bala

1 index..

Answer / sukhbir

Max : 15 index.

What are the drill-down features provided by abap/4 in interactive lists?

0 Answers  

Table ztest has a secondary index on the following fields: tnum, tcode. Select * from ztest where tnum ne '123' and tcode = '456'. Why is the index not used in the above case? Choices: a) Indexes are not allowed on Z tables b) Variables must be used, NOT literals c) Select individual fields, not select * d) Client is not in the where clause e) NE invalidates the use of an index Info: Can someone explain in detail why this happened? It will be really helpful to handle to case in Secondary index:

2 Answers   SAP Labs,

1)you are creating the table and with EmpID, Lastname and Zender(Male and Female) only the Male and Female data only should entered other data should not entered.

2 Answers   EDS,

Does every abap/4 have a modular structure?

0 Answers  

What is a view in sap? : abap data dictionary

0 Answers  

What is the differrences between structure and table in data dictionary in abap? : abap hr

0 Answers  

how we will create a bullets in sap-scripts

1 Answers   Satyam,

In real time how we get the tickets? whether it is through email or any thing else.

1 Answers  

What is the advantage of structures?

0 Answers  

What is the diffrence between RFC & normal Function module?

8 Answers   SAP Labs,

What is Deep structure and Flat structure?

4 Answers   Bosch,

IS DOMAIN IS REUSABLE ? IS DOMAIN IS CLIENT DEPENDENT OR CLIENT INDEPENDENT..

1 Answers   HCL,