Hierarchy
⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
⤷ SDTT (Package) DD: Table types
Basic Data
Data Element | ACCMODETXT |
Short Description | Text representation of access modes for table types |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | DDTEXT | |
Data Type | CHAR | Character String |
Length | 60 | |
Decimal Places | 0 | |
Output Length | 60 | |
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 | AM |
Medium | 15 | Access Mode |
Long | 20 | Access Mode |
Heading | 2 | AM |
Documentation
Definition
There are the following access modes for table types:
- Standard table
The key access to a standard table uses a linear search. Index operations should normally be used for accessing. - Sorted table
A sorted table is always kept sorted internally. The key access uses a binary search. If the key is not unique, the operation is on the entry with the lowest index. - Hash table
The table is managed internally with a hash procedure. In contrast to standard tables and sorted tables, you cannot access hash tables with an index. All entries must have a unique key.
You can also define a generic table type with generic access modes:
- Index table
An index table can be a standard table or a sorted table. Index access is allowed for such tables. - Any table (access mode not specified)
Any table can be a standard table, a sorted table or a hash table. The valid operations for such a table are the set of all valid operations for the different access modes. You cannot access tables of this type with an index.
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 |