Regarding ABAP Dictionary

[Former Member]

Hi Friends,

plz help me on confusion b/w views , structures,internal tables and they r related to each other. plz send me any material regarding these,and hw they r inter related to each other.

[RichHeilman]

A view is a dictionary object which is used to join or place certain conditions on a table or group of tables. For example, say you want to join VBAK and VBAP by the VBELN field and you only want records that have a "C" in the VBTYP field. You can set the join condition for VBAK and VBAP and then have a selection criteria on the VBTYP. Then you can use this view in SE16 as well as in any SELECT statement in your programs.

Structures are another dictionary object which simply define some data object with one or more fields. You can use these structures in your program to define internal tables or variables in your program.

Internal tables are what they sound like, these are used at runtime in your program to hold tabular data, rows and columns. You declare these in your program like so.

Data: itab type table of mara.

Regards,

Rich Heilman

[rodrigo_paisante3]

See this material

http://www.esnips.com/doc/8637c10f-1f29-4d22-af7b-7fa11e2ccc1e/4-ABAP-Dictionary(P164)

[Former Member]

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.

6. A structure is just a list of fields defined under a name. Structures are useful for painting screen fields, and for manipulating data that has a consistent format defined by a discrete number of fields.

7.There is no content to view in a structure. You can, however, view the definition of a structure in SE11.

hope this ll be helpful

Regards,

vinsee

[Former Member]

Views are data dictionary elements. A view is not stored in a database as tables , its just a method which facilitates the user to see fields from one or more tables.

Views can eb - Help , Database , Projection and Manitenance

A structure in simple terms is a frame , it itself doesnt hold data , however , when we create fields , variables or internal tables , we can have them built based on a structure.

An internal table is built , maintained and destroyed in the program. Once the program / transaction ends, the internal table is destroyed. Internal tables are used to bring necesary data from DB tables , perform manipulations and then display the output.

[Former Member]

Hi Uday,

If u are a beginner in Sap,

U need to have a thorugh knowledge on structure n internal table.

Study the link provided as its a very good one in understanding

INTERNAL tables.

http://www.erpgenie.com/abap/tips/itab/Internal%20Table%2027-02-06.htm#Intro

Do reward points for the same.

Thanks,

Sapna