extracting data from sap to java application using JCO

[Former Member]

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.

[Former Member]

Hi,

Pls chk these links

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

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

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

Regards

Gokul

[Former Member]

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

[Former Member]

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

[Former Member]

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.