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 a comment
10|10000 characters needed characters exceeded

Related questions

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 a 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 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.