topic Difference b/w Structure and Views in Application Development and Automation Discussions

Difference b/w Structure and Views

Former Member — Tue, 21 Aug 2007 03:57:55 GMT

Hi,

Difference b/w Structure and Views?

I need brief explanation.

Re: Difference b/w Structure and Views

Former Member — Tue, 21 Aug 2007 04:00:19 GMT

Hi,

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

structure is some thing which contains definitions of fields and is agroup of fields.structures are available only at data dictionary.

views are dynamically created at run time which contains data from different tables based on conditions.views are used for users as well as for system.

views are of different types

1. help views

2. projection views

3.selection views

Regards,

Priyanka.

Re: Difference b/w Structure and Views

Former Member — Tue, 21 Aug 2007 04:07:41 GMT

Hi Udaya,

Views - these are combination of two or more tables. Also there are different types of views like database views, projection views, Help views and Maintanance views etc..

To know more abt views, kindly go through the link given below:

http://help.sap.com/saphelp_470/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm

Structures - These contains fields that can be used in program as a reference for creation of internal table types/ structure types in run time. Structure at runtime can hold only one row.

To know more abt structures, link given below is helpful

http://help.sap.com/saphelp_470/helpdata/en/ac/3547360f2ea61fe10000009b38f839/frameset.htm

<i>Reward if helpful.</i>

Best Regards,

Ran.

Re: Difference b/w Structure and Views

varma_narayana — Tue, 21 Aug 2007 04:18:07 GMT

Hi..

Structures are only Global Data types. They do not have any physical storage in DB like a Table.

We can use Structures to Declare the Variables like internal tables etc. But the Select Statement must be on a TABLE OR VIEW.

View is like virtual Table. It will not store any data. It will access the data from the underlying tables.

So we can Write a SELECT statement on a VIEW.

<b>Reward if Helpful</b>