UDT Handler

 

Previous  Next |  Direct link to this topic

The UDT Handler is designed to make it easier to use User-defined tables in SAP Business One.

clip0075

 

Field

Description

Form Title

Title of the window showing.

Form Width

Initial width of the window in pixels

Form Height

Initial height of the window in pixels

Form State

Initial state of the window (Normal, Minimized, Maximized)

User-Defined Table

The table that you want to create a UDT Handler window for.

When selecting the table it will load all fields in the table in the grid.

Fixed col. count

This option allows you to have x of the first columns fixed so you can see them even if you do horizontal scroll

Show line numbers

With this option you can define if there should be shown a line number on each row

Banded row color

With this option you can define if every second row should have color

Allow update

If enabled the user is able to update the data in the window

Allow add row

Controls if the the user add new rows to the window

Allow remove row

Controls if the user is allowed to remove rows from the window

Auto code/name

If enabled the user will need to supply the code/name values manually. If disabled B1UP will auto generate the code/name values.

Use DI-API

This field can be used to enable/disable the use of the SAP DI-API.

 

If enabled, the UDT Handler window will use the SAP DI-API to insert, update and delete records. This will trigger the DI-API data validation and will call the SBO Notification stored procedures.

 

If disabled, the UDT Handler window will do direct insert, update and delete SQL statements against the database. This will not trigger DI-API data validation and the SBO stored procedures will not be called.

 

Disabling the use of the SAP DI-API will allow faster insert, update and delete operations. This will make the windows faster when working with the data.

Use Change Tracking

This field can be used to enable/disable the use of Change Tracking

 

If enabled, the UDT Handler window will keep track of which rows have changes and only update these, resulting in a much better Update Performance.

 

WARNING: While this can dramatically improve the performance it has the limitation of being unable to track changes made by an UF Macro (SDK Limitation) that can in worst case scenario result in that data is not updated if every change on a row was made via a macro.

 

We recommend you turn this feature on if you have many rows and are not manipulating the screen using UF - Macro.

If you turn it on anyway we will try our best to still track the changes but cannot 100% guarentee all scenarios work, so please test before you turn this on

Fields

In this grid you define how each field in the table should be handled.

Column

Description

Field

Field name defined in SAP

Foreign key

This field can be used to define a relation between data in SAP and the records in the window.
The foreign key is used to filter what data is shown when the window is open.

You can use the dynamic syntax and SQL: in this field.

Visible

Should the field be visible in the window

Editable

Should the field be editable in the window

Caption

Here you can overwrite the default caption

You have the option to move the fields up and down to define the order in the window.

 

Advanced

Via the advanced button you can control the ORDER BY of the UTD Handler Result (if you as an example want to see the record ordered by a specific field (example a Date or Number))

 

clip0174

Formtype suffix

This field can be used to ensure unique formtypes for each UDT Handler window.

This allow you to add unique function buttons and other settings per window (or a group of reports if you give them same suffix).

It is recommended to always have a suffix but for legacy reasons you can leave it blank.

NB: Suffix will suggest the same as your code but due to people that wish to group reports and technical reason the prefix can max be 6 chars so if you write a code that is over 6 chars it will not reflect on the suffix.

After configuring the UDT Handler you can now launch it like a normal Universal Function. The UDT Handler will then display a window where the user can modify the data in the table.
clip0077

The window will automatically format the columns based on the field type in the database.
Depending on the settings it is possible to add/remove rows and update the data.

The following things will also be inherited from the field definition in SAP:

Mandatory

Default value

Valid values

It does not inherit the SAP validation rules. We recommend using the B1 Validation system instead.

The normal B1UP features like Function Buttons, B1 Validation, Mandatory fields etc. can be applied to the window.

Item Placement Tool is not supported by this window.