Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between internal table and Database table ?

user-image
Question added by Peter Fouad Riad , Senior Software Developer , Compugeorge
Date Posted: 2016/06/07
Faheem Md
by Faheem Md , Senior Consultant , Computer Sciences Corporation

Intenral table is a local table which will be available at runtime only where as database table will hold the data and it is stored permanently.

Faran Bhaiji
by Faran Bhaiji , Principal Consultant , Medline India

Internal tables are used for temperoray storage of data during Runtime . 

Data base tables save data permanently . 

DATABASE TABLE: It is a physically existing permanent container in database, which maintains data in terms of rowa and column.

INTERNAL TABLE: It provides a means of taking data from database table and storing it in working memory in ABAP.

TAZAN GOSAIN
by TAZAN GOSAIN , Technical Co-Executive , UTTARA

Database table is permanent while internal table is temporary.

database table have master and transaction data while internal table does not have any master and transaction data.

database table have it's own memory.

Ismail Zabeeh K
by Ismail Zabeeh K , Operations Analyst , Unibeton Ready Mix

Database tables are at the database level, and has permanent memory. But whereas Internal tables are created dynamically and executed only during runtime. Internal tables doesnt have permanent memory and gets terminated with the termination of program.

Denis Rubin
by Denis Rubin , Security Manager , S.T.A.R.S. security

Discipline,knowledge,skills  

 

 

Amithkumar kamkar
by Amithkumar kamkar , Grade B Associate ABAP Consultant , PEOL Technologies Pvt Ltd

Both Internal Table and Database table hold data. 

-> Internal Table data is available in ABAP Memory, Database data is stored in SAP Memory

->Data in internal table is available for use only in time of execution , Database tables hold permanent Data.

-> Database queries can me used on both Internal table and Database table

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.