Application Development 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: 

Maximum tables in a View

Former Member

‎2008 Feb 12 3:10 PM

0 Kudos
633

in view how many maximum table we can use?plzz tell

Edited by: Alvaro Tejada Galindo on Feb 12, 2008 10:51 AM

4 REPLIES 4

Former Member

‎2008 Feb 12 3:29 PM

0 Kudos
177

Hi,

A view is an imaginary table or virtual table. Using one or more tables can create a view. Physically, view does not contain any data. The view is filled dynamically during runtime.

View is mainly used to restrict or limit, access to information or data by employees, area, plant and so on. By using view, you can display information specific to a particular user or to their work or the information for which they have the right to access.

Regards,

Bhaskar

Former Member

‎2008 Feb 12 4:14 PM

0 Kudos
177

A View is nothing But Inner Joins

You can use any no. of tables

then there are many views been made

in sap

so instead of making 1

you should search for a one

thnkx

Former Member

‎2008 Feb 12 5:03 PM

0 Kudos
177

I'm pretty sure i've seen standard SAP views with well over 10 tables.

Rob

Former Member

‎2008 Feb 12 5:59 PM

0 Kudos
177

The maximum number of table sources that can be joined in a single query is 256.

For any reference

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/how-many-joins-1851431