Procedure documentation Defining Miscellaneous Information Locate the document in its SAP Library structure

Under Misc you can enter the following additional information for your table.

Entry

Meaning

Comment

Comment

Duplicates

You can use the DUPLICATES clause to control behavior if key collisions occur.

Statistics

Sample Value specifies how large the portion of data is that is included for optimization of the database strategy.

Temporary Table

Ignore Rollback

The table is a temporary table and is saved locally under Temp. For temporary tables, you can specify the option Ignore Rollback.

Identifiers Upper Case

Automatic conversion of table names, column headers and other names into upper case.

Caution

A change to this setting affects the entire table definition immediately.

If you use a database table as a template for the creation of another database table, the user setting is copied from the template.

Note

For information on the syntax of CREATE TABLE statements, see the Structure linkCREATE TABLE-Statement section of the Reference Manual: SAP DB.