How to know which DB Item can be filled with which SDK property?

[Former Member]

Hello Forum,

if I look at the GUI, I can see that a field is stored in a specific DB field. For example the Address Receiver field in the Purchase Order is OPOR.Address2. The Name in the SDK is also Address2. Here I can guess the connection directly. But if I want to set the detail info for this address, then I see that they are stored in POR12.StreetS. How can I know that this DB field is available through this property: B1Doc.AddressExtension.ShipToStreet

Is there some kind of documentation where I can make this connections between the DB Item and the SDK property?

Thanks

Kin

[former_member233854 · Accepted solution]

Hi Kin,

You have this information in the SDK Help like the image below

[Former Member · Accepted solution]

Hi Danilo,

you are refering to the SDK_EN.chm.I'm thinking about the other way:

I look in the GUI and I know that I want to fill the Fields of the Table POR12 (the delivery address of the Purchase Order).

How do I find the corresponding fields of the B1 Api?

In the SDK file is nothing written that I can find it here: B1Doc.AddressExtension

Thanks

Kin

[Johan_H · Accepted solution]

Hi Kin,

You have encountered an old problem with the SDK.

In the SDK property names have never matched field names in the GUI very well, and field names in the database have never matched field names in the GUI very well.

SAP is not really interested in doing anything about this nor in updating the documentation, so unfortunately you are going to have to do some investigating, to find the property you need.

In the case of address extensions, this gets even worse, because they are in sub tables (RDR12, DLN12, INV12, etc.), and in the SDK, they are exposed through a sub object of the documents object.

I recommend to simply ask here on the SCN whenever you are having trouble finding what you need.

Regards,

Johan

[former_member233854 · Accepted solution]

No, I was refering to the SDK Help Center, usually located on this path C:\ProgramData\Microsoft\Windows\Start Menu\Programs\SAP Business One\SDK.

In this help file, you can use the index to find for "AddressExtension Object", on the top, right above the title you a link to "Members"

[Former Member · Accepted solution]

this link points to the SDK_EN.chm. If you search for *.chm files in the B1 folder you will find some more very helpful files. But they are no for doing the connection between the DB fields and the sdk properties.

@Johan: Thanks for the invitation. Most times I find in this forum a source example that is showing what I need... but not for all of my problems. So I will ask.

[former_member185682 · Accepted solution]

Hi Kin,

Do you have the SDK installed in your machine?

If yes, look in this path:

For x86 OS

%programfiles%\SAP\SAP Business One SDK\Help\

For x64 OS

%programfiles(x86)%\SAP\SAP Business One SDK\Help\

Inside of this folder, you will find this:

REFDB.chm for database help.

REFDI.chm for DI API help, that danilo showed in his first anwser.

REFUI.chm for UI API.

---

Best regards,

Diego Lother