KEMBAR78
SAP Tables Interview Q&A Guide | PDF | Technology & Engineering
Scribd
Upload
186 views1 page

SAP Tables Interview Q&A Guide

Internal tables are run-time instances that are created when a program starts and destroyed when it ends. They have a header line and body. Database tables are stored on a database server while internal tables are virtual tables created in memory at runtime only. The size of internal tables is set using the OCCURS clause to specify how many rows, and they typically use 8KB of memory by default. Database tables persist after a program ends while internal tables do not since they exist only in memory during the program execution.

Uploaded by

sapep_learner
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
186 views1 page

SAP Tables Interview Q&A Guide

Internal tables are run-time instances that are created when a program starts and destroyed when it ends. They have a header line and body. Database tables are stored on a database server while internal tables are virtual tables created in memory at runtime only. The size of internal tables is set using the OCCURS clause to specify how many rows, and they typically use 8KB of memory by default. Database tables persist after a program ends while internal tables do not since they exist only in memory during the program execution.

Uploaded by

sapep_learner
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

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.

You might also like