What is use of using HASHED TABLE?
Hashed table is useful when your have to work with very big internal table and to read it with
"READ TABLE WITH KEY ..."
The time access is constant !
Definition of a Hashed Table:
"Defines the table as one that is managed with an internal hash procedure. You can imagine a hashed table as a set, whose elements you can address using their unique key. Unlike standard and sorted tables, you cannot access hash tables using an index. All entries in the table must have a unique key.
Access time using the key is constant, regardless of the number of table entries.
You can only access a hashed table using the generic key operations or other generic operations (SORT, LOOP, and so on). Explicit or implicit index operations (such as LOOP ... FROM to INSERT itab within a LOOP) are not allowed."
As long as your records has unique key(s), using hash table will give you a huge performance gain when dealing with large dataset. assuming in your case, 10000 record , and if the key is unique, use hash table. The main use of hash tables is for looking up fixed information from a key. So if you have a report that has personnel number and you want to display their name, you could use a hash table.
Thus:
Code:
types: begin of typ_pernr,
pernr like pa0001-pernr,
ename like pa0001-ename,
end of typ_pernr.
data: ls_pernr type typ_pernr,
lt_pernr type hashed table of typ_pernr with unique key pernr.
...
select pernr ename into table lt_pernr from pa0001.
...
loop at itab.
read table lt_pernr with table key pernr = itab-pernr
into ls_pernr.
write: ls_pernr-ename, itab-data.
endloop.
Friday, April 18, 2008
What is use of using HASHED TABLE? SAP ABAP INTERVIEW Questions
Posted by Anonymous at 6:31 AM
Labels: ABAP Interview Questions
Subscribe to:
Post Comments (Atom)
Content
-
►
2009
(2)
- ► 09/06 - 09/13 (1)
- ► 03/01 - 03/08 (1)
-
▼
2008
(207)
- ► 11/23 - 11/30 (1)
- ► 04/20 - 04/27 (70)
-
▼
04/13 - 04/20
(51)
- Difference Between Select-Options & Ranges SAP ABA...
- Inner Join to retrieve the Material Valuation Clas...
- How to used 3 tables for inner joins? SAP ABAP INT...
- Protect Selection/Parameters SAP ABAP INTERVIEW Qu...
- Difference Between Select Single and Select UpTo O...
- Select statement with inner join is taking forever...
- How can we give dynamic table name in select state...
- Performance tuning for Data Selection Statement SA...
- What's the purpose of using PACKAGE SIZE in select...
- Usage of 'for all entries' in Select Statement SAP...
- ABAP Self Test Q & A SAP ABAP INTERVIEW Questions
- What is the difference between SMOD and CMOD? SAP ...
- Split String into two parts at delimiter SAP ABAP ...
- String Handling in ABAP - Removing Unwanted Char S...
- System Fields for Details Lists SAP ABAP INTERVIEW...
- System Landscape: SAP ABAP INTERVIEW Questions
- System Landscape1 SAP ABAP INTERVIEW Questions
- Table Maintenance Generator SAP ABAP INTERVIEW Que...
- TABStrips in ABAP SAP ABAP INTERVIEW Questions
- ABAP Tips and Tricks SAP ABAP INTERVIEW Questions
- Tree type report in ABAP SAP ABAP INTERVIEW Questions
- Explain Unicode-enabled ABAP program SAP ABAP INTE...
- Source Code Listing SAP ABAP INTERVIEW Questions
- What is User Exits and Customer Exits? SAP ABAP IN...
- A Short Tutorial on User Exits SAP ABAP INTERVIEW ...
- Program to Test Line Selection & Scrolling within ...
- Creating new program via ABAP SAP ABAP INTERVIEW Q...
- Program to Hide ABAP's Source Code and Protects it...
- Protect part of ABAP code from modifying SAP ABAP ...
- How to delete an editor lock? SAP ABAP INTERVIEW Q...
- Check Length and Alpha Numeric Variable SAP ABAP I...
- Run or Display ABAP Report over the web SAP ABAP I...
- Working on Polymorphism SAP ABAP INTERVIEW Questions
- How to Write Web Reports in SAP SAP ABAP INTERVIEW...
- Steps to Creating domains, Data Elements, Tables S...
- Function to Display All the Columns of any Table W...
- Difference between Work Area and Header Line SAP A...
- The Different Types of SAP Tables
- Difference between a check table and a value table...
- Quick Note on Design of secondary database indexes...
- How to get the field descriptions of a table? SAP ...
- What is use of using HASHED TABLE?
- How to create a Dynamic Internal Table or Array? S...
- Which table is the developer key stored in? SAP AB...
- What is use of using HASHED TABLE? SAP ABAP INTERV...
- Trace when a variant of a report was created SAP A...
- Difference between extract and collect statements ...
- What Are Different Types Of Internal Tables and Th...
- What is the Different Types and Usage of Views SAP...
- How Loop Works in Internal Tables
- Easy Way To Remember Table In SAP
- ► 03/16 - 03/23 (44)
- ► 02/24 - 03/02 (9)
- ► 02/17 - 02/24 (32)
No comments:
Post a Comment