topic Re: VIEWS in Application Development and Automation Discussions

VIEWS

Former Member — Mon, 24 Apr 2006 08:44:23 GMT

Hi,

I want to know whether a VIEW exists in db also or does it exist only in DATA DIC?I mean whether VIEW contains data in db or it only fetches data present in transparent tables?

thanks,

Rakesh..

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:46:54 GMT

Hi,

The views are maintained in dictionary however

the view doesnt contain data but fetches it from the transparent tables depending upon the joining condition.

Instead of writing a repeatative complex SELECT query which does a join for you, its better to use a view.

Regards,

Tanveer.

Please mark helpful answers

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:47:03 GMT

Yes.

VIEW contains no data. It only fetches data present in transparent tables.

See this.

Mark Helpful answer

Regards,

Amit Mishra

Message was edited by: Amit Mishra

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:47:20 GMT

Hi,

Views does not contain data in it.

It fetches data from the database only depending on the condition speccified in the view.

See http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

Regards,

Wenceslaus.

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:48:03 GMT

Tables are meant storing data.

Views are meant for viewing data in different ways, it could be partial tables, it could be a combination of multiple tables.

Data is never stored in views.

Views dont store the data, whereas tables store the data.

Views can be used to view data from one or more tables.

A view can be compared with a join.

To find out the tables in CIN, use SQL trace (ST05).

VIEW: a method of viewing database tables. Can combine data from multiple tables into one view, and/or can restrict the view to certain records or fields within a table. Views are sometimes not considered true table types.

TRANSPARENT TABLE: An SAP data dictionary table which is mapped 1:1 to the database. Designed to hold SAP data in a database

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:48:49 GMT

Hello,

Views are part of data dictionary. They are a window to view the data in database. So they don't contain in data but fetches data in the way view is defined during runtime.

Re: VIEWS

Former Member — Mon, 24 Apr 2006 08:51:03 GMT

Hi love,

1. whether a VIEW exists in db also or does it exist only in DATA DIC

Projection View, Database Views

exist in database as well as DATA DICTIONARY.

(maintenance view exist only in dictionary,

bcos they are just special screens

to facilitate data entry in tables)

VIEW contains data in db or it only fetches data present in transparent tables?

View only FETCHES data

(It does not contain any data)

regards,

amit m.

Re: VIEWS

Former Member — Mon, 24 Apr 2006 09:00:49 GMT

Amit,

Then wats the use of having view only in DDIC not in db?

i mean why only maintainance view doesnt exist in db wheresas other views exist?