Skip to Content
0

API Database Field Mapping

Oct 20, 2016 at 06:40 AM

172

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Pedro Magueija Oct 20, 2016 at 06:53 AM
1

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

Show 1 Share
10 |10000 characters needed characters left 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

1
Phillip Brand Oct 21, 2016 at 07:12 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0