Select data in development system from production system

[former_member227595]

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

[former_member227595]

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

[Former Member]

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

[SuhaSaha]

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

[former_member227595]

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 !

[kiran_k8]

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.

[Former Member]

Hi,

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

Please F1 on CALL.

Regards,

Srini.