I need to retrieve data from a specific table in the SAP database using JCo. Is this possible? If so, please give me some pointers on how to go about it.
Requires Free Membership to View
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial DirectorThe best way to do this is using 'RFC_READ_TABLE'. This allows you to specify a table, fields, and search parameters to retrieve data directly from an SAP database table. Bear in mind, if you need to do multiple table lookups or joins, using this RFC over and over will add additional stress to the application server.
This was first published in July 2002