topic Re: Maximum tables in a View in Application Development and Automation Discussions

Maximum tables in a View

Former Member — Tue, 12 Feb 2008 15:10:41 GMT

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

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

Re: Maximum tables in a View

Former Member — Tue, 12 Feb 2008 15:29:47 GMT

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

Re: Maximum tables in a View

Former Member — Tue, 12 Feb 2008 16:14:14 GMT

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

Re: Maximum tables in a View

Former Member — Tue, 12 Feb 2008 17:03:36 GMT

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

Rob

Re: Maximum tables in a View

Former Member — Tue, 12 Feb 2008 17:59:52 GMT

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