Knowledge quiz

It’s time to put what you’ve learned to the test, get 8 questions right to pass this unit.

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

Which of the following are true when tailoring the visible values for a field with a dropdown 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.

When defining a UDV with formula you can:

There are three correct answers.

Define only one trigger

Choose to refresh manually

Use the brackets operation

Test the result before adding

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

Choose the correct answer.

Header

Product_item

Grid

Which of the following are capabilities of user-defined objects (UDOs)?

There are three correct answers.

UDO types can be master data or document.

UDOs must contain one table.

UDOs must contain a child table.

UDOs can contain the services: Cancel and Year Transfer.

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.

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

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.

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

10.

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.