Mixing Native Sql with "Open Sql" from SAP.
Petri BRNov 23 2010 — edited Nov 23 2010Hello, I have a doubt, and I really dont know if there is someone that can help me.
But I'll try to explain.
I have a select on an SAP PROGRAM (SAP OPEN SQL), that gives me a range of rows, that I want to use by parameters in a native sql on a select that goes outside the SAP enviroment by a dblink.
I can do that making a loop and executing the sql, that goes outside the SAP enviroment by a dblink, the number of registers that the query on SAP returns.
What I want to know is if there's a way to automate that, and pass the range of rows to the NATIVE ORACLE QUERY SQL.
OBS: by the way... Open SQL consists of a set of ABAP statements that perform operations on the central database in the R/3 System. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. ABAP programs that only use Open SQL statements will work in any R/3 System, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP Dictionary.
Thanks.