Update transactions

• Code (field COD)

This code identifies the system transaction to be launched.

• Description (field ZINTIT)

• Module (field MODULE)

Select a module for the setup.

Use this field to specify if the screen has to be created in the folder database. This is the case when the module linked to the screen is active on the folder.

• Short description (field ZINTITSHO)

• Activity code (field CODACT)

An activity code is used to:

• Make an element optional in the dictionary if the value associated with the activity code is null
• Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z
• Size a maximum number of lines when the activity code marks elements from a grid

If the activity code is disabled:

• The marked element will not be useable
• The associated code will not be generated nor activated

• Access code (field ACS)

This access code makes it possible to prohibit access to the current record for some users.

If the field is populated, only users that have this access code with read access rights (and write access rights respectively) can view (or with write access rights, modify) the record.

Execution right that can be attached to the access code that is used to authorize the execution of the system transaction.

Taking into account the fact that this function is sensitive, it is advisable to enter an activity code and to carefully limit the number of users that have the execution right.

• Table (field TBL)

Define the principal table on which the transaction is going to be executed.

• Linked tables (field LNKTBL)

Identify the tables linked to the principal table.

• Link (field LNKEXP)

This field is defined as one or more calculated expressions separated by a semi colon. Each expression is evaluated, and the result used to identify the value of the key used to perform the join. When multiple joins are authorized, only the first elements of the key can be given.

In the expressions, constants can be used, as well as fields coming from the tables previously defined in the link list.

• Type (field VARTYP)

Define the data type corresponding to the entered parameter. This is used to control the value by means of a table, if required.

• Description (field ZVARINTIT)

• Length (field VARLNG)

Define the maximum number of characters that must be entered in order to save the parameter.

• Menu (field VARMEN)

When the entry parameter is of the local menu type, the local menu number concerned is entered here.

• Object parameter (field VARPAR)

This field defines an addition required for the definition of the data type, if required. In the case of a miscellaneous table, the addition defines the table number, for example.

• Default value (field VARDEF)

Used to define a default value by means of a calculated expression can contain constants and variables.

• Control (field VARCTL)

A code for a control table can be entered in this field to carryout a specific validity control associated with the parameter defined in the system transaction.

• Formulas (field SELFRM)

This field is used to define the logical expressions to filter the records to be updated or to be deleted. It is possible to use the fields from the principal table, the linked tables and the variables defined in the launch parameters grid in the first tab (V1 to Vn).

If the result of one of these expressions is false, the save will not be carried out.

• Table (field FLDTBL)

Defines the table in which the operation must be carried out.

• Transaction (field FLDSUP)

The operation carried out can be :

• a modification (then numbering of the fields to be modified).
• a deletion (no additional information in the name of the table is to be supplied).
• a creation (in this case, loading the fields record by record).

• Field (field FLD)

Define the field where that is to receive the value (in modification or in creation). This field comes from the entry table on the line.

• Formulas (field FLDFRM)

This formula is evaluated to give the value of the field to be assigned. Fields from online tables, constants as well as the V1 to Vn variables defined in the launch parameters grid in the first tab can be used in this formula.