Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

what is the difference between view and structure

Former Member

‎2008 Mar 16 5:53 PM

0 Likes
904

what is the difference between view and structure

what is the difference between view and structure

Reply
3 REPLIES 3
Read only

Former Member

‎2008 Mar 16 7:11 PM

0 Likes
836

Hi,

View is a combination of tables and structure is a data type.

View will have Entries in database level and structure is only a template.

Select Queries can be performed on views where as not on Structure.

Regards

Pavan

Read only

Former Member

‎2008 Mar 17 5:19 AM

0 Likes
836

Hi Mohammad,

A view is a "virtual table" containing data, which are really stored in one or more other tables. The contents of the View are dynamically generated when called from a program.

Structure refers to the Definition of an Object, mostly Table or a View, and doesn’t have any contents. Structure doesn’t exist at the underlying database system level. It exists as a definition in the dictionary. Structure does not has any content in it, it's only populated during the runtime, that's why you could not see the content in SE16 nor SE11/SE12.

If you want to see any records for any transactions (which used structures

instead of transparent tables), you could try SE11 or SE12 and click on the

'Entry help/check' to find the corresponding fields name to the existing

database tables.

However, not all of the fields has the check table entry.

Hope this help you.

Regards,

Viveks