Display General Table Information (ttaad4500)

Session usage

To view the data in a table:

1. Specify the codes of the package, module, table, and company for which you want to view the table data.
2. Use these check boxes to select how to access the data in the table:
   • DAL ...
   • CM ...
   • Soft Delete ...
   • User Exits/Extensions ...
   • DB Dll ...

   Depending on the selected table, some check boxes may be disabled.

   For example:

   • If the selected table has no DAL, the DAL ... check box is disabled/read-only.

     If the table has a DAL, the DAL ... check box is enabled. If you select the DAL ... check box, the DAL logic is used when you open the table. If you clear the check box, the DAL logic is not used.

   • If the selected table is not marked as Soft Delete, the Soft Delete ... check box is disabled/read-only.

     If the selected table is marked as Soft Delete, the Soft Delete ... check box is enabled. If you select the Soft Delete ... check box, the soft deleted data is displayed when you open the table. If you clear the check box, the soft deleted data is hidden.

3. To access the table fields, click OK. The first record of the table is displayed.

   Depending on the LN security settings, you may be prompted for a password.

Several menus with commands are displayed at the top of your screen. For example, the BROWSE menu contains commands to search and browse records.

CONTROL menu

These options are available:

Change Data Language

Use this command to view the table data in a different Data Language. This is only possible if fields of the table are registered as multi-language fields.

See Multilanguage application data (CE)

Show (not) approved version (CM)

Use this command to switch between approved and not approved CM versions.

In the “Show approved version” mode the records are colored red. In the “Show not approved version” mode the checked-out records are colored green, and the workflow status and object ID (toid) are displayed. Not checked-out records are colored white.

APPLICATION menu

These options are available:

0 Table Information

A window with general table information is displayed.

This information is displayed:

• Table code
• Row/record length
• Number of rows/records
• Number of soft deleted rows/records (in LN UI only)
• Number of indices

  If multiple indices exist, you can change the index:

  • If the session runs in LN UI, select SORT BY to change the index.
• Current index
• Duplicates (y/n)

4 Count Rows

Shows the number of records of the table. You can specify the range of index fields in which you can select the records that are counted.

* Toggle User Mode/Programmers Mode

In programmers mode, detailed information about the table is displayed, such as field codes, field descriptions, data types, and field lengths. This information is useful for programmers.

For most fields, the values in the Value column are identical to the real field values that are stored in the table.

For some fields, the values in the Value column differ from the real field values that are stored in the table. For those fields, in programmers mode, the real field values are displayed.

For example:

• For date fields, the real table values are numbers. In programmers mode, these numbers are displayed below the UTC or date values in the Value column. These numbers are useful to solve issues with date calculations, such as issues with time zones or daylight saving.
• For enumerated fields, the real table values are numbers. For enumerated values where an illegal number is stored, this number is displayed, in red, in the Value column. This number is useful to find the root cause of an issue.