topic Re: Creating view problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068185#M93982 <HTML><HEAD></HEAD><BODY><P>Could be please mention your select statement??</P></BODY></HTML> Fri, 21 Oct 2005 07:54:33 GMT Former Member 2005-10-21T07:54:33Z Creating view problem https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068183#M93980 <HTML><HEAD></HEAD><BODY><P>I want to create a view in se11. I joined 3 tables into this view, all the 3 tables are active. When I want to active the view, there is an error message 'Table contains more than 3 long string fields'. Is there anyone can help me? Thank you.</P></BODY></HTML> Fri, 21 Oct 2005 06:49:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068183#M93980 Former Member 2005-10-21T06:49:38Z Re: Creating view problem https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068184#M93981 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P></P><P>Looks like you are running into a database restriction (of open SQL - maybe some database can handle this).</P><P></P><P>If you don't need all (of the string) fields, remove them out of the view.</P><P>Otherwise, forget it, use a join in your programs.</P><P></P><P>Regards,</P><P>Christian</P></BODY></HTML> Fri, 21 Oct 2005 06:56:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068184#M93981 christian_wohlfahrt 2005-10-21T06:56:24Z Re: Creating view problem https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068185#M93982 <HTML><HEAD></HEAD><BODY><P>Could be please mention your select statement??</P></BODY></HTML> Fri, 21 Oct 2005 07:54:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/creating-view-problem/m-p/1068185#M93982 Former Member 2005-10-21T07:54:33Z