Access SAP Tables using JAVA

[former_member548217]

Hi Experts,

Is there any ways to access SAP custom or standard table using java without using RFC. If yes please help me.

I have checked the following link () but here they were used RFC and that RFC return output as table structure. But I want to call the table directly not using the RFC.

Please help me if there any way.

Regards,

Amit Basak

[junwu]

if you know the table where the data is located, you can access it directly, pure jdbc programming,

hopefully it is readonly,

if it is update work, better go through rfc, unless you are very sure which table to update.

[amolgupta]

Hi Amit,

The logic of having RFCs is to control access to functionality/data of SAP using a well managed service = RFC which can be exposed as a WebService and recently as an ODATA service as well using SAP Gateway (for latest versions).

You can access SAP data using RFC/RFC exposed as webservice or ODATA service only.

If you dont have an existing RFC to achieve the functionality, you will have to have a custom made RFC for the same. There is no other option.

Regards,

-Amol Gupta

[Former Member]

Hi Amit

Unfortunately there is no other way (that I know of).

I wonder what you need it for?

If it's for haevy data processing - you should do it in the SAP system. WD is ment for display and user interface mostly.

Regards

Shai