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

Web interface - request for help

Hello All,

I consider to create for our customers a web interface that will allow them to place orders on their own. Currently this work is being done manually, i.e. a person picks up phone calls, enters data into SAP, etc. There are many orders everyday so such a facility would simplify the process very much.

Since I am new in developing SAP then have many questions how to accomplish this task. Is it for example possible to create a web page in PHP or Java? Are there any additional resources necessary, or that what we have on CD is enough? Should I read and put data into database using SQL queries or other special mechanism?

I started to dig into SDN pages, but there is an overwhelming amount of information so I feel a little lost. If you could navigate me in this jungle I would be happy. Are there any ready-made examples?

I will be grateful for all your replies.


Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2004 at 12:16 PM

    I have done some work with ASP and used an ODBC connection to the SAP B1 server. It also does some inserting, but I advice against this, since SAP advices people to use their datainterface for that.

    6.5 Does not support the DI API with ASP, don't know about PHP or Java, but I would not count on it.

    6.7 Will aparently support the DI API in ASP through something called "DI SERVER". I do not know how or if this will work, but I will check it out when 6.7 comes.

    Otherwise... you can always implement an activeX dll with the functions in VB or C# and use them in your ASP/PHP/JAVA code somehow... there are ways, if you're a wizard :o)

    If you wait for 6.7 and use the DI API,.. you can use that for inserting your orders from an ASP page. There are VB samples of how to do this on the CD. And you need of course to install the DI (DataInterface) to do this stuff ...

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2004 at 06:00 AM

    well, if we use PHP we can directly access to SBO database through SQL Server. For Example to Create Order, we have to manipulate ( like function doquery in DI/API) ORDR dan Its Line Item tables to manipulate Order. But you have to declare your connection to dabatabase from config.php or some king like that. But SAP reminds Us that it is absolutely forbidden to use and action queries (UPDATE, INSERT, DELETE) directly to SAP Business One system Tables without using DI/Api through its business object.

    Regarding to your question i suggest you to use vb script to create the wb site since vb support SBO Object.or you can use jsp ( java)as long as you install java connector. But truly i've never tried this. But theoritically it can be done.



    Message was edited by: Hamdi Syukriwan

    Add comment
    10|10000 characters needed characters exceeded