06-29-2006 1:39 PM
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
06-29-2006 1:41 PM
06-29-2006 1:42 PM
You can call the RFC_READ_TABLE which can read any table on the SAP side.
Regards,
Ravi
06-29-2006 1:43 PM
06-29-2006 1:45 PM
hi,
you need to use Java Connector, using RFC
<b>RFC_READ_TABLE</b> , to fetch the data from the tables from java applications.
Regards
vijay
06-29-2006 1:54 PM
Hi Vijay/Rich/Ravi
I am already using this FM RFC_READ_TABLE. In this FM, we have a parameter called <b>DATA</b> in <b>TABLES</b> list. The length of the record of this table DATA is 512 charaters, whereas the length of the record of the table <b>VBKD</b>(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 <b>DATA</b>".
Plz clarify this.
Thanks,
Sree Ramya.
06-29-2006 1:57 PM
You can as well specify the names of the fiels that you need. in the FIELDS table of the rfc.
Regards,
ravi