SAP ABAP Class CL_IUUC_TRIGGER_CREATION (trigger creation methods)
Hierarchy
DMIS (Software Component) DMIS 2011_1
   CA-EUR (Application Component) European Monetary Union: Euro
     CNV_INC_PROCESSING_REMOTE (Package) tools for logging table and trigger creation in sender syst.
Properties
Class CL_IUUC_TRIGGER_CREATION  
Short Description trigger creation methods    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package CNV_INC_PROCESSING_REMOTE   tools for logging table and trigger creation in sender syst. 
Created 20110801   SAP 
Last change 20141030    
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_IUUC_TRIGGER_CREATION has no interface implemented.
Friends
Class CL_IUUC_TRIGGER_CREATION has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 CO_TRIGGER_ACTIVE Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '2' trigger state (initial, created, activated, deactivated) 20120207
2 CO_TRIGGER_DEACTIVATED Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '3' trigger state (initial, created, activated, deactivated) 20120207
3 CO_TRIGGER_INITIAL Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '0' trigger state (initial, created, activated, deactivated) 20120207
4 CO_TRIGGER_NOT_USED Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '1' trigger state (initial, created, activated, deactivated) 20120207
5 CO_TRIGGER_NO_DELETE Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '4' trigger state (initial, created, activated, deactivated) 20120207
6 CO_TRIGGER_NO_DEL_UPD Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '5' trigger state (initial, created, activated, deactivated) 20120207
7 CO_TRIGGER_NO_DEL_UPD2 Constant Public Type reference (TYPE) IUUC_TRIGGER_STATE '6' trigger state (initial, created, activated, deactivated) 20120207
Methods
# Method Level Visibility Method type Description Created on
1 ADD_CLIENT_CONDITION Static method Public Method Add trigger condition for cllient field 20110926
2 ADD_COND_PAGENO_SRTF2 Static method Public Method Add trigger condition for PAGENO or SRTF2 20120522
3 ADD_DB_OPERAT_CONDITION Static method Public Method Add condition for specific DB operation (Oracle only) 20120419
4 ADD_FREEZE_CONDITION Static method Public Method add coding for mixed trigger: DB6 20130621
5 ADD_TRIGGER_CONDITION_CODE Static method Public Method add condition for trigger invocation 20110801
6 CREATE_DB2_ARCHDEL_FUNCTION Static method Public Method create a stored procedure for archive delete for DB2 20130327
7 DB_DROP_TRIGGER Static method Public Method drop trigger from DB system 20111202
8 DELETE_OUTDATED_LOGTAB_RECORDS Static method Public Method delete logging table records that were created before last t 20130729
9 GET_OUTDATED_SEQUENCE_NUMBER Static method Private Method delete logging table records that were created before last t 20130729
10 GET_TRIGGER_NAMES Static method Public Method get trigger names of IUUC triggers 20111202
11 MIXED_TRIGGER_DB2 Static method Private Method add coding for mixed trigger: DB2 20120307
12 MIXED_TRIGGER_DB6 Static method Private Method add coding for mixed trigger: DB6 20120307
13 MIXED_TRIGGER_HDB Static method Private Method add coding for mixed trigger: MAX DB 20130116
14 MIXED_TRIGGER_MAXDB Static method Private Method add coding for mixed trigger: MAX DB 20120307
15 MIXED_TRIGGER_MSSQL Static method Private Method add coding for mixed trigger: MS SQL 20120307
16 MIXED_TRIGGER_ORACLE Static method Private Method add coding for mixed trigger: Oracle 20120307
17 TRIGGER_COND_DB2 Static method Private Method add trigger condition for DB2 (insert + delete) 20110801
18 TRIGGER_COND_DB2_UPD Static method Private Method add trigger condition for DB2 (update) 20110801
19 TRIGGER_COND_DB6 Static method Private Method add trigger condition for DB2 (insert + delete) 20110922
20 TRIGGER_COND_HDB Static method Private Method add trigger condition for HDB 20130116
21 TRIGGER_COND_MAXDB Static method Private Method add trigger condition for MAX DB 20110801
22 TRIGGER_COND_MSSQL Static method Private Method add trigger condition for MS SQL 20110801
23 TRIGGER_COND_ORA Static method Private Method add trigger condition for Oracle 20110801
Events
Class CL_IUUC_TRIGGER_CREATION has no event.
Types
Class CL_IUUC_TRIGGER_CREATION has no local type.
Method Signatures

