General Table Maintenance (ttaad4100)

Use this session to change table field data without using sessions, which is the correct way. This particular session is meant only for developers.

Caution:

Inappropriate usage can result in data inconsistency!

Note: In a Cloud environment, you cannot edit the user data through General Table Maintenance. The user data is displayed but is read-only.

Session usage

To access the data in a table:

Specify the codes of the package, module, table, and company for which you want to access the table data.
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.
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 APPLICATION menu contains commands that are used for table maintenance.

The use of these commands may deviate from the standard use. For example, after you have selected Global delete you can specify the range in a selection screen (From-To). You do not have to mark records.

Note:

You can view help information by table field. To get table field help, press ?.
If a Soft Deleted record is displayed in the table fields dialog box, the footnote “Soft Deleted” is displayed. The UI mode switches to read-only. These menu options are no longer available:
- MODIFY > Copy Record
- MODIFY > Delete Record
In the Programmers Mode only a limited set of options is available.

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)

1 Copy Rows

You can copy records from another table. You can use certain parameters in a file to copy parts of fields from another table to parts of fields of the current table.

Each line of the parameter file has this syntax:

x y z [expression]

c x y expression

This table shows the meaning of these lines:


Line	Meaning
`x y z [expression]`	Copy position x and length y to position z in the current table. You can also specify an expression behind: `x y z ^abc` This means: copy position x and length y to position z, only if the string `abc' is in the positions x, x+1, and x+2.
`c x y expression`	Only if the expression is true for position x and length y, carry out any action. Skip the record if the expression is false.

Notes:

On the first line the expression is not required, in the second it is.
x, y, and z are values, the character c is the normal character "c".
Expressions only work for string fields.
The maximum number of lines in a parameter file is 50.

2 Export Data

You can export the current table to a sequential file, that is, a compressed dump. Specify a directory to store the dump. Through the command you can import the table into another system.

3 Import Data

You can import a table of another system (environment). Specify the directory in which the dump is stored.

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.

5 Modify Rows

Use this command to modify a range of records in the current table.

6 Remove Rows

Use this command to remove a range of records from the current table.

* 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.