What secondary index and use of it and how many secondary index we can create?

Answer Posted / roy

Secondary index can be create based on the primary key or non primary key or only with non-primary key of a table.

Use of secondary key to fetch the data faster from the database.

We can create maximum 9 secondary index.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between tables and structures?

848


How are BAPI different from normal function modules?

1904


Explain client-dependent and client-independent tables.

819


If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)

2277


What will you code in start-of-selection & end-of-selecton & why?

788


Create any functions? How to go about it?

746


What is logo in sap script?

817


What application areas are you comfortable in?

1075


visibility section for class level and attributes level

1043


What is the difference between synchronous and asynchronous update?

829


What are logical data bases used in hr module? : abap hr

866


What is synchronous update?

731


What are the components of sap scripts? : abap hr

771


What is projection view?

713


Hat are the different types of mode (run code) in call transaction method?

775