|
Sap Tables Interview Questions and Answers
What is the difference
between internal table and structure?
There are there types of structure:-
1. Flat structure( elementary 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 work area ?
*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) and
Body(Compulsory).
*Any value that comes to or goes from interanal table,
that travels through headerline.
How to eliminate duplicate entries in internal tables?
Answer1:
SORT itab.DELETE ADJACENT DUPLICATES FROM itab COMPARING
ALL FIELDS.
Answer2:
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.
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Job Interview Questions
for more Interview Questions with Answers
|