topic Re: extracting data from sap to java application using JCO in Application Development and Automation Discussions

extracting data from sap to java application using JCO

Former Member — Wed, 18 Apr 2007 05:58:03 GMT

Hi,

I am new to sap and wanted to know what is the procedure to extract data from based on the java application client (user defined input from different tables of sap) input and need to manage huge data meaning reading millions of records.kindly help me how to handle this in ABAP.

Re: extracting data from sap to java application using JCO

Former Member — Wed, 18 Apr 2007 06:26:10 GMT

Hi,

Pls chk these links

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/ad09cd07-0a01-0010-93a9-933e247d3ba4

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/47b6cd90-0201-0010-5aba-b6b7474d4aff

<b>***Reward Points if Useful</b>

Regards

Gokul

Re: extracting data from sap to java application using JCO

Former Member — Thu, 19 Apr 2007 05:49:36 GMT

Hi,

Thanks for providing me the information ,but i need more information how in sap to retrive the data based on the java clients having sap tables and it allows the user to input selcted columns from more than one table and based on this i need to code in abap in such way that it should retrive data (using open sql query) and dynamic iinput is given to the sap ,need to maintain batch of data.

if your able to provide detailed information it will be hrlpful for me

Thanks,

jahnavi

Re: extracting data from sap to java application using JCO

Former Member — Tue, 20 May 2008 16:01:00 GMT

Hey Jhanvi,

Was wondering were you able to solve this particular issue.I have a situatuin where in I have pull the data from my infocube through an java program.

I guess I need to write a Functional Module to read those value but I am not very sure about it and abt the procedure.

Please let me knw if you have anything to add up that can help me .

Regards

Ankit

Re: extracting data from sap to java application using JCO

Former Member — Tue, 20 May 2008 16:15:54 GMT

Hi jahnavi,

I think your problem is not to use the JCO to communicate to SAP but how to retrieve the data in the selection you want is that right?

if so you need to build a RFC enable Function Module in SAP that uses dinamic OpenSQL just like SQL.