topic Re: Select data in development system from production system in Application Development and Automation Discussions

Select data in development system from production system

former_member227595 — Mon, 10 Jan 2011 11:21:43 GMT

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

Re: Select data in development system from production system

Former Member — Mon, 10 Jan 2011 11:26:57 GMT

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

Re: Select data in development system from production system

SuhaSaha — Mon, 10 Jan 2011 11:27:28 GMT

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

Re: Select data in development system from production system

kiran_k8 — Mon, 10 Jan 2011 11:31:44 GMT

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.

Re: Select data in development system from production system

Former Member — Mon, 10 Jan 2011 11:36:51 GMT

Hi,

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

Please F1 on CALL.

Regards,

Srini.

Re: Select data in development system from production system

former_member227595 — Mon, 10 Jan 2011 11:40:22 GMT

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 !