topic Re: Regarding ABAP Dictionary in Application Development and Automation Discussions

Regarding ABAP Dictionary

Former Member — Tue, 19 Jun 2007 13:08:05 GMT

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.

Re: Regarding ABAP Dictionary

RichHeilman — Tue, 19 Jun 2007 13:13:37 GMT

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

Re: Regarding ABAP Dictionary

rodrigo_paisante3 — Tue, 19 Jun 2007 13:16:00 GMT

See this material

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

Re: Regarding ABAP Dictionary

Former Member — Tue, 19 Jun 2007 19:48:11 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.

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

Re: Regarding ABAP Dictionary

Former Member — Tue, 19 Jun 2007 20:21:34 GMT

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.

Re: Regarding ABAP Dictionary

Former Member — Wed, 20 Jun 2007 06:03:03 GMT

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