Skip to Content
avatar image
Former Member

API Database Field Mapping

Hello,

is there any new version of the API Database Field Mapping Document for SAP Business One 9.0+? (old version: http://archive.sap.com/documents/docs/DOC-7020)

I know that we have the list of database tables and objects in the SDK Help file, but I need a mapping of the properties and the database fields like in the document: Property, Field, Type, Size, Read/Write

The development team needs to have something like this to maintain an overview of the di-api i guess. So if this isn't public yet, would it be possible to create such a document?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 20, 2016 at 06:53 AM

    Hi Phillip,

    When you install the SDK you get a REFDB.chm file that contains the database tables structure. Usually it is found in C:\Program Files (x86)\SAP\SAP Business One SDK\Help.

    Pedro Magueija

    LinkedIn | Twitter | Blog

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Philip,

      Just complementing the @Pedro's answer, about the information if the property is read/write, this is an information of the property of the associate object to the table and this can be found on the REFDI.chm file.

      Kind Regards,

      Diego Lother

  • avatar image
    Former Member
    Oct 21, 2016 at 07:12 AM

    Hello Pedro, hello Diego,

    Thank you for your answers. As i stated in my initial question, I know the capabilities of the SDK help files, but it's not suited for the job I need it for.

    There are some problems that I have with the help files:

    1. Not all properties are fully documented. Some have a length, some not. Some have database fields, some not. Some say read only, some not.
    2. When I want the property, database field, data type and length I need to click on the entry for each property which means it can take hours to get the objects I need with all information.

    If I had a table like in the document above, I could parse it with a small program.
    That's why I asked for it.

    Regards

    Phillip Brand

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Phillip,

      Unfortunately, such file doesn't exist. Even the file you mention does not contain all properties/fields (look at page 108).

      It would be very helpful to have such a mapping indeed, especially if they are properly documented.

      Perhaps you can propose it at the SAP Idea. If you do, you have my vote (just drop me the link).

      Pedro Magueija

      LinkedIn | Twitter | Blog