Retrieving table contents with JSP
This reader trying to create a small JSP page that will retrieve the contents of some tables. Expert Austin Sincock helps to analyze the code sample.
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.
Dig Deeper on SAP Java and J2EE
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SAP administration / development experts
View all SAP administration / development questions and answers
Start the conversation
0 comments