Hi ,
Here is What you do .
1.Write this code in a DynPage to get the Data
here i am calling a BAPI from Sales Module as Example.
public DefaultTableViewModel getData(String USER, String PWD,String R3ip) {
com.sap.mw.jco.IRepository repository;
JCO.Pool pool = JCO.getClientPoolManager().getPool("R3");
if (pool == null) {
//JCO.removeClientPool("R3");
JCO.addClientPool(
"R3",
10,
"285",
USER,
PWD,
"EN",
"R3ip",
"00");
}
repository = JCO.createRepository("TTL", "R3");
JCO.Client client = null;
// Get a function template from the repository
IFunctionTemplate ftemplate =
repository.getFunctionTemplate("BAPI_SALESORDER_GETSTATUS");
// Create a function from the template
JCO.Function function = ftemplate.getFunction();
client = JCO.getClient("R3");
JCO.ParameterList input = function.getImportParameterList();
input.setValue("0053100700", "SALESDOCUMENT");
client.execute(function);
JCO.Table sales_orders =
function.getTableParameterList().getTable("STATUSINFO");
//*********************
Vector row = new Vector();
Vector tbl = new Vector();
Vector colNames = new Vector();
// Loop over all rows
do {
// Loop over all columns in the current row
for (JCO.FieldIterator e = sales_orders.fields();
e.hasMoreElements();
) {
JCO.Field field = e.nextField();
row.add(field.getString());
//System.out.println(field.getName() + ":t" + field.getString());
} //for
tbl.add(row);
} while (sales_orders.nextRow());
sales_orders = null;
sales_orders =
function.getTableParameterList().getTable("STATUSINFO");
sales_orders.nextRow();
for (JCO.FieldIterator e = sales_orders.fields();
e.hasMoreElements();
) {
JCO.Field field = e.nextField();
colNames.add(field.getName().toString());
}
DefaultTableViewModel dtvModel =
new DefaultTableViewModel(tbl, colNames);
JCO.releaseClient(client);
//**********************
return dtvModel;
}
2. Create a Bean to Store the Data
import com.sapportals.htmlb.table.DefaultTableViewModel;
public class DataBean implements Serializable {
public DefaultTableViewModel model;
public DefaultTableViewModel getModel() {
return model;
}
public void setModel(DefaultTableViewModel model) {
this.model = model;
}
}
3. Use this Bean in JSP
<%@ taglib uri="tagLib" prefix="hbj" %>
<jsp:useBean
id="myBean"
scope="session"
class="DataBean"
/>
<hbj:content
id="myContext">
<hbj:page
title="PageTitle">
<hbj:form
id="myFormId">
<hbj:tableView
id="MessageTable"
model="myBean.model"
design="ALTERNATING"
headerVisible="true"
footerVisible="true"
fillUpEmptyRows="true"
navigationMode="BYLINE"
selectionMode="SINGLESELECT"
headerText="Inbox"
visibleFirstRow="1"
width="500">
</hbj:tableView>
</hbj:form>
</hbj:page>
</hbj:content>
4. Call the getData method in DynPage doInitialization() Method.
Here save the data in the Bean and save the bean in Session.
Thats the Complete Solution For you.
if u need further inputs do write back.
Regards
Rajendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.