* It is temporary memory location , which is used to store the data of database.
DATA<ITABNAME> TYPE TABLE OF <DB TABLE NAME>
DATA<ITABNAME> TYPE TABLE OF <USER-DEFINED TABLE>
DATA<ITABNAME> TYPE TABLE OF <DB.TABLE> OCCURS 0 WITH HEADER LINE.
|
DATA <WA_NAME> TYPE <DB.TABLE>
DATA <WA_NAME> TYPE <USER-DEFINED TYPE>
|
SELECT * (or) F1 F2 F3 - - - -
From <DB.Table>
Into <ITab/ WA>
Where F1 = <Value>
And F2 = <Value>
.
.
|
LOOP AT <ITAB> INTO <WA>
---
---
---
ENDLOOP.
|
Types : Begin Of <TypeName>,
F1 (Length) Type <DataType>,
F2 Type <TableName-Fname>,
F3 Type <TableName--Fname>,
. .
. .
Endof <TypeName>.
|
Select F1
F2
F3
.
.
From <DB.Table>
Into corresponding fields of table <ITAB>.
|
APPEND <WA> TO <ITAB>.
|
INSERT <WA> INTO <ITAB> INDEX <INDEX NO>
|
SORT <ITAB> BY F1 F2 F3 ............. <ASCENDING/DESCENDING>.
|
DESCRIBE TABLE <ITAB1> LINES <VARIABLE>.
|
READ TABLE <ITAB> INTO <WA> INDEX <INDEX NO>.
|
READ TABLE <ITAB> INTO <WA> WITH KEY F1 name = <FVal>
F2name = <FVal>
F3name = <FVal>
. .
. .
Binary search.
|
MODIFY<ITAB> FROM <WA> INDEX <INDEX NO> TRANSPORTING F1 , F2 , F3 ........
|
MODIFY<ITAB> FROM <WA> TRANSPORTING F1 , F2 , F3..........
WHERE F1 = VALUE
AND F2 = VALUE
.
.
|
DELETE <ITAB> INDEX <INDEX NO>.
|
DELETE <ITAB> WHERE F1 = FVal
AND F2 = Fval
AND F3 = Fval
. .
. .
|
DELETE ADJACENT DUPLICATES FROM <ITAB>
COMPARING F1 F2 F3 ALL FIELDS.
|
CLEAR <WA>.
|
REFRESH <ITAB>.
|
FREE <WA/ITAB>.
|
APPENDLINES OF <ITAB1> FROM <INDEX NO1>
TO <INDEX NO2>
INTO <ITAB2>.
|
INSERTLINES OF <ITAB1> FROM <INDEX NO1>
TO <INDEX NO2>
INTO <ITAB2> INDEX <INDEX NO>.
|
ITAB1[ ] = ITAB2[ ].
|
Transparent
|
Pool
|
Cluster
|
Contain a single table. Used to store master data
|
They are used to hold a large number of very small tables(stores system data)
|
They are used to hold data from a few number of large tables.(stores system data)
|
It has a one-to-one relationship with a table in the database
|
It has a many-to-one relationship with a table in the database
|
It has a many-to-one relationship with table in the database
|
For each transparent table there is one associated table in the database
|
It is stored with other pooled tables in a single table called table pool in the database
|
Many cluster tables are stored in a single table in the database called a table cluster
|
The database table has the same name, same number of fields and the fields have the same names
|
The database table has different name, different number of fields and fields have different names
|
The database table has different name, different number of fields and fields have different names
|
There is only a single table
|
Table pools contain more tables than table clusters
|
Contains less tables than table pools
|
Secondary indexes can be created
|
Secondary indexes cannot be created
|
Secondary indexes cannot be created
|
STANDARD
|
SORTED
|
HASHED
|
These are the default internal tables which are created by us.
We use either key operation (or) index operation to read a record.
We use either linear search (or) Binary search for reading record.
If use Binary Search, the response time will be
Resp.Time = Log(N).
We can append , insert the records whenever we want.
We can sort the data based on our own conditions.
|
These are special ITAB's where the data is automatically sorted when ever a new record is added.
We use either key(or) index operation to read a record.
We use only Binary search for reading a record, bcoz the data is automatically sorted.
The Response Time will be same.
The main disadvantage is , we can not sort ITABS based on our conditions, bcoz the data is already sorted.
|
These are also special type of ITAB which should be used when working with large data sets(Bulk amount of data).
Here, we use only Keyoperation, but not the index operation.
It uses Hashed algorithm for reading a record.
The Resp.Time is always fixed regardless of the total no of records.
In Real-Time , we hashed ITAB's only whenever we work with server to server communication like transferring the data from ABAP to BI server.
|
2 comments
Click here for commentsHi....I am beginner to SAP HANA...Do we have any reference where i can create a table in SAP HANA DB and access thru JSP ?
Replyhi
ReplyConversionConversion EmoticonEmoticon