Monday, September 9, 2013

What Are Views?


A view is a database object that represents the data in one or more tables in the same structure as a separate table. Here are some basic rules about views:
  • Tables store real data.
  • Views do not store real data.
  • Views must have underlying tables to provide data.
  • Each view is based on a single SELECT statement to control what data to collect from tables, and how data should be represented.
  • View's columns can be mapped directly to columns in underlying tables.
  • View's columns can be created expressions based multiple columns in underlying tables.
  • Views can be used in same way as tables in queries.

No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

Blog Archive

goodsites