What is the difference between internel table and structure?
There are theree types of structure:-
1. Flat structure( elementry fields)
2. Nested structure ( type reference to other structure)
3. deep structure ( type reference to database tables)
Explain row type and line type concept
line type refers to the structure of an internal table,whereas row type is the actual
part that contains the data and it refers to the table body.creating internal table
using line type and row type concept is for reusability purpose.Line type and Row
type are defined at DDIC LEVEL.
Can any one give me brief explanation about internal tables, and workarea ?
*An internal table is a run time instance. It get created when program starts execution.
*It get destroyed when program terminates. It has two different parts: HeaderLine(optional)
*Any value that comes to or goes from interanal table, that travels through headerline.
How to eliminate duplicate entries in internal tables?
SORT itab.DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.
The following syntax:
SORT itab <fieldname>.
delete adjcent duplicates from itab comparing .
Size of the internal tables?
The size of the internal tables are set using the 'occurs n' clause. Here n refers
to a integer number that specifies the size. Usually its given as 'occurs 0' which
creates an itab with the memmory space of 8kb.
What is the basic difference internal tables and database tables? How can we
differentiate by looking at the tables?
Handling of internal tables
The basic difference is database tables are stored in DB server
and the internal tables are virtual tables these are created run time only
Internal tables are created dynamically, the memory of internal tables is not
permant memory, for internal tables the memory will be created in the application
server and it is external memory and terminates after the program termination.