Key fields

Concepts > Keyfields

All entries have a key field.

Example: for items: the item code, for Business partner: the card code and so on.

A key field must be a unique key.

Upper/lower letters

HANA checks upper/lower letters. Example: FP123 is not fp123.

MSSQL does not check upper/lower letters. Example: FP123 is fp123

The system tries to reduce the problem. If FP123 is defined and you insert FP123, the system replaces it automatically to FP123.

Beas does not allow to define the same key words width different upper/lower formats. But the system does not check this in all places.

Special characters

It is only allowed to use the following characters in key fields: 0-9, A-Z, a-z, _!$&/%()[]{}?\*+';:.-^°

But not Unicode - other special symbols as ' " = , or spaces.

Examples

NYM4,4 --> wrong

NYM4.4 --> correct

NYM 5" --> wrong

NYM 5´´ --> correct

Note: You can insert all signs in the entry description, but not in the key field.