topic Re: views in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/views/m-p/2671376#M616789 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>Views are used to Access the data from one or more tables. They do not store the data in DB.</P><P></P><P>Types of views:</P><P></P><P>Database view: Uses inner join. We can use this to access several tables from program.</P><P></P><P>Projection View: To access few fields from a table</P><P></P><P>Maintenance view: To update multiple Tables at a time using SM30.</P><P> So after creating Maintenance view we must generate </P><P> Table maintenance in SE54. </P><P></P><P>Help view: Uses Outer Join. It is only used to Create Search helps.</P><P></P><P>&lt;b&gt;Reward if Helpful&lt;/b&gt;</P></BODY></HTML> Wed, 22 Aug 2007 06:41:21 GMT varma_narayana 2007-08-22T06:41:21Z views https://community.sap.com/t5/application-development-and-automation-discussions/views/m-p/2671375#M616788 <HTML><HEAD></HEAD><BODY><P>hi friends </P><P></P><P> help me</P><P></P><P> why is view?</P><P> why we need view?</P><P> what the each type of view does?</P><P> What is the purpose of maintenance and help view</P></BODY></HTML> Wed, 22 Aug 2007 05:50:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/views/m-p/2671375#M616788 vijy_mukunthan 2007-08-22T05:50:00Z Re: views https://community.sap.com/t5/application-development-and-automation-discussions/views/m-p/2671376#M616789 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>Views are used to Access the data from one or more tables. They do not store the data in DB.</P><P></P><P>Types of views:</P><P></P><P>Database view: Uses inner join. We can use this to access several tables from program.</P><P></P><P>Projection View: To access few fields from a table</P><P></P><P>Maintenance view: To update multiple Tables at a time using SM30.</P><P> So after creating Maintenance view we must generate </P><P> Table maintenance in SE54. </P><P></P><P>Help view: Uses Outer Join. It is only used to Create Search helps.</P><P></P><P>&lt;b&gt;Reward if Helpful&lt;/b&gt;</P></BODY></HTML> Wed, 22 Aug 2007 06:41:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/views/m-p/2671376#M616789 varma_narayana 2007-08-22T06:41:21Z