dictionary

[Former Member]

wat is views? y ru used views?

y u r used technical settings while creatng table?

y ur activate the table?

[Former Member]

Hi,

Table is created in the underlying database only when you activate the table.

Thanks,

Srinivasa

[amit_khare]

Check the following -

Regards,

Amit

Reward all helpful replies.

[Former Member]

Hi ,

The followings are different types of views:

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

- Help View ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- Projection View

Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.

A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

- Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

Technical Settings are used to maintain the settings for the Table which is created, i.e. the size of the table, type of table, wheteher buffering to be allowed or not, etc...

When we activate the table then it is meant for use by all the SAP users available in your server.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

Hi Sheik,

Projection views are used to hide fields of a table (only

projection).

Help views can be used as selection method in search helps.

Maintenance views permit you to maintain the data

distributed

on several tables for one application object at one time.

Data about an application object is often distributed on

several database tables. A database view provides an

application-specific view on such distributed data.

Database views are defined in the ABAP Dictionary. A

database view is automatically created in the underlying

database when it is activated.

YEs we can uae the views in real time.

Technical Setting:

The selection conditions define the data records that can be

selected with the view.

With Goto - Technical settings , you can (optionally)

maintain the technical settings of the database view.

You can define whether and how the database view should be

buffered here. Proceed as for the technical settings of a table

Table is created in the underlying database only when you activate the table.

********rewards points

Rgds,

P.Naganjana Reddy

[Former Member]

Hai sheik rahimul,

<b>About View:</b>

If you have written a select query accessing data from different tables having large amount of data,Each time it executed,it takes much time to do joins and condition checks.

Thats why View concept came here.The does not executes the select query each time it i accessed.You can access it as a normal Database table.That is simply select the data from the view,but need not have complex queries.

<b>About Technical Settings:</b>

The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.

You can more details at:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eac5446011d189700000e8322d00/frameset.htm

<b>About Tables activation:</b>

Once the table is activated means it is ready to have consistant and deliverible data:

You can more details at:

http://help.sap.com/saphelp_nw04/helpdata/en/8a/8d9f3cad1e3251e10000000a114084/frameset.htm

<b>Reward points if it helps you.</b>

Regds,

Rama.Pammi

[Former Member]

<u>About Tables activation:</u>

Once the table is activated means it is ready to have consistant and deliverible data:

<u>About Technical Settings:</u>

The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.

[Former Member]

hai sheik rahimul,

<b>Views</b>

1)Projection views --- used to hide fields of a table (only projection).

2)Help views --- used as selection method in search helps.

3)Maintenance views ---to maintain the data distributed on several tables for one application object at one time.

4)Database views ---snapshot of a Database table.

<b>Technical Setting</b>

Goto - Technical settings , you can (optionally)maintain the technical settings of the database table. Provide Data Class & Size for the created table. You can define whether and how the database view should be buffered here.

<b>Table Activation</b>

Table is created in the underlying database only when table is activated.

reward points if useful.

regards,

kavitha.

[Former Member]

Types of views :

Database view: Equivalent to database table ,snapshot of DB table, and create ,modify all are done here.

Projection View : To display only some specified columns from various tables.It is used to hide fields of table.

Help views: similar to search help.

Maintainence View: Maintain datas for one or more tables.

Technical settings: Here we define the size and category for the table .

Activating table is very important ,b'coz after activating only the table is created in the database . U can even try and see without activating the table u can't make entries to the table .

In SAP activating is must in all the places when ever u create or modify ,after activating only the changes will be reflected .

Hope i have answered ur questions.

[Former Member]

Using views we can get the fields from more than one table and we can use it where we need to refer that data's

There are some different kinds of views.

Database views-->Here we can combine more than one table

Projection views-->here we can use only one table

Search help views-->Same as search help concept.

At that time when we are activating the table it will automatically creates a table with the same structure and same name and with one to one cardinality and that is said to be TRANSPARENT TABLE.

Try to reward with poiints how much this useful yar

[Former Member]

Views is nothing but making a rfelationship with other tables..

There are four kind of views..Generally we use Database view..

With the help of technical settings only we can define the table either as a master table or a transaction table..Not only defining the type of a table it is also used for defining the number of records..If u give 0 it takes upto 13,000 records...

After activating the table only u can make entries into the table..

If u r satisfied don't forgot to reward..

[Former Member]

Hi Sheik

Views is mainly used for dispalying the tables.we use technical settings to create tables because to make that table confronted to that settings.

you activate the table because to save all the changes you made and execute accordingly..

reward if found useful...!!