topic Re: Reading data from another database in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/reading-data-from-another-database/m-p/2504096#M565990 <HTML><HEAD></HEAD><BODY><P>There are a couple of ways to do this. One, you can create an executable on the other non-sap system that you can call from SAP as a system command. So let us say you write a unix script that takes a value as input and returns a flag as output. Within the script you will check that value against this non-sap database. In SAP, you will create a system command in SM69 and then execute it in your program via function module SXPG_COMMAND_EXECUTE.</P><P></P><P>Alternatively, you can use the RFC route but you need to setup RFC connection between the two systems.</P><P></P><P>You can also bring this validation table into SAP as a one time or periodically updated table and then do the validations within SAP.</P></BODY></HTML> Tue, 10 Jul 2007 20:10:40 GMT Former Member 2007-07-10T20:10:40Z Reading data from another database https://community.sap.com/t5/application-development-and-automation-discussions/reading-data-from-another-database/m-p/2504095#M565989 <HTML><HEAD></HEAD><BODY><P>Hi Folks!</P><P></P><P>I need to read some data from another non-sap system database to validate something in R/3. Does this is possible. If it is possible how could this be achieved?</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Regards,</P><P>Gilberto Li</P></BODY></HTML> Tue, 10 Jul 2007 19:46:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reading-data-from-another-database/m-p/2504095#M565989 Former Member 2007-07-10T19:46:43Z Re: Reading data from another database https://community.sap.com/t5/application-development-and-automation-discussions/reading-data-from-another-database/m-p/2504096#M565990 <HTML><HEAD></HEAD><BODY><P>There are a couple of ways to do this. One, you can create an executable on the other non-sap system that you can call from SAP as a system command. So let us say you write a unix script that takes a value as input and returns a flag as output. Within the script you will check that value against this non-sap database. In SAP, you will create a system command in SM69 and then execute it in your program via function module SXPG_COMMAND_EXECUTE.</P><P></P><P>Alternatively, you can use the RFC route but you need to setup RFC connection between the two systems.</P><P></P><P>You can also bring this validation table into SAP as a one time or periodically updated table and then do the validations within SAP.</P></BODY></HTML> Tue, 10 Jul 2007 20:10:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/reading-data-from-another-database/m-p/2504096#M565990 Former Member 2007-07-10T20:10:40Z