topic Re: SELECT ... CLIENT SPECIFIED WHERE mandt = sy-mandt in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-client-specified-where-mandt-sy-mandt/m-p/6758565#M1461271 <HTML><HEAD></HEAD><BODY><P>I can't think of any reason to do it that way.</P><P></P><P>Rob</P></BODY></HTML> Mon, 29 Mar 2010 14:39:31 GMT Former Member 2010-03-29T14:39:31Z SELECT ... CLIENT SPECIFIED WHERE mandt = sy-mandt https://community.sap.com/t5/application-development-and-automation-discussions/select-client-specified-where-mandt-sy-mandt/m-p/6758564#M1461270 <HTML><HEAD></HEAD><BODY><P>I'm looking at a legacy program written by someone else, which uses both OpenSQL to connect to the SAP database and native SQL to connect to an external database. </P><P></P><P>In this context, can anyone think of a reason why the CLIENT SPECIFIED addition may have been used in select statements where the client is always explicitly given as sy-mandt? This seems redundant to me, why not stick with the automatic client handling of OpenSQL? Is there anything I might be overlooking?</P><P></P><P>-- Sebastian</P></BODY></HTML> Mon, 29 Mar 2010 14:27:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-client-specified-where-mandt-sy-mandt/m-p/6758564#M1461270 Former Member 2010-03-29T14:27:47Z Re: SELECT ... CLIENT SPECIFIED WHERE mandt = sy-mandt https://community.sap.com/t5/application-development-and-automation-discussions/select-client-specified-where-mandt-sy-mandt/m-p/6758565#M1461271 <HTML><HEAD></HEAD><BODY><P>I can't think of any reason to do it that way.</P><P></P><P>Rob</P></BODY></HTML> Mon, 29 Mar 2010 14:39:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-client-specified-where-mandt-sy-mandt/m-p/6758565#M1461271 Former Member 2010-03-29T14:39:31Z