Difference b/w Structure and Views

[Former Member]

Hi,

Difference b/w Structure and Views?

I need brief explanation.

[Former Member]

Hi,

Difference b/w Structure and Views?

I need brief explanation.

[Former Member]

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.

[Former Member]

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.

[varma_narayana]

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>