Skip to Content
avatar image
Former Member

Use B1i to integrate two SBO databases

I have been playing around with B1i and setting up a few scenarios between R/3 and SBO with a college of mine. Ultimately we will have to set up scenarios for a client of ours, but they are still in the start up phase of SBO, but have been running R/3 at the headquarters for some time. Now, setting up scenarios between R/3 and SBO is fine and they work most of the time (we’ve had a few connection problems), but I can’t for the life of me set up a scenario between two SBO databases. Can the sender and receiver type systems both be SBO systems or can you only set up scenarios between R/3 or mySAP and SBO? I have seen some forum discussion topics on using iBOLT as the integration tool to communicate between two or more SBO systems and have also had a meeting with the iBOLT guys from the Netherlands. Is iBOLT the only integration tool available or can B1i also be used to send data between two SBO systems?

Thanks,

André

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 17, 2006 at 01:51 PM

    Hi Andre,

    This is quite easy to achive. You just have to create a new BIU that involves the two B1 objects and then import them into the B1i repository, create the scenario in the Control Center and that's it. B1i will invoke the DI Adapter to insert the destination object in the B1 databae.

    Best regards,

    Felipe

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      No panic Andre, calm down :o)

      First of all, by using BIU's you set the scenarios in the control center of B1i. Now in the CD there's a document that tries to explan how to develop a BIU. I know it is not very straight forward but it will give you an idea. I'm working with my colleages to publish a new doc in the SDN and that will happen soon.

      The heart of the BIU is the xls file, where the transformation takes place. Here, what you need to do is to map the structure of the target object with the structure of sender object. All this is available in the payload that is being processed.

      Here for example I send a PO from Subsidiary1 and is received as an a Sales Order in Subsidiary2:

      <xsl:param name="CustomerNumber" select="/b1im:B1IMessage/b1im:Header/b1im:System/sim:PropertyList/sim:Property[@Key='Subsidiaries Customer Number']/@Value" />

      - <xsl:template match="b1im:B1IMessage/b1im:Body/b1im:Payload[starts-with(@ObjectTypeId,'B1.200') and contains(@ObjectTypeId,'_PO')]/BOM">

      - <BOM>

      - <BO>

      - <AdmInfo>

      <Object>17</Object>

      <Version>2</Version>

      </AdmInfo>

      - <Documents>

      - <row>

      <DocType>dDocument_Items</DocType>

      - <CardCode>

      <xsl:value-of select="$CustomerNumber" />

      </CardCode>

      - <DocDate>

      <xsl:value-of select="BO/Documents/row/DocDate" />

      </DocDate>

      - <DocDueDate>

      <xsl:value-of select="BO/Documents/row/DocDueDate" />

      </DocDueDate>

      - <CardName>

      <xsl:value-of select="BO/Documents/row/CardName" />

      </CardName>

      </row>

      </Documents>

      - <Document_Lines>

      - <xsl:for-each select="BO/Document_Lines/row">

      - <row>

      - <LineNum>

      <xsl:value-of select="LineNum" />

      </LineNum>

      - <ItemCode>

      <xsl:value-of select="ItemCode" />

      </ItemCode>

      - <Weight1>

      <xsl:value-of select="Weight1" />

      </Weight1>

      - <Quantity>

      <xsl:value-of select="Quantity" />

      </Quantity>

      - <Price>

      <xsl:value-of select="Price" />

      </Price>

      - <LineTotal>

      <xsl:value-of select="LineTotal" />

      </LineTotal>

      - <U_TB1BIT>

      <xsl:value-of select="U_TB1BIT" />

      </U_TB1BIT>

      </row>

      </xsl:for-each>

      </Document_Lines>

      </BO>

      </BOM>

      </xsl:template>

      The other files are quite easy as you just have to copy them and change one or two values on them.

      Check out the document "Enhancement_Guide_Business_Integration_Unit.pdf"and I promise you a much beauty one soon.

      Hope this helps.

      Felipe

  • avatar image
    Former Member
    Sep 02, 2010 at 02:15 PM

    Have u manage to get it working. I am doing B12B1 integration using Intergration tool for SAP Business One. Most of the examples is see on this site refer to SAP Integration for Netweaver is this tool the same as the one for SAP B1i because i dont see some of the items in Control Panel. I am using SAP Business One 8.8 the Tutorial i have is for b12b1 scenario for with b1iSN. Some of the items mentioned in the tutorial dont seem to be present in the SAP B1i Tool . I have downloaded the BUI for creating b1 Purchase Order to b1 Sales Order i could not find the xml file that shows the object types but i saw the one listing system types? I have not manged to set up my admin console to show the extras menu is there a manual that can help me set up the steps once the BUI is imported how do i show the Extras menu in SAP Business One Integration Tool not the one for Netweaver.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi guys ! I have installed B1ISN2007 PL14. The Technology PL14 SIM PL14 AND CONTENT PL14. Was there need to install the previous patch levels before i installed PL14? i am currently following the How to Build & Run B12B1 Scenario

      - BIU.B1PO2B1SO with B1iSN 2007 from www.sdn.sap.com/irj/scn/weblogs?blog=pub/wlg/16298. [original link is broken] [original link is broken] [original link is broken] Problem is when i get to Setting the Criteria on Page 31. The interface is somewhat different i cannot go straight and define my criteria. If i choose to Load then it defines the criteria differently from what is mentioned in the system? By the way i am customising the B1PO2B1SO for sending and receiving from 8.8 not 2007 systems only the Integration Platform is the 2007 version. Will it work like that any suggestions.

      ps Do i have to inastall the PL one by one till i get to 14???????

      If it aint broken don't fix it

      Regards

      Benedict

  • avatar image
    Former Member
    Sep 21, 2010 at 03:03 PM

    André

    The interface is a little diffrenet indeed.

    To get to the criteria fields, you need to use the detail button, and then select Criteria Fields, enter the number of fields you wuld like to define, and click on the define fields button.

    The Load button is used to view/modify existing types.

    To learn more about the creation of new object types, you can refer to guide 03 - extensibility, found under the guides menu of B1iSN Tools chapter 3.1.1 - although this guide refers to the old UI a well.

    And last - you do not need to install anything prior to PL14. This is a full install, and does not rely on previous versions.

    HIH

    Motty

    Add comment
    10|10000 characters needed characters exceeded