SAP ABAP Data Element VIEW_KEYFL (Flag if field belongs to key)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SMAC (Package) R/3 Matchcode Development

Basic Data

Data Element	VIEW_KEYFL
Short Description	Flag if field belongs to key

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	AS4FLAG
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	1
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
Medium	15	Key field
Long	20	Key field
Heading	3	Key

Documentation

Definition

This indicator shows whether the view field belongs to the key of the view.

The system automatically derives the key of a view from the key fields of the tables involved in the view and the join conditions.

The key is defined so that it satisfies the following requirements:

1. All the key fields must be stored together at the beginning. Fields that do not actually belong to the key but which lie between the key fields are also marked as key fields.
2. All the data records of the view are already unique in the key. If no key can be defined with this attribute, all the fields of the view are marked as key fields.

The key of a view has an effect when accessing the view data with OPEN SQL in ABAP programs. The key plays a direct role for example for SELECT SINGLE and for the supplement ORDER BY PRIMARY KEY, but it also plays an indirect role internally when compressing data with SELECT ... FOR ALL ENTRIES.

History

Last changed by/on	SAP	19980116
SAP Release Created in