topic Re: Move a database view in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439189#M1247548 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>U can create a change request in the original system containing the database view and the import this request to the target system:</P><P>but u need to have administration system authorizations to do that: because u need to pick up the cofile and datafile from SAP server.</P><P></P><P>If you can't do it, u can only recreate the view again.</P><P></P><P>Max</P></BODY></HTML> Thu, 09 Apr 2009 14:24:37 GMT Former Member 2009-04-09T14:24:37Z Move a database view https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439187#M1247546 <HTML><HEAD></HEAD><BODY><P>I need to move a database View from one system to another. Can I move the view without having to recreate the view on the other system? And, is there a system view for the material and customer tables?</P><P></P><P>Thank you</P></BODY></HTML> Thu, 09 Apr 2009 14:16:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439187#M1247546 Former Member 2009-04-09T14:16:47Z Re: Move a database view https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439188#M1247547 <HTML><HEAD></HEAD><BODY><P>Transport the view thru work bench Request.</P><P></P><P></P><P>Rhea.</P></BODY></HTML> Thu, 09 Apr 2009 14:23:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439188#M1247547 Former Member 2009-04-09T14:23:31Z Re: Move a database view https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439189#M1247548 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>U can create a change request in the original system containing the database view and the import this request to the target system:</P><P>but u need to have administration system authorizations to do that: because u need to pick up the cofile and datafile from SAP server.</P><P></P><P>If you can't do it, u can only recreate the view again.</P><P></P><P>Max</P></BODY></HTML> Thu, 09 Apr 2009 14:24:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439189#M1247548 Former Member 2009-04-09T14:24:37Z Re: Move a database view https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439190#M1247549 <HTML><HEAD></HEAD><BODY><P>Views can be transport as workbench request...</P></BODY></HTML> Thu, 09 Apr 2009 15:01:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/move-a-database-view/m-p/5439190#M1247549 Former Member 2009-04-09T15:01:19Z