Customizing User-Defined Fields, Tables, Objects, and Values

1.

To retrieve data from the database in SAP Business One, Web client, what mechanism do you use instead of writing a query?

Choose the correct answer.

Query Builder

Lookup Mechanism

Data Retrieval Tool

SQL Editor

2.

Which namespace should you use to access fields from the table when defining a formula?

Choose the correct answer.

UI

Header

Product_item

Grid

3.

You can define a mathematical formula:

There are three correct answers.

Only on header fields

To retrieve data from the database

On numeric table fields

On alphanumeric fields

On table list fields

4.

Which of the following statements are true about user-defined values (UDVs)?

There are two correct answers.

UDVs allow entering mathematical formulas on header and table fields.

UDVs require complex SQL queries to be written directly into fields.

UDVs definition does not require any user authorization.

UDVs automate field input and eliminate the need for manual entry.

5.

When using a logical formula to customize field values you can:

There are two correct answers.

Define a trigger

Enter a + operator

Enter ‘greater than’ operator

Use only one lookup object

6.

Which of the following statements are true about user-defined fields (UDFs)?

There are two correct answers.

UDFs can be added to business partner and item master data.

UDFs can be added to a user-defined table.

UDFs are only visible to the user who created them.

You can add a UDF to sales orders and quotations only.

7.

How are UI Field Names specified in a UDV formula?

Choose the correct answer.

The printed name of column header needs to be put in quotes.

The database name needs to be looked up in the Desktop client.

The uname needs to be used, which can be identified using the Web Client Inspector.

8.

In the formula, what namespace is used to display database fields from the Lookup objects?

Choose the correct answer.

UI

DB

OBJ

FLD

9.

Which of the following are true when tailoring the visible values for a field with a drop-down list?

There are two correct answers.

You can add more values to the filtered list which were not defined in the original list.

You need to select the values to be included in the list.

You can allow the users to view all list values.

You cannot hide the UDV indicator.

10.

Which of the following are capabilities of user-defined tables (UDTs)?

There are two correct answers.

UDTs can be automatically populated with data from system tables.

UDTs can be linked to multiple user-defined fields (UDFs) in different categories

UDTs can be distinguished from system tables by their '@' prefix.

UDTs of all table types can be linked to a UDF in a document or form.

Knowledge quiz

To retrieve data from the database in SAP Business One, Web client, what mechanism do you use instead of writing a query?

Which namespace should you use to access fields from the table when defining a formula?

You can define a mathematical formula:

Which of the following statements are true about user-defined values (UDVs)?

When using a logical formula to customize field values you can:

Which of the following statements are true about user-defined fields (UDFs)?

How are UI Field Names specified in a UDV formula?

In the formula, what namespace is used to display database fields from the Lookup objects?

Which of the following are true when tailoring the visible values for a field with a drop-down list?

Which of the following are capabilities of user-defined tables (UDTs)?