DATA BASE TABLE AND INTERNAL TABLE

[Former Member]

Dear Friends,

please help me out in getting complete information about database table and internal table.

you can email me at < Removed by moderator - please maintain e-mail iDs in Business Card>

Message was edited by:

Arun Varadarajan

[Former Member]

Database Table..are your standard/Customized tables of the system in which data gets stores or resides....where as Internal Table is more of a logical one's meaning they get the run time data where the reference for the data is the database tables...say for a report of a Invoices for particular period..the Database table referred is VBRK..where as the logic is written as [itab VBRK]....meaning the structure is same..just like in arrays & pointers..i hope i cleared your point.

Reward Points if it helps,

Regards,

N

[Former Member]

Hi Hazi Valli,

On simple terms, Database table is table you can view in SAP Screens using TCode SE11 or SE16. This table resides in backend database it can be Oracle, DB/2, Informix or SQL Server.

Internal Table is defined by an ABAP programmer in his code to write a program or a report. It cannot be viewable like database table. It is from coding point of view.

Thanks

Sam

[Former Member]

Hi Hazi,

<b>DATABASE Tables :</b>

This are the tables which are stored in the database (eg Oracle , informix , DB2 etc..) Physically. u can view it from T-codes SE11 or SE16. here in SE11 u can create ur own Transparent table.

for more information...

http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/dictionary_tutorial.html

<b>Internal Tables.</b>

While generating reports or other objects we are not modifying the database tables directly first we are selecting the data of the database table into the internal tables... so that we can reduce the database access time and network traffic .. which is highly needed in R/3 system..

internal tables are not exist phyiscally in the system. its like a array. the existance of the internal tables is upto the program execution in which u r declaring nd using it...

for more information..

http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/internaltables_tutorial.html

Hope it will solve ur problem..

<b>Reward points if useful..</b>

Thanks & Regards

ilesh 24x7