Method ADD_CLIENT_CONDITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110926
2 Importing I_TABCLASS Call by reference Type reference (TYPE) TABCLASS Table category 20121206
3 Importing I_TABNAME Call by reference Type reference (TYPE) TABNAME Table Name 20110926

Method ADD_CLIENT_CONDITION on class CL_IUUC_TRIGGER_CREATION has no exception.

Method ADD_COND_PAGENO_SRTF2 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120522
2 Importing I_TABCLASS Call by reference Type reference (TYPE) IUUC_TABCLASS TABCLASS 20120522

Method ADD_COND_PAGENO_SRTF2 on class CL_IUUC_TRIGGER_CREATION has no exception.

Method ADD_DB_OPERAT_CONDITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120419
2 Importing I_DB_OPERAT Call by reference Type reference (TYPE) IUUC_OPERATION Table Name 20120419

Method ADD_DB_OPERAT_CONDITION on class CL_IUUC_TRIGGER_CREATION has no exception.

Method ADD_FREEZE_CONDITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130621
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130621
3 Importing IV_INS_DEL_UPD Call by reference Type reference (TYPE) CHAR1 3-Byte field 20130621
4 Importing IV_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20130621
5 Importing IV_SCENARIO Call by reference Type reference (TYPE) DDSCENARIO 20130621
6 Importing IV_TABNAME Call by reference Type reference (TYPE) TABNAME Table Name 20130621
7 Importing IV_TRIGNAME Call by reference Type reference (TYPE) DDIUPDTRI Name of update trigger 20130621

Method ADD_FREEZE_CONDITION on class CL_IUUC_TRIGGER_CREATION has no exception.

Method ADD_TRIGGER_CONDITION_CODE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20110801
5 Importing I_OPERATION_TYPE Call by reference Type reference (TYPE) CHAR1 Single-Character Flag 20110801

Method ADD_TRIGGER_CONDITION_CODE on class CL_IUUC_TRIGGER_CREATION has no exception.

Method CREATE_DB2_ARCHDEL_FUNCTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_SQL_ERRORTEXT Call by reference Type reference (TYPE) DBSQLMSG SQL Error Message 20130327
2 Importing IV_CREATE_FUNCTION Call by reference Type reference (TYPE) BOOLEAN 'X' boolean variable (X=true, -=false, space=unknown) 20130328
3 Importing IV_DB_CONNECTION Call by reference Type reference (TYPE) DBCON_NAME 'R/3*' Logical name for a database connection 20130327
4 Importing IV_DELETE_FUNCTION Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20130328
5 Importing IV_FUNCTION_NAME Call by reference Type reference (TYPE) DDOBJNAME 'IUUC_ARCDEL_FUNCT' Name of an ABAP Dictionary object 20130327

Method CREATE_DB2_ARCHDEL_FUNCTION on class CL_IUUC_TRIGGER_CREATION has no exception.

Method DB_DROP_TRIGGER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_SUBRC Call by reference Type reference (TYPE) SYSUBRC Return Value, Return Value After ABAP Statements 20111202
2 Importing I_TABNAME Call by reference Type reference (TYPE) TABNAME Table Name 20111202
3 Importing I_TRIGGER_NAME Call by reference Type reference (TYPE) DDIINSTRI Name of current insert trigger 20111202

Method DB_DROP_TRIGGER on class CL_IUUC_TRIGGER_CREATION has no exception.

Method DELETE_OUTDATED_LOGTAB_RECORDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_SEQUENCE_DEC Call by reference Type reference (TYPE) IUUC_SEQUENCE_DEC loging table iuuc_sequence DEC type 20130809
2 Exporting EV_SEQUENCE_RAW Call by reference Type reference (TYPE) IUUC_SEQUENCE_RAW sequence type RAW 20130809
3 Importing IO_SQL_CONNECTION Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20130730
4 Importing IV_DELETE_RECORDS Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20130809
5 Importing IV_LOGTAB_NAME Call by reference Type reference (TYPE) TABNAME Table Name 20130729
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20130730

