Home > Ask the SAP software/management Experts > Java/SAP development Questions & Answers > Retrieving table contents with JSP
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Retrieving table contents with JSP

Austin Sincock EXPERT RESPONSE FROM: Austin Sincock

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED BY: craig.cmehil@hella.com on 14 April 2003
Using the examples of JCo and RFC functions found on this site I am trying to create a small JSP page that will retrieve the contents of some tables for me. I am very new to SAP but not to Java.

My code is the following:

// Get a function template from the
//repository
IFunctionTemplate ftemplate = repository.getFunctionTemplate("RFC_READ_TABLE");

// Create a function from the template
JCO.Function function = new JCO.Function(ftemplate);
   
JCO.ParameterList tables = function.getTableParameterList(); 

out.println(tables);
If I understand correctly the output should show something? but I only get:

----------------- | PARAMETERS 'TABLES' ----------------- | DAT| FIELD| OPTION| ----------------- |0123|456789|0123456| ----------------- |TAB5|RFC_DB|RFC_DB_| ----------------- 
...Which leads me to believe I have not set a property or value or something? In the ST03 transaction you have the option to "Survey Graphics". This is the data that I'm trying to retreive and store in secondary database. Any help or at least a direction to head in?

>
You are getting the right response, as far as the Java statement's execution goes. The getTableParameterList()-method returns the internal structure or metadata for any in/outbound tables in the RFC interface. Simply printing that structure to the command console will only result in the display of that structure. This is exactly what you are seeing. In order to retrieve any table data, you must populate the appropriate import parameters (QUERY_TABLE would be best) then execute the call to SAP using JCO.Client.execute(function). I recommend using the Function Builder (SE37) to test the RFC_READ_TABLE for the data you need to retrieve. This will also help you better understand how to use this RFC through JCo.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Java/SAP development
How to provide an SAP R/3 4.5B application server with a Web service interface
Consuming a Web service from an SAP 4.6c R/3 application server
With Java development experience, should I go into SAP XI?
Answering basic BAPI questions
Viewing a list of SAP interfaces
Which SAP implementation phase is Java necessary for?
Interface a locally developed application with SAP
Should an ABAP professional know Java?
Storing SAP information from a JCo connector
Integrating SAP with C++, Java, and Powerbuilder on Sybase and Oracle DBs

SAP Java and J2EE
SAP CTO Sikka: SAP's innovation gets overlooked
SAP CTO expects today's SAP applications to be running in 2020
Tips on SAP ABAP
How to provide an SAP R/3 4.5B application server with a Web service interface
Consuming a Web service from an SAP 4.6c R/3 application server
SAP NetWeaver Configuration and Customization
Is C, C++ and Java knowledge required when learning SAP?
How to be a self-taught NetWeaver and ABAP expert
Getting started with a NetWeaver career
An ABAP user wants to learn XI

SAP interface technologies
SAP CTO expects today's SAP applications to be running in 2020
SAP TechEd 09 keynoters: Managing change today like trying to board a speeding train
SAP's Web 2.0 strategy makes way for social networking in business apps
Error when clicking the SAP GUI logon button
SAP applications demo: BP's key mapping
Viewing a list of SAP interfaces
Interface a locally developed application with SAP
Will there always be an implicit commit in an RFC?
Is there a way to search within IDocs using a purchase order number?
Configuring the JDBC Connector Service to perform database lookups

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Application Link Enabling  (SearchSAP.com)
IDoc  (SearchSAP.com)
Remote Function Call  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts