Sent: Tuesday, June 23, 2020 7:30 PM
To: Wang, Jerry
Subject: Requesting your help for a development object
Hi Jerry,
Its been so long! Hope you are doing great. I am in need of your help for a development object. I am developing an internal project for which I need to fetch data with JOIN statements from different logical system (RFC Connection available). Everything (Selection fields, Where condition, Join Tables and fields) will be dynamic based on the user selection. My current Approach is , I am developing an RFC FM in which I am using the ADBC Classes to get it done. I have searched on web and come across some posts (http://sandeepjetty.blogspot.com/2014/06/open-sql-and-native-sql-in-hana-abap.html) which is helpful. But it still lacks the information if there are more than two JOINs and how to get it parsed to NATIVE DB. This post for HANA DB seems from 2014. I am still not sure how to get it done for other DBs, I have come across a FM DB_SQL_WRITE_TO_ITAB where I see the SQL_ Statement is PARSEd w r t the sy-dbsys. But I am not sure if it helps for the ADBC Classes. I am just checking for the best method to get it done. Can you help me with this?
Is it good to use ADBC classes here? If so can you share some references with multiple JOINS used for ADBC ?
If RFC calls are preferred, do we have any standard RFC FMs available to fetch Data with JOINs?
However, I have gut feeling I will be failed somewhere if statement is not parsed properly for the native SQL.
Can you please help me with this? I can schedule a short call as well for 10-15 mins sometime if you advise me with your availability.
