Question Re: Finding B1 UI Field Labels for Database Fields Withou... in Technology Q&A

Finding B1 UI Field Labels for Database Fields Without Tedious Mapping

jun_dolor — Wed, 04 Dec 2024 06:37:14 GMT

I need to map the SAP Business One database fields to their corresponding labels as they appear in the B1 client UI. For instance, in the Sales Quotation form, the field OQUT.CardCode is labeled as Customer in the UI.

I know I can use View > System Information to see this information, but with the number of fields across various tables, this approach feels a bit... overwhelming.

Is there a reference, document, or method to retrieve all these mappings in a more efficient way?

Re: Finding B1 UI Field Labels for Database Fields Without Tedious Mapping

Felipe_Lima — Thu, 05 Dec 2024 09:40:06 GMT

Hi.

The query SELECT * FROM SDIS retrieves all changes to the default labels. I couldn't find a way to retrieve the original names apart from using Query Generator, but you'll have to do it for every single table. The names are stored in the system files rather than the database. UI and DI-API documentation do not supply it either. So I think this is only achievable via SDK.

Re: Finding B1 UI Field Labels for Database Fields Withou...

msundararaja_perumal — Fri, 06 Dec 2024 17:16:33 GMT

Dear @jun_dolor,

If you have installed SDK, then look for SDK help file, it describes the tables with field name, field description and its functionality. This will show only that are exposed in Business One.

Thanks.