topic Re: Fetch data from R/3 table in Application Development and Automation Discussions

Fetch data from R/3 table

Former Member — Wed, 21 Nov 2007 06:54:54 GMT

hi,

i want to access data from SAP using Jco without using any custome BAPI OR RFC FM. Is there any way such that i can query while accessing data from SAP like on multiple SAP table.

Message was edited by:

Sandip Mane

Re: Fetch data from R/3 table

Former Member — Wed, 21 Nov 2007 07:27:30 GMT

Hi Sandip,

If u r not ready to create or use an custom Bapi try to create a RFC FM with all the information which u need from SAP at SAP side and try to access it through u r JCO connecter.

Regards,

Re: Fetch data from R/3 table

Former Member — Wed, 21 Nov 2007 13:01:19 GMT

Hi,

Try looking into function module RFC_READ_TABLE.

Gareth.

Re: Fetch data from R/3 table

Former Member — Fri, 23 Nov 2007 08:33:32 GMT

hi,

Thanks for help, but i am already using RFC_READ_TABLE but it can not work on multiple table. Now i got the way to read multiple table using RFC_ABAP_INSTALL_AND_RUN , while testing in R/3 it works fine that the result WRITES-ZEILE shows character upto 256. But while i call it from Jco it shows only 84 characters per row of WRITE table.

My code is:

for (int i = 0; i < data.getNumRows(); i++) {

data.setRow(i);

String str=data.getString("ZEILE");

System.out.println(str); }

Note: I am new in ABAP

I am fresher i just know JAVA and something abt SAP but i have to do this job for mine java charting project

Re: Fetch data from R/3 table

Former Member — Fri, 23 Nov 2007 08:48:02 GMT

Hi,

To be honest, if you want to do anything remotely complicated the easiest and best way is to create a custom, remote enabled function module or look for a standard one.

Maybe the data you are trying to read already has some standard function modules you could use - what data are you looking for as someone on here might have an idea of what you can use?

Gareth.

Re: Fetch data from R/3 table

Former Member — Fri, 23 Nov 2007 11:54:47 GMT

hi,

I want to copy the following R/3 table data day by day on another MySQL database

that contain the table structure same as R/3 table

The tables are :

HRP1000,HRP1001,HRP1007,PA0000,PA0001,PA0002,PA0022,PA0023....

This is required for our organizational charting application.