topic Re: JOIN clause in RFC_READ_TABLE? in Application Development and Automation Discussions

JOIN clause in RFC_READ_TABLE?

Former Member — Thu, 21 Apr 2005 15:17:24 GMT

Hello Experts-

Can I use 'RFC_READ_TABLE' to read the contents of a Database View on a remote system?

I don't want to have to issue multiple 'RFC_READ_TABLE' commands in my program. If I am able to create a view on the source system then can I query its contents using this FM like I can of a normal database table?

Also, does 'RFC_READ_TABLE' support the JOIN clause? If I am unable to access the contents of the view on the remote system, then can I atleast construct a statement with the JOIN clause which I can execute through this FM?

Thanks,

- Vik.

Re: JOIN clause in RFC_READ_TABLE?

Former Member — Thu, 21 Apr 2005 15:22:55 GMT

Hi Vik,

You can use it to access a view (just tested it, no problems).

I don't think that the parameters really support the JOIN clause though. Think it would be simpler to access a view.

Cheers,

Brad

Re: JOIN clause in RFC_READ_TABLE?

juan_suros — Thu, 21 Apr 2005 16:54:52 GMT

If you really need to limit yourself to one RFC call to get your data, you might consider an approach built around FM RFC_ABAP_INSTALL_AND_RUN.

Write a short ABAP program that uses WRITE to export your desired results as a standard list to screen.

Send the lines of this program to RFC_ABAP_INSTALL_AND_RUN in the PROGRAM table and the code will execute and return screen results as the lines of table WRITES.

This will allow arbitrary SQL and ABAP manipulation of data before it is returned to your calling process. Many third party data extraction applications are built around this function.

Re: JOIN clause in RFC_READ_TABLE?

ChristianFi — Thu, 21 Apr 2005 19:11:15 GMT

Sorry, but in my opionion fm rfc_abap_install_and_run should not be accessible in a productive environment via rfc.

Christian

Re: JOIN clause in RFC_READ_TABLE?

Former Member — Thu, 21 Apr 2005 19:51:04 GMT

I agree with Christian.

The Basis administrator at the customer site that I spoke with feels very uncomfortable with me doing anything with RFC_ABAP_INSTALL_AND_RUN.

He would consider my setting database level triggers and execute program logic at the lowest level but he will not even consider enabling RFC_ABAP_INSTALL_AND_RUN.

In a productive environment, RFC_ABAP_INSTALL_AND_RUN can open a can of worms.

Re: JOIN clause in RFC_READ_TABLE?

Former Member — Thu, 21 Apr 2005 20:51:40 GMT

Why do you want to create a view and then use RFC_READ_TABLE?

Why can't you create a RFC of your own with all the table accesses and necessary logic to pull them? This way you will have better control over the selection and restrictions over the data. Also, tomorrow if there is a need for more tables to be added, you can easily change your custom RFC, rather than trying to change the view.

Another thing to remember is depending on the number of tables and the join conditions, your view definition may become very complex and also may result in a performance issue. Whereas with your custom RFC, you can take control of the performance issues with several options.

Srinivas

Re: JOIN clause in RFC_READ_TABLE?

former_member183804 — Fri, 22 Apr 2005 04:36:26 GMT

Hello Vik,

the Fuba Rfc_Read_Table is intended for demo and not for productive use. If possible stay away from using it and use a aribtrary Fuba which is dedicated for your problem.

If your requirements are satisfied by using some handmade view it doesent really sound like dynamic programming, which is the only reason to use a mechanism like this Fuba.

Best Regards

Klaus

Re: JOIN clause in RFC_READ_TABLE?

juan_suros — Tue, 26 Apr 2005 00:07:45 GMT

My SAP admin guys would have a heart attack if I even suggested touching the database layer under SAP directly, yet we have a 3rd party reporting tool that runs RFC_ABAP_INSTALL_AND_RUN every day. I guess it is a difference in corporate culture.

The FM RFC_ABAP_INSTALL_AND_RUN has a very restrictive series of AUTHORITY-CHECKs built into it. From a security standpoint, anyone who can get far enough to run this FM can do almost anything to your system anyway, so I'm not sure why there is such resistance to it.