Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the difference between internal table and Database table ?

user-image
Question ajoutée par Peter Fouad Riad , Senior Software Developer , Compugeorge
Date de publication: 2016/06/07
Faheem Md
par 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
par 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
par TAZAN GOSAIN , SAP ABAP Consultant , Kalishma Steel

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
par Ismail Zabeeh K , Operations Manager , Al Khail Al Arabi Ind Equipmen

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
par Denis Rubin , Security Manager , S.T.A.R.S. security

Discipline,knowledge,skills  

 

 

Amithkumar kamkar
par 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