what is the difference between standard and sorted
internal tables? (in performance wise)
Answer / vasu sistla
Standard tables:This is the most appropriate type if you are going to address the individual table entries using the index. Index access is the quickest possible access. You should fill a standard table by appending lines (ABAP APPEND statement), and read, modify and delete entries by specifying the index (INDEX option with the relevant ABAP command). The access time for a standard table increases in a linear relationship with the number of table entries. If you need key access, standard tables are particularly useful if you can fill and process the table in separate steps. For example, you could fill the table by appending entries, and then sort it. If you use the binary search option with key access, the response time is logarithmically proportional to the number of table entries.
Sorted tables:This is the most appropriate type if you need a table which is sorted as you fill it. You fill sorted tables using the INSERT statement. Entries are inserted according to the sort sequence defined through the table key. Any illegal entries are recognized as soon as you try to add them to the table. The response time for key access is logarithmically proportional to the number of table entries, since the system always uses a binary search. Sorted tables are particularly useful for partially sequential processing in a LOOP if you specify the beginning of the table key in the WHERE condition.
Is This Answer Correct ? | 5 Yes | 0 No |
I have one selection screen field which is meant for only display what will You do?
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
Whom do you report when you find difficulty in Tech. designing?
Can we create an abap program without using y or z?
Types of tables in sap
what is the use of FOR ALL ENTRIES in an internal table?
9 Answers Keane India Ltd, PCS, Wipro,
Explain what is the purpose of sap script?
the sap standard SAPSCRIPT for picking a list ?
What is client in the sap system? : sap abap hr
When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?
where can u use secondary index in program please tell me? is there any tool to test in development client?is there any performance tool is thre pleaseeee tell me?
I have two structures s1 and s2 have same struture of five fields each how can u transfer data from s1 to s2