Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Select data in development system from production system

Go to solution
former_member227595
Active Participant

‎2011 Jan 10 11:21 AM

0 Likes
1,883

Hi,

Does anybody know if there is a way to select data (table: UST12) in development system from production system trhough a RFC.

I need to create a program in development system filtering all the users that they have authorization to a particular transaction for a certain society.

I mean, first i need to acces to PA0001 then I get the user name in PA0105. Then go to UST04 (to get the profiles), and with the profiles I select the transaction in table UST12 (and then i need the profiles that have the transaction MR21).

My problem is that I cannot do such a program in production system to select this data. I have acces to developmen system so i want to select the production data trhough an RFC. Do you know if is that possible ?

Best regards

Diego

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2011 Jan 10 11:26 AM

0 Likes
1,237

I haven't came across trying this type of scenario ever. But with referance to one of my collegue answer: Its YES. We can do that.

Try using RFC_READ_TABLE

~edited : Had some spell errors

Edited by: K.Manas on Jan 10, 2011 12:28 PM

Hi,

Does anybody know if there is a way to select data (table: UST12) in development system from production system trhough a RFC.

I need to create a program in development system filtering all the users that they have authorization to a particular transaction for a certain society.

I mean, first i need to acces to PA0001 then I get the user name in PA0105. Then go to UST04 (to get the profiles), and with the profiles I select the transaction in table UST12 (and then i need the profiles that have the transaction MR21).

My problem is that I cannot do such a program in production system to select this data. I have acces to developmen system so i want to select the production data trhough an RFC. Do you know if is that possible ?

Best regards

Diego

Reply
5 REPLIES 5
Read only

Go to solution
Former Member

‎2011 Jan 10 11:26 AM

0 Likes
1,238

I haven't came across trying this type of scenario ever. But with referance to one of my collegue answer: Its YES. We can do that.

Try using RFC_READ_TABLE

~edited : Had some spell errors

Edited by: K.Manas on Jan 10, 2011 12:28 PM

Read only

Go to solution
SuhaSaha
Product and Topic Expert
Product and Topic Expert

‎2011 Jan 10 11:27 AM

0 Likes
1,237

Hello Diego,

This is possible but will definitely be a problem for your auditors. Accessing PROD data from DEV environment is a big security concern for any org.

You should be aware of the complications before proceeding with this requirement.

BR,

Suhas

Read only

Go to solution
former_member227595
Active Participant
In response to SuhaSaha

‎2011 Jan 10 11:40 AM

0 Likes
1,237

Ok Sushas, I will talk first with the auditors. Thanks for telling me.

And K.Manas this RFC seems very useful to acces data in developmen system

Thanks !

Read only

Go to solution
kiran_k8
Active Contributor

‎2011 Jan 10 11:31 AM

0 Likes
1,237

Hi,

1.Create an FM which is RFC enabled and write the code in it.This FM needs to be transported to the target system.

2.Get an RFC destination created in SM59.

3.call ZFM destination 'RFC DESTINATION 'is the syntax to call the target system from the source system

4.Don't use RFC_READ_TABLE

More info is available in SDN.

K.Kiran.

Read only

Go to solution
Former Member

‎2011 Jan 10 11:36 AM

0 Likes
1,237

Hi,

Call your FM which reads data from tables with the syntax : CALL FUNCTION <function> DESTINATION <dest> ...

Please F1 on CALL.

Regards,

Srini.