cancel
Showing results for 
Search instead for 
Did you mean: 

Help required in converting queries f

Former Member
0 Kudos

Hello All,

We have set of SQL queries which fetches data from ABAP and Java tables(mentioned below) from database of SAP PI(Singapore server).

The DB of SAP PI is SQL server.

XI_AF_MSG (Java Schema)

SXMSPMAST (ABAP Schema)

SXMSPEMAS (ABAP Schema)

TRFCQIN (ABAP Schema)

XI-AF_ADM_STATE (Java Schema)

ARFCSSTATE (ABAP Schema)

Now the requirement is we need to write queries for another SAP PI(UK server) which is running on Oracle DB.

From the Basis we came to know that the queries should be written in Open SQL to fetch data from ABAP and Java tables.

Can anyone help us in converting SQL queries into Open SQL? Is there any utility/tool which helps in converting?

Regards,

Naresh Dasika

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

We do have some tools .. just google it..

eg: http://download.cnet.com/Convert-Mysql-to-Oracle/3000-2065_4-10902135.html

But please keep in mind the auto code generated still can be optimized...

Babu

Answers (0)