SAP table SICL_SHOW_RULES (ICL: Structure for Displaying Rule-Event Assignment)

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
IMPORT_STATUS BRF: Import Status CHAR 1 0 BRF_IMPORT_STATUS
Undefined
9 Set Automatically
A Active
D In Development
I Inactive
T (Active) To Be Exported
U (Inactive) To Be Exported
APPLCLASS BRF: Application Class CHAR 30 0 TBRF100 BRF_APPLCLASS
EVENT Name of Event CHAR 20 0 TBRF110 BRF_EVENT
VERSION BRF: Version NUMC 4 0 BRF_VERSION
PLINEOFBUS Insurance Line of Business CHAR 3 0 TICL007 ICL_LINEOFBUS
CLTYPE Internal Claim Type CHAR 4 0 TICL011 ICL_CLTYPE
EXPRESSION BRF: Expression CHAR 20 0 TBRF150 BRF_EXPRESSION
ACTION Name of Action CHAR 20 0 TBRF170 BRF_ACTION
SEQUENCE_NUMBER Sequence Number NUMC 4 0 BRF_SEQUENCE_NUMBER
REPEAT_ACTION Action to be Repeated CHAR 1 0 ICL_CMC_REPEAT
SEQUENCE Sequence of Actions Within an Event NUMC 3 0 ICL_CMC_ACTIONSEQ
ON_SINGLE_INST Apply Rule in Single Instance Mode (Dialog Mode) CHAR 1 0 BRF_ON_SINGLE_INSTANCE
ON_MULTI_INST Execute Rule in Multi-Instance Mode (Batch Mode) CHAR 1 0 BRF_ON_MULTI_INSTANCE
IGNORE_EVENT_LOG Ignore Event Log CHAR 1 0 BRF_IGNORE_EVENT_LOG
EXPR_GATE BRF: Gate Expression CHAR 20 0 TBRF150 BRF_EXPRESSION_GATE
VALID_FROM Start of Validity of BRFplus Rule in Claims Management Syst. DEC 15 0 ICL_RULE_VALID_FROM
VALID_TO End of Validity of BRFplus Rule in Claims Management System DEC 15 0 ICL_RULE_VALID_TO
REF_DATE_EXPR Reference Date for Processing the Rule CHAR 20 0 TBRF150 ICL_RULE_REF_DATE
REF_TIME_EXPR Reference Time for Processing the Rule CHAR 20 0 TBRF150 ICL_RULE_REF_TIME
REF_TIME_STAMP BRFplus: Reference Date (Time Stamp) DEC 15 0 ICL_REF_TIME_STAMP
CREATED_BY BRF: Version Created by CHAR 12 0 USR02 BRF_CREATED_BY
CREATED_AT Version Created On/At DEC 15 0 BRF_CREATED_AT
CHANGED_BY BRF: Version Changed By CHAR 12 0 USR02 BRF_CHANGED_BY
CHANGED_AT Version Changed On/At DEC 15 0 BRF_CHANGED_AT
DELETED Obsolete (BRF: Mark Entry for Physical Deletion) CHAR 1 0 BRF_XDELETED
CLTYPEN Internal Claim Type Name CHAR 30 0 ICL_CLTYPEN
PLINEOFBUS_SHORT Name of Insurance Line of Business CHAR 30 0 ICL_LINEOFBUSN
CHECK Checkbox CHAR 1 0 BRF_CHECK
EXPRESSION_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
ACTION_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
SINGLE_ACTION Perform Action Just Once CHAR 1 0 BRF_SINGLE_ACTION
EXPR_GATE_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
RULESET BRF Rule Set CHAR 20 0 TBRF280 BRF_RULESET
RULESET_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
RULESET_ROW Space = False, 'X' = True CHAR 1 0 BRF_BOOLE_D
False, No, 0 ...
X True, Yes, 1 ...
CT TTYP 0 0 LVC_T_STYL
REF_DATE_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
REF_TIME_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT
VALID_FROM_DATE Start of Validity of a Rule - Date DATS 8 0 ICL_RULE_VALID_FROM_DATE
VALID_FROM_TIME Start of Validity of a Rule - Time TIMS 6 0 ICL_RULE_VALID_FROM_TIME
VALID_TO_DATE End of Validity of a Rule - Date DATS 8 0 ICL_RULE_VALID_TO_DATE
VALID_TO_TIME End of Validity of a Rule - Time TIMS 6 0 ICL_RULE_VALID_TO_TIME
TEXTSTRING STRG 0 0
EVENT_SHORT BRF: General Short Text CHAR 80 0 BRF_SHORT_TEXT

SICL_SHOW_RULES foreign key relationships

Table Field Check Table Check Field
0 SICL_SHOW_RULES ACTION TBRF170 BRF: Actions CLIENT
0 SICL_SHOW_RULES ACTION TBRF170 BRF: Actions IMPORT_STATUS
0 SICL_SHOW_RULES ACTION TBRF170 BRF: Actions ACTION
0 SICL_SHOW_RULES ACTION TBRF170 BRF: Actions VERSION
1 SICL_SHOW_RULES APPLCLASS TBRF100 BRF: Application Class (Customer-Specific Features) IMPORT_STATUS
0 SICL_SHOW_RULES CHANGED_BY USR02 Logon Data (Kernel-Side Use) BNAME
1 SICL_SHOW_RULES CLIENT T000 Clients MANDT
0 SICL_SHOW_RULES CLTYPE TICL011 Generation of Internal Claim Type VERSION
1 SICL_SHOW_RULES CREATED_BY USR02 Logon Data (Kernel-Side Use) BNAME
0 SICL_SHOW_RULES EVENT TBRF110 BRF: Event CLIENT
0 SICL_SHOW_RULES EVENT TBRF110 BRF: Event .INCLUDE
0 SICL_SHOW_RULES EVENT TBRF110 BRF: Event IMPORT_STATUS
0 SICL_SHOW_RULES EVENT TBRF110 BRF: Event EVENT
1 SICL_SHOW_RULES EXPRESSION TBRF150 BRF: Expression CLIENT
1 SICL_SHOW_RULES EXPRESSION TBRF150 BRF: Expression IMPORT_STATUS
1 SICL_SHOW_RULES EXPRESSION TBRF150 BRF: Expression VERSION
0 SICL_SHOW_RULES EXPR_GATE TBRF150 BRF: Expression CLIENT
0 SICL_SHOW_RULES EXPR_GATE TBRF150 BRF: Expression IMPORT_STATUS
0 SICL_SHOW_RULES EXPR_GATE TBRF150 BRF: Expression VERSION
1 SICL_SHOW_RULES REF_DATE_EXPR TBRF150 BRF: Expression CLIENT
1 SICL_SHOW_RULES REF_DATE_EXPR TBRF150 BRF: Expression IMPORT_STATUS
1 SICL_SHOW_RULES REF_DATE_EXPR TBRF150 BRF: Expression VERSION
0 SICL_SHOW_RULES REF_TIME_EXPR TBRF150 BRF: Expression CLIENT
0 SICL_SHOW_RULES REF_TIME_EXPR TBRF150 BRF: Expression IMPORT_STATUS
0 SICL_SHOW_RULES REF_TIME_EXPR TBRF150 BRF: Expression VERSION
1 SICL_SHOW_RULES RULESET TBRF280 BRF: Rule Set - Header Data CLIENT
1 SICL_SHOW_RULES RULESET TBRF280 BRF: Rule Set - Header Data IMPORT_STATUS
1 SICL_SHOW_RULES RULESET TBRF280 BRF: Rule Set - Header Data VERSION