SAP ABAP Data Element IUUC_TRIGGER_STATE (trigger state (initial, created, activated, deactivated))
Hierarchy
☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-EUR (Application Component) European Monetary Union: Euro
     ⤷ CNV_IUUC_REMOTE (Package) Integrated Upgrade & Unicode Conversion: Remote Package
Basic Data
Data Element IUUC_TRIGGER_STATE
Short Description trigger state (initial, created, activated, deactivated)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type IUUC_TRIGGER_STATE    
Data Type NUMC   Character string with only digits 
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 Trg.Status 
Medium 16 Trigger Status 
Long 21 Trigger Status 
Heading 14 Trigger Status 
Documentation

Definition

Indicates which triggers are active for the corresponding table. Possible values.

  • 0 - no triggers activated (initial state)
  • 2 - all necessary DB triggers are active
  • 3 - triggers were previously active but have been deactivated
  • 4 - triggers activated except for the delete trigger
  • 5 - only the insert trigger is activated; update and delete triggers are missing
  • 6 - insert and first update trigger are active, the second update trigger and the delete trigger are missing

Note that the triggers necessary for a table depends on the DB system:

  • Oracle: Only one trigger ("insert trigger") required
  • MS SQL: In case of freeze triggers, only one trigger is required, otherwise three triggers are required
  • MAX DB and DB6: We always need three triggers (insert / update / delete)
  • DB2 and DB4: We need 4 triggers in case of the delta behaviour (distinguish update for key fields and for non-key fields only)

History
Last changed by/on SAP  20141030 
SAP Release Created in 2005_1_471