business plans for scenario

Hello All,

I have a scenario where I have two different software systems (SAP and xyz systems), where a intermediate table will be created in between the two systems that is shared. Data will be updated by the xyz systems into this shared table. Now, my questions regarding this shared table.

1) Can we write some program or something to get the data from shared table to update the SAP?

2) If possible send me the suggestions

3) Please also send me the sample code to get the data from the shared table

Thanks in advance,

SDN powered