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

looking for a Datamodel or documentation about relations between tables


I'm looking for a datamodel (SBO) or documentation about the relationship between the tables used in Business One.

Maybe could someone mail my the documentation, DB_HELP.chm or something else that is useful.

Please mail me:

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 13, 2006 at 12:13 PM

    Aben - you can download B1DE or B1TE from SDN. They both

    contain B1 DB Browser, a Windows application that will

    show you all the tables and their relationship.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Aben !

      NEVER EVER Do an insert directly to a SBO Database, you'll loose all warranty and support if you do so.

      Instead, use the DI SDK, add a reference to SAPbobsCOM and then


      Public vCompany As SAPbobsCOM.Company

      Public vBP As SAPbobsCOM.BusinessPartners

      Private Sub sap_connect(ByVal server As String, ByVal db As String, ByVal user As String, ByVal passwd As String, ByVal language As String)


      vCompany = New SAPbobsCOM.Company

      vCompany.Server = server

      vCompany.CompanyDB = db

      vCompany.UserName = user 'SAP User

      vCompany.Password = passwd

      'vCompany.language = language

      vCompany.UseTrusted = True

      IRetCode = vCompany.Connect

      vCompany.GetLastError(IErrCode, serrmsg)

      If IRetCode <> 0 Then

      msgbox("Disconnected" & serrmsg)


      msgbox("Connected: " & serrmsg)

      End If

      End Sub


      After connecting:


      vBP = vCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners)

      vBP.CardCode = "CODE0001"

      vBP.CardName = "BP NAME"



      That's the correct, clean, supported, nice and working way to add a BP !

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 10:30 AM
    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.