Skip to Content
avatar image
Former Member

Need Help

Hi,

I am a technical Consultant. I have worked on SAP R/3 but have no experience in SAP B1.

Right now i am involved in integration project.

I have question on interface mapping. what is the procedure for doing that. what are the file formats i have to know.

How are the flat files sent to the interface? Is their a program which does that?

Please help me out with this. Thanks a ton!

Message was edited by:

Darius Heydarian

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Oct 10, 2007 at 04:20 PM

    There are a couple of ways data can be brought in to SAP Business One.

    1. Through Data Transfer Workbench (DTW), this is tool which comes with the SBO and the files are in Excel format (CSV or TAB delimited). The files can be imported using this tool.

    2. Another way is to import data through the Administration > Data Import/Export option with the SBO application.

    3. As it seems in your case, you will probably be doing it through SDK code using the DI API.

    See some of these notes

    R/3" target="_blank">http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/78597555-0e01-0010-6799-df7b1cbf5966">R/3 Configuration

    Also, try to post this message in Expert Forums » SAP Business One » SAP Business One Integration Technology and you could get some really good step by step procedures

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi sampath,

      I will explain to you my project scenario.

      Comapny X (Online order Management)<---> Company Y (SAP B1) <----> Company Z(Warehouse Management)

      Lets say if Company Y has to send all the Sales orders how are we going to do it?

      Like where do i map our fields to the fields of Company Z ? How do i send the flat file ?

      Right now i just have the evaluation version of SAP B1....Do i need SDK to do all this? Please help me with this am totally confused.

  • avatar image
    Former Member
    Oct 10, 2007 at 10:24 PM

    Quick answer would be if Company X AND Company Z are not running SAP B1 you would need to use SDK tools to build the interface.

    That apart I have a few questions on your scenario

    What Applications are Company X AND Company Z using?

    If they are not using SAP B1, are they running on SQL Server?

    Are they group companies of Company Y or other outside companies?

    Please give me a detailed scenario so that I could help further

    Suda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Company X and Y are not running SAP B1

      Company X is an eCommerce System which does online order management.

      Company Z does warehouse management. They dont use SAP.

      When you say SDK tools how exactly is the interfacing done? Can DTW be used for data transfer between these systems.?

      I can send you the information flow if you send me your id.

  • Oct 11, 2007 at 03:53 AM

    Hi

    Have you looked at the iBOLT Third Party Software from Magic Software? This will accomplish what you want. Also what Version is this - can you use the B1i Tool? Otherwise you will have to use the DI and SDK - and you should wait until you are off the Evaluation Version and on to a live Demo or Devpt Version of the software.

    Rgds

    Marilyn

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2007 at 06:48 PM

    iBOLT can work with non SAP databases with no problems but of course you are paying for this, however it does allow you to design logical flow structures including auto emails for example if you wish to notify someone that a PO has been raised in another company.

    DTW could be used to pick up data from a file which has already been created and import into SBO but it cannot pull data from the original company.

    My suggestion first of all is to review the Magic Software website and look for the iBOLT for SAP Business One - we use this on a number of sites with success

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2007 at 08:01 AM
    Add comment
    10|10000 characters needed characters exceeded

    • There is B1 integration technology that will integrate data from R/3 to SBO. It is not DTW. Read the manual file relates to DTW and R3. you can't use DTW.

      IF R/3 can export in txt format file, you must develop addon interface. you could use examples in this folder : C:\Program Files\SAP\SAP Business One SDK\Samples

      Rgds,