Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Reading data from another database

Former Member
0 Kudos

Hi Folks!

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?

Thanks in advance for your help.

Regards,

Gilberto Li

1 REPLY 1

Former Member
0 Kudos

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.

Alternatively, you can use the RFC route but you need to setup RFC connection between the two systems.

You can also bring this validation table into SAP as a one time or periodically updated table and then do the validations within SAP.