SAP ABAP Data Element KEYKIND (Key category for table types)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SDTT (Package) DD: Table types

Basic Data

Data Element	KEYKIND
Short Description	Key category for table types

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	KEYKIND
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	4
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Key cat.
Medium	18	Key cat. (coded)
Long	24	Key category of tab.type
Heading	4	KyCt

Documentation

Definition

The following key categories are valid for table types:

• Key is unique
  A table with this table type can only contain records with a unique key.
  
• Key is non-unique
  A table with this table type can also contain records with duplicate keys.
  
• Key is not specified
  A generic table type can be defined with this generic key category.

Only certain key categories are permitted for the individual access modes for table types. The following matrix shows the relationship between the access mode and the key type of a table type:

Access mode: Valid key category:

Any table Not specified
Index table Not specified
Standard table Non-unique
Sorted table Unique / non-unique / not specified
Hashed table Unique

The key and key category have the following dependency:

A table type with a non-specified key always has the key category "not specified". This is also true for standard tables and hash tables for which the key category is otherwise defined as non-unique or unique.

This setting 'not specified' can be used to define a generic table type.

History

Last changed by/on	SAP	20010130
SAP Release Created in