API Database Field Mapping

[phillip_brand]

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?

[pedro_magueija]

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

[former_member185682]

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

[phillip_brand]

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

[pedro_magueija]

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