why view ?

[Former Member]

1) Does devloper creates " View " if so in what cases he creates ?

2) why do people create zeetables .any real time examples are appreciated .

3) diffrence between transactions SE16 and SE16N.

[Former Member]

hi vijay,

1)A view is a virtual table which gets data from different tables and displays on a single screen actually in real time every time we require data from different tables in such case we create a view and we call that view in the program.

2) Z tables are required when there is no table of a particular field according to my client requirement then we go for ztabls

3) Both are same in new versions se16n which is used for data browser

reward points if helpful,

regards,

srinivas.

[Former Member]

Hi Vijay,

1 .Views are created to combine data from two table .

2 .ZTable are created to meet the customer need bcoz some time standard table are not sufficient .

3 .SE16 is no different than any other transction and as with any SAP functionality there is nothing wrong with giving access to this tcode, selectivly OR widely as long as you control it correctly. SE16 can eliminate the need for the creation of 100's of extranious ABAP reports and is the life blood of HR. With that said the key is "controlling it correctly" Giving S_TABU_DIS and the auth group is not sufficient UNLESS the ADDITIONAL table associated with that auth group are ok for the user. If not SAP provides SUCU or SE54 to change the values without a Repair.

Preferentially SE16 should be given out as opposed to SE16N as SAP does not track the table you access in SE16N but does with SE16, so you can see what the user has accesses in an activity report.

or check this link

http://www.sapfans.com/forums/viewtopic.php?p=471760&sid=87815c3fa9e1adebbcd61548ffd5f892

rgds

Deepak

[Former Member]

hi,

<u>1) Does devloper creates " View " if so in what cases he creates ?</u>

There are 4 types views are avilable in SAP.

Database View - To club more than one table

Projection View - To hide fields in one table

Maintanance View - To maintain database records in table

Help View - To provide help for a fields (Same functionality as Search help. This is outdated)

View are improves perfromance in the following aspects

1. If you want to use more than two table in 'JOIN' condition better to use Views . It will improves performance of a program

2. If you want to use mutiple FOR ALL ENTRIES clause, better to club all SELECT statement in a view.

note:

1.Views does not contain data in it. It fetches data from the database only depending on the condition ...

2.Views are part of data dictionary. They are a window to view the data in database

3.views can be used to give security to data. users can be allowed to view only basic data only

<u>2) why do people create zeetables .any real time examples are appreciated .</u>

The data that is not captured by standard SAP, shuld be stored in Ztables.

eg: VAT datas ( it varies fron country to country). so needed ZTABLES>

<u>3) diffrence between transactions SE16 and SE16N.</u>

Both are same.

Regards

Reshma

Regards

Reshma

[Former Member]

Hi Vijay,

<i><b>1. Views:</b></i>

Views are used to join two or more database table, which don't occupy the physical space in database like standard SAP tables. They just make a framework where different tables are linked with some conditions.

And will fetch data depending on this condition.

The are scenarios when View can be created in system like

1. To view the data from dictionary which belong to different tables depending on conditions

2. To improve performance in the programs specially when the statments like 'For All Entries' etc are used. Instead of such syntax, view can be directly used.

3. Instead of JOIN of tables in programs, views can be directly used in select query.

4. Views can be buffered. So increases the performance of query.

<i><b>2. Z Table:</b></i>

The custom table or Z table is required to create when you have your own custom application and you need to store data as per the business logic. This data can not be placed in standard tables as it may involve all your custom data elements etc. So in such scenarios, z tables are created.

<i><b>3. SE16 & SE16N</b></i>

There is no difference between the two. They are used to fetch data from the dictionary tables. There is selection screen, which can have all the table fields and the data can be fetched.

Hope this sort out your query.

PS If the answer solves your query, plz close the thread by rewarding each reply.

Regards

[Former Member]

Hi,

1. Views:

Views are used to join two or more table, which don't occupy the physical space in database like standard SAP tables.

in order to optimise the performaance of the program we can make a view in se 11 and can use that depending on some condition we can use the view

ZTABLES are created when we dont have database tables in order to meet clients requirement we creat clients specific fields in a table so in this scenerio we creat ZTABLES .

SE16 AND SE16N

Their it nat at all a difference between them only difference is se16 is normal transaction and it is obselete and se16n is enjoy transaction .

HOPE THE ANSWER THE QUESTION.

<b>REWARD IF U FINGD USEFUL</b>

Regards

fareed