topic Re: Is there a BAPI for general SQL query in Application Development and Automation Discussions

Is there a BAPI for general SQL query

former_member625844 — Fri, 13 Mar 2020 06:44:05 GMT

I wonder is there a BAPI which take a SQL as import parameter and return the result in a table？or I have to write BAPI for each query I need? Thx.

Re: Is there a BAPI for general SQL query

Dominik_Tylczynski — Fri, 13 Mar 2020 06:55:39 GMT

There is a RFC-enabled function RFC_READ_TABLE that you might consider. Just go through SAP support noted on the function so you know its limitations and authorization concept.

Otherwise there is no generic, all purpose, Swiss-army-knife BAPI that would allow to execute an arbitrary SQL query. That would be a gaping hole in the security.

Best regards

Dominik Tylczynski

Re: Is there a BAPI for general SQL query

FredericGirod — Fri, 13 Mar 2020 06:57:40 GMT

as 3a9e4ce873a94034b33dc62b0ce600ee said, there is RFC_READ_TABLE, but, what will you do with this ? Where will you use it ?

Re: Is there a BAPI for general SQL query

former_member625844 — Fri, 13 Mar 2020 07:17:28 GMT

@frdric.girod.I want to use it in Jco to fetch data from SAP and display in a web page. Since there are several list to write I wonder is there a general way.

Re: Is there a BAPI for general SQL query

FredericGirod — Fri, 13 Mar 2020 07:27:35 GMT

If it is Web related, naybe you have to check this blog:

https://blogs.sap.com/2016/04/06/expose-cds-views-as-odata-service/

You will have some job to do, creating the CDS view (if the standard is not enough) and you could create a Odata service for each CDS (Rest).

Re: Is there a BAPI for general SQL query

Sandra_Rossi — Fri, 13 Mar 2020 08:08:59 GMT

Especially note 382318 - RFC_READ_TABLE

It's generic, so it's a security problem that any table with sensitive data can be extracted (private information, address, email, and so on), now and in the future. The list of tables which can be extracted can be limited via S_TABU_* authorization objects.