topic Re: difference between intenal table and view in Application Development and Automation Discussions

difference between intenal table and view

Former Member — Thu, 18 Jan 2007 10:17:55 GMT

Hi friends

Can anyone tell what is the difference between internal table and views?

Thanks

RamaDevi

Re: difference between intenal table and view

Former Member — Thu, 18 Jan 2007 10:21:01 GMT

1. Internal tables are locally defined in a program. Views are globally defined in the dictionary.

2. Internal tables do not hold data unless selected into by a select statement. Views hold data automatically at run time from the corresponding base tables.

3. Reading from an internal table is faster than from a view.

4. Views can only be created from one or more database tables. Internal tables can be created from tables or structures.

5. Internal tables need not be in the customer namespace. Views have to be in the customer (Y,Z) namespace.

Re: difference between intenal table and view

Former Member — Thu, 18 Jan 2007 10:21:40 GMT

hi,

an internal table is bascially a dynamic table that is visible only within the particular program , whereas a view ia a dictionary object that can be created in se11, and once created can be used any where.

hope this helps

pls reward if helpful.

Re: difference between intenal table and view

Former Member — Thu, 18 Jan 2007 10:23:36 GMT

Internal tables provide a means of taking data from a fixed structure and storing it in working memory in ABAP. The data is stored line by line in memory, and each line has the same structure. In ABAP, internal tables fulfill the function of arrays. Since they are dynamic data objects, they save the programmer the task of dynamic memory management in his or her programs. You should use internal tables whenever you want to process a dataset with a fixed structure within a program. A particularly important use for internal tables is for storing and

formatting data from a database table within a program. They are also a good way of including very complicated data structures in an ABAP program.

VIEW: a method of viewing database tables. Can combine data from multiple tables into one view, and/or can restrict the view to certain records or fields within a table. Views are sometimes not considered true table types.

Views are meant for viewing data in different ways, it could be partial tables, it could be a combination of multiple tables.

Views are just a window to the transparant tables. Views are combination of one or more tables joined togather.

PLZ REWARD POINTS IF HELPFUL

Re: difference between intenal table and view

former_member404244 — Thu, 18 Jan 2007 10:25:11 GMT

hI RAMA,

1> Internal tables hold data when u write a select query on the database tables.Once u execute ur program, the internal tables will be refreshed.

Views hold data automatically at run time. It is a data dictionary object.it will be created only when u have database tables.

Plz reward all helpful answers.

Regards,

nagaraj

Re: difference between intenal table and view

Former Member — Thu, 18 Jan 2007 10:28:21 GMT

hi,

Internal tables are created in the program and data is dynamically filled into it.

its scope is limited to prgram.

View is a dictionary object.it is nothing but a projection of a table or combination of one or more tables.