topic Re: JAVA code for fetching a single row from a table in SAP in Application Development and Automation Discussions

JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:39:11 GMT

Hi All

Can anybody please tell me how to implement the "Select Single" query in JAVA while accessing SAP

Our requirement is to fetch the Sales Document number(VBELN) by passing the Purchase Order Number(BSTKD) from any of the tables containing these two fields like VBKD.

Thanks in Advance

Sree Ramya

Re: JAVA code for fetching a single row from a table in SAP

RichHeilman — Thu, 29 Jun 2006 12:41:43 GMT

You would need to create an RFC enabled function module on the ABAP side, and put your select in this function module. Then call this function module from your java app using jCo. You can not select data directly from the ABAP database.

Regards,

Rich Heilman

Re: JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:42:45 GMT

You can call the RFC_READ_TABLE which can read any table on the SAP side.

Regards,

Ravi

Re: JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:43:03 GMT

Refer this thread for some insight:

Regards,

ravi

Re: JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:45:45 GMT

hi,

you need to use Java Connector, using RFC

RFC_READ_TABLE , to fetch the data from the tables from java applications.

Regards

vijay

Re: JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:54:57 GMT

Hi Vijay/Rich/Ravi

I am already using this FM RFC_READ_TABLE. In this FM, we have a parameter called DATA in TABLES list. The length of the record of this table DATA is 512 charaters, whereas the length of the record of the table VBKD(the table which i am trying to fetch) is 586 characters. As a result of which, an exception is being thrown stating that "The record does not fit into the table DATA".

Plz clarify this.

Thanks,

Sree Ramya.

Re: JAVA code for fetching a single row from a table in SAP

Former Member — Thu, 29 Jun 2006 12:57:08 GMT

You can as well specify the names of the fiels that you need. in the FIELDS table of the rfc.

Regards,

ravi