Query Table Fields (ttadv3586m000)

This session lists the query table fields that you can select for use in a query chart. To select query table fields, either zoom from the Category Column field, or the Data II Column field in the session.

Note: You must first define these query fields in the session.

Field Information

Query Field

The table field code.

A table field is identified by its unique combination of:

Package code
Module code
Table code
Field name

Bind.Var.

If you want to use several functions on the same (non-repeating) table field, you must bind these functions in the text editor. To do this, postfix the functions with a colon and a binding-variable. The binding-variable must be of the form int0..int9 or float0..float9. The int variable displays the result of the function as an integer value, while float displays the result as a floating point number. This means that you cannot use this construction in non-numeric fields.

Example

select

ttaad220.user, min(ttaad220.comp):int0, max(ttaad220.comp):int1

from

ttaad220

group by

ttaad220.user

As output, the query produces a list of users, with the lowest and the highest company numbers they are authorized for.