Method GET_OUTDATED_SEQUENCE_NUMBER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_SEQUENCE_DEC Call by reference Type reference (TYPE) IUUC_SEQUENCE_DEC Database Time in ms 20130729
2 Exporting EV_SEQUENCE_RAW Call by reference Type reference (TYPE) IUUC_SEQUENCE_RAW sequence type RAW 20130729
3 Importing IO_SQL_CONNECTION Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20130730
4 Importing IV_LOGTAB_NAME Call by reference Type reference (TYPE) TABNAME Table Name 20130729
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Exception Class for SQL Error 20130730

Method GET_TRIGGER_NAMES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_DEL_TRIG Call by reference Type reference (TYPE) DDIDELTRI Name of an ABAP Dictionary object 20111202
2 Exporting E_INS_TRIG Call by reference Type reference (TYPE) DDIINSTRI Name of an ABAP Dictionary object 20111202
3 Exporting E_UPD1_TRIG Call by reference Type reference (TYPE) DDIUPDTRI Name of an ABAP Dictionary object 20111202
4 Exporting E_UPD2_TRIG Call by reference Type reference (TYPE) DDIUPDTRI Name of an ABAP Dictionary object 20111202
5 Importing I_LOGTAB_NAME Call by reference Type reference (TYPE) DDOBJNAME logging table name 20111202
6 Importing I_PROCESS_OPTION Call by reference Type reference (TYPE) NUM1 process option 20111202
7 Importing I_TEMP_TRIGGER Call by reference Type reference (TYPE) BOOLEAN is trigger temporary? 20111202

Method GET_TRIGGER_NAMES on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_DB2 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
3 Importing I_INS_DEL_UPD Call by reference Type reference (TYPE) CHAR1 3-Byte field 20120307
4 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20120307
5 Importing I_TABNAME Call by reference Type reference (TYPE) TABNAME Table Name 20120307
6 Importing I_TRIG_NAME Call by reference Type reference (TYPE) DDIUPDTRI Name of update trigger 20120307

Method MIXED_TRIGGER_DB2 on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_DB6 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
3 Importing I_INS_DEL_UPD Call by reference Type reference (TYPE) CHAR1 3-Byte field 20120307
4 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20120307
5 Importing I_SCENARIO Call by reference Type reference (TYPE) DDSCENARIO 20120307

Method MIXED_TRIGGER_DB6 on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_HDB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130116
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130116
3 Importing I_OLD_NEW Call by reference Type reference (TYPE) CHAR3 3-Byte field 20130116
4 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20130116

Method MIXED_TRIGGER_HDB on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_MAXDB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
3 Importing I_OLD_NEW Call by reference Type reference (TYPE) CHAR3 3-Byte field 20120307
4 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20120307

Method MIXED_TRIGGER_MAXDB on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_MSSQL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
3 Importing I_INS_DEL Call by reference Type reference (TYPE) CHAR1 3-Byte field 20120307
4 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20120307

Method MIXED_TRIGGER_MSSQL on class CL_IUUC_TRIGGER_CREATION has no exception.

Method MIXED_TRIGGER_ORACLE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENTS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
2 Importing IT_SPECIFIC_CONDITIONS Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20120307
3 Importing I_PHASE Call by reference Type reference (TYPE) IUUC_FREEZE_PHASE phase in which trigger is to be changed from delta to freeze 20120307

Method MIXED_TRIGGER_ORACLE on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_DB2 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20110801

Method TRIGGER_COND_DB2 on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_DB2_UPD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914

Method TRIGGER_COND_DB2_UPD on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_DB6 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110922
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110922
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110922
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20110922

Method TRIGGER_COND_DB6 on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_HDB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130116
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20130116
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20130116
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20130116

Method TRIGGER_COND_HDB on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_MAXDB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20110801

Method TRIGGER_COND_MAXDB on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_MSSQL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914
4 Importing I_DELETE Call by reference Type reference (TYPE) BOOLEAN boolean variable (X=true, -=false, space=unknown) 20110801

Method TRIGGER_COND_MSSQL on class CL_IUUC_TRIGGER_CREATION has no exception.

Method TRIGGER_COND_ORA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_CODE Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
2 Importing IT_CONDITION Call by reference Type reference (TYPE) ABAPPROG Table Type for ABAP Programs 20110801
3 Importing I_ACTIVE_MT_ID Call by reference Type reference (TYPE) CHAR3 activation switch for Mass Transfer 20110914

Method TRIGGER_COND_ORA on class CL_IUUC_TRIGGER_CREATION has no exception.
History
Last changed by/on SAP  20141030 
SAP Release Created in 2010_1_620