SAP ABAP Data Element RSBGENKEY (Open Hub: Indicator for Technical Key)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-WHM-DBA (Application Component) Data Basis
     RSB (Package) Business Information Warehouse: Data Marts
Basic Data
Data Element RSBGENKEY
Short Description Open Hub: Indicator for Technical Key  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type RSBGENKEY    
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 Tech. Key 
Medium 20 Technical Key 
Long 32 Technical Key 
Heading 32 Generate Technical Key 
Documentation

Definition

The "technical key" indicator is an attribute of the open hub destination type DB table. If the indicator is set, the field list of tables for the OHREQUID, DATAPAKID, and RECORD technical fields are added. These fields display the only key fields for the table and include the open hub request SID, the data package ID, or the current number of one of the data records added to the table within a data package. All three fields are type INT4.

Use

A target table with a technical key is useful in the following cases:

  1. Delta extraction from DataStore objects: Here the data is read in the change log, in which several records with different RECORDMODEs can exist for a specific semantic key (after-/before-image). The extraction into a table with the semantic key of a DataStore object generally leads produces duplicate records (Duprec) and ultimately a short dump.
  2. Another example is the extraction in full mode into a table that is not to be deleted before extraction.
  3. If the source has more than 16 key fields, then no DB table can be created with these key fields. Therefore, the table also has to have a technical key.

Dependencies

Example

History
Last changed by/on SAP  20130604 
SAP Release Created in 400