Skip to Content
author's profile photo Former Member
Former Member

Getting Price of material

Hello,

I am using SAPJCO to get the price of a material and i set the import parameters as follows and i get the output as Table parameter.<b>The problem is i dont get a result when i execute the function and when i write to html it says <i>no fo records found 0</i> but when i execute with same values over sapgui tool its fetches the record with price</b>.Any ideas appreciated.

JCO.Function jcofunction = aConnector.createFunction ("ZZ1IF_FG001_002");

JCO.ParameterList input= jcofunction.getImportParameterList();

JCO.ParameterList tables=jcofunction.getTableParameterList();

JCO.ParameterList output=jcofunction.getExportParameterList();

input.setValue("000000000010045512","I_MATNR");//Material Number

Timestamp astamp=new Timestamp(Calendar.getInstance().getTimeInMillis());

System.out.println("DATE"+astamp.toString().substring(0,10).trim());

input.setValue(astamp.toString().substring(0,10).trim(),"I_DATAM");

SAPConnector.getGlobalClient().execute(jcofunction);

System.out.println("OUT " +output.toString());

JCO.Table aTable=tables.getTable("T_KONP");

System.out.println("PRICE "+ aTable.getDouble("KBETR"));

aTable.writeHTML("c:/prices.html");

System.out.println("result :" + aTable.toString());

Thanks,Jakeer

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2004 at 03:54 PM

    Hi Jakeer,

    on the first glance, the timestamp might be the reason. java.sql.Timestamp (i guess, you are using this, it's difficult to say without import statements) returns the ISO format "yyyy-MM-dd" on toString(). R/3 "timestamps" are expected in the format yyyyMMdd without the '-' normally. Remove the '-'s and see what happens.

    Hope that helps.

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.