SAP Table SICL_SHOW_RULES
ICL: Structure for Displaying Rule-Event Assignment
SICL_SHOW_RULES (ICL: Structure for Displaying Rule-Event Assignment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SICL_SHOW_RULES to other SAP tables.
Source: SICL_SHOW_RULES (ICL: Structure for Displaying Rule-Event Assignment)
SICL_SHOW_RULES table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| IMPORT_STATUS | BRF: Import Status | BRF_IMPORT_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| APPLCLASS | BRF: Application Class | BRF_APPLCLASS | TBRF100 | CHAR | 30 | 0 | ||||||||||||||||
| EVENT | Name of Event | BRF_EVENT | TBRF110 | CHAR | 20 | 0 | ||||||||||||||||
| VERSION | BRF: Version | BRF_VERSION | NUMC | 4 | 0 | |||||||||||||||||
| PLINEOFBUS | Insurance Line of Business | ICL_LINEOFBUS | TICL007 | CHAR | 3 | 0 | ||||||||||||||||
| CLTYPE | Internal Claim Type | ICL_CLTYPE | TICL011 | CHAR | 4 | 0 | ||||||||||||||||
| EXPRESSION | BRF: Expression | BRF_EXPRESSION | TBRF150 | CHAR | 20 | 0 | ||||||||||||||||
| ACTION | Name of Action | BRF_ACTION | TBRF170 | CHAR | 20 | 0 | ||||||||||||||||
| SEQUENCE_NUMBER | Sequence Number | BRF_SEQUENCE_NUMBER | NUMC | 4 | 0 | |||||||||||||||||
| REPEAT_ACTION | Action to be Repeated | ICL_CMC_REPEAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| SEQUENCE | Sequence of Actions Within an Event | ICL_CMC_ACTIONSEQ | NUMC | 3 | 0 | |||||||||||||||||
| ON_SINGLE_INST | Apply Rule in Single Instance Mode (Dialog Mode) | BRF_ON_SINGLE_INSTANCE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| ON_MULTI_INST | Execute Rule in Multi-Instance Mode (Batch Mode) | BRF_ON_MULTI_INSTANCE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| IGNORE_EVENT_LOG | Ignore Event Log | BRF_IGNORE_EVENT_LOG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| EXPR_GATE | BRF: Gate Expression | BRF_EXPRESSION_GATE | TBRF150 | CHAR | 20 | 0 | ||||||||||||||||
| VALID_FROM | Start of Validity of BRFplus Rule in Claims Management Syst. | ICL_RULE_VALID_FROM | DEC | 15 | 0 | |||||||||||||||||
| VALID_TO | End of Validity of BRFplus Rule in Claims Management System | ICL_RULE_VALID_TO | DEC | 15 | 0 | |||||||||||||||||
| REF_DATE_EXPR | Reference Date for Processing the Rule | ICL_RULE_REF_DATE | TBRF150 | CHAR | 20 | 0 | ||||||||||||||||
| REF_TIME_EXPR | Reference Time for Processing the Rule | ICL_RULE_REF_TIME | TBRF150 | CHAR | 20 | 0 | ||||||||||||||||
| REF_TIME_STAMP | BRFplus: Reference Date (Time Stamp) | ICL_REF_TIME_STAMP | DEC | 15 | 0 | |||||||||||||||||
| CREATED_BY | BRF: Version Created by | BRF_CREATED_BY | USR02 | CHAR | 12 | 0 | ||||||||||||||||
| CREATED_AT | Version Created On/At | BRF_CREATED_AT | DEC | 15 | 0 | |||||||||||||||||
| CHANGED_BY | BRF: Version Changed By | BRF_CHANGED_BY | USR02 | CHAR | 12 | 0 | ||||||||||||||||
| CHANGED_AT | Version Changed On/At | BRF_CHANGED_AT | DEC | 15 | 0 | |||||||||||||||||
| DELETED | Obsolete (BRF: Mark Entry for Physical Deletion) | BRF_XDELETED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| CLTYPEN | Internal Claim Type Name | ICL_CLTYPEN | CHAR | 30 | 0 | |||||||||||||||||
| PLINEOFBUS_SHORT | Name of Insurance Line of Business | ICL_LINEOFBUSN | CHAR | 30 | 0 | |||||||||||||||||
| CHECK | Checkbox | BRF_CHECK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| EXPRESSION_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| ACTION_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| SINGLE_ACTION | Perform Action Just Once | BRF_SINGLE_ACTION | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| EXPR_GATE_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| RULESET | BRF Rule Set | BRF_RULESET | TBRF280 | CHAR | 20 | 0 | ||||||||||||||||
| RULESET_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| RULESET_ROW | Space = False, 'X' = True | BRF_BOOLE_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| CT | LVC_T_STYL | TTYP | 0 | 0 | ||||||||||||||||||
| REF_DATE_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| REF_TIME_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
| VALID_FROM_DATE | Start of Validity of a Rule - Date | ICL_RULE_VALID_FROM_DATE | DATS | 8 | 0 | |||||||||||||||||
| VALID_FROM_TIME | Start of Validity of a Rule - Time | ICL_RULE_VALID_FROM_TIME | TIMS | 6 | 0 | |||||||||||||||||
| VALID_TO_DATE | End of Validity of a Rule - Date | ICL_RULE_VALID_TO_DATE | DATS | 8 | 0 | |||||||||||||||||
| VALID_TO_TIME | End of Validity of a Rule - Time | ICL_RULE_VALID_TO_TIME | TIMS | 6 | 0 | |||||||||||||||||
| TEXTSTRING | STRG | 0 | 0 | |||||||||||||||||||
| EVENT_SHORT | BRF: General Short Text | BRF_SHORT_TEXT | CHAR | 80 | 0 | |||||||||||||||||
SICL_SHOW_RULES foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SICL_SHOW_RULES | ACTION | SICL_SHOW_RULES | CLIENT | TBRF170 | BRF: Actions | CLIENT |
| SICL_SHOW_RULES | ACTION | 'A' | TBRF170 | BRF: Actions | IMPORT_STATUS | |
| SICL_SHOW_RULES | ACTION | 'ICL' | TBRF170 | BRF: Actions | APPLCLASS | |
| SICL_SHOW_RULES | ACTION | SICL_SHOW_RULES | ACTION | TBRF170 | BRF: Actions | ACTION |
| SICL_SHOW_RULES | ACTION | '0000' | TBRF170 | BRF: Actions | VERSION | |
| SICL_SHOW_RULES | APPLCLASS | SICL_SHOW_RULES | IMPORT_STATUS | TBRF100 | BRF: Application Class (Customer-Specific Features) | IMPORT_STATUS |
| SICL_SHOW_RULES | APPLCLASS | SICL_SHOW_RULES | CLIENT | TBRF100 | BRF: Application Class (Customer-Specific Features) | CLIENT |
| SICL_SHOW_RULES | APPLCLASS | SICL_SHOW_RULES | APPLCLASS | TBRF100 | BRF: Application Class (Customer-Specific Features) | APPLCLASS |
| SICL_SHOW_RULES | CHANGED_BY | SICL_SHOW_RULES | CHANGED_BY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| SICL_SHOW_RULES | CHANGED_BY | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| SICL_SHOW_RULES | CLIENT | SICL_SHOW_RULES | CLIENT | T000 | Clients | MANDT |
| SICL_SHOW_RULES | CLTYPE | * | TICL011 | Generation of Internal Claim Type | VERSION | |
| SICL_SHOW_RULES | CLTYPE | SICL_SHOW_RULES | CLTYPE | TICL011 | Generation of Internal Claim Type | CLTYPE |
| SICL_SHOW_RULES | CLTYPE | SICL_SHOW_RULES | CLIENT | TICL011 | Generation of Internal Claim Type | CLIENT |
| SICL_SHOW_RULES | CREATED_BY | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| SICL_SHOW_RULES | CREATED_BY | SICL_SHOW_RULES | CREATED_BY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| SICL_SHOW_RULES | EVENT | SICL_SHOW_RULES | CLIENT | TBRF110 | BRF: Event | CLIENT |
| SICL_SHOW_RULES | EVENT | SICL_SHOW_RULES | IMPORT_STATUS | TBRF110 | BRF: Event | .INCLUDE |
| SICL_SHOW_RULES | EVENT | SICL_SHOW_RULES | APPLCLASS | TBRF110 | BRF: Event | IMPORT_STATUS |
| SICL_SHOW_RULES | EVENT | SICL_SHOW_RULES | EVENT | TBRF110 | BRF: Event | APPLCLASS |
| SICL_SHOW_RULES | EVENT | SICL_SHOW_RULES | VERSION | TBRF110 | BRF: Event | EVENT |
| SICL_SHOW_RULES | EXPRESSION | 'A' | TBRF150 | BRF: Expression | IMPORT_STATUS | |
| SICL_SHOW_RULES | EXPRESSION | SICL_SHOW_RULES | CLIENT | TBRF150 | BRF: Expression | CLIENT |
| SICL_SHOW_RULES | EXPRESSION | 'ICL' | TBRF150 | BRF: Expression | APPLCLASS | |
| SICL_SHOW_RULES | EXPRESSION | SICL_SHOW_RULES | EXPRESSION | TBRF150 | BRF: Expression | EXPRESSION |
| SICL_SHOW_RULES | EXPRESSION | '0000' | TBRF150 | BRF: Expression | VERSION | |
| SICL_SHOW_RULES | EXPR_GATE | SICL_SHOW_RULES | CLIENT | TBRF150 | BRF: Expression | CLIENT |
| SICL_SHOW_RULES | EXPR_GATE | 'A' | TBRF150 | BRF: Expression | IMPORT_STATUS | |
| SICL_SHOW_RULES | EXPR_GATE | 'ICL' | TBRF150 | BRF: Expression | APPLCLASS | |
| SICL_SHOW_RULES | EXPR_GATE | SICL_SHOW_RULES | EXPR_GATE | TBRF150 | BRF: Expression | EXPRESSION |
| SICL_SHOW_RULES | EXPR_GATE | '0000' | TBRF150 | BRF: Expression | VERSION | |
| SICL_SHOW_RULES | PLINEOFBUS | SICL_SHOW_RULES | CLIENT | TICL007 | Insurance Line of Business | CLIENT |
| SICL_SHOW_RULES | PLINEOFBUS | SICL_SHOW_RULES | PLINEOFBUS | TICL007 | Insurance Line of Business | PLINEOFBUS |
| SICL_SHOW_RULES | REF_DATE_EXPR | SICL_SHOW_RULES | REF_DATE_EXPR | TBRF150 | BRF: Expression | EXPRESSION |
| SICL_SHOW_RULES | REF_DATE_EXPR | * | TBRF150 | BRF: Expression | APPLCLASS | |
| SICL_SHOW_RULES | REF_DATE_EXPR | SICL_SHOW_RULES | IMPORT_STATUS | TBRF150 | BRF: Expression | IMPORT_STATUS |
| SICL_SHOW_RULES | REF_DATE_EXPR | SICL_SHOW_RULES | CLIENT | TBRF150 | BRF: Expression | CLIENT |
| SICL_SHOW_RULES | REF_DATE_EXPR | SICL_SHOW_RULES | VERSION | TBRF150 | BRF: Expression | VERSION |
| SICL_SHOW_RULES | REF_TIME_EXPR | SICL_SHOW_RULES | CLIENT | TBRF150 | BRF: Expression | CLIENT |
| SICL_SHOW_RULES | REF_TIME_EXPR | SICL_SHOW_RULES | IMPORT_STATUS | TBRF150 | BRF: Expression | IMPORT_STATUS |
| SICL_SHOW_RULES | REF_TIME_EXPR | 'ICL' | TBRF150 | BRF: Expression | APPLCLASS | |
| SICL_SHOW_RULES | REF_TIME_EXPR | SICL_SHOW_RULES | REF_TIME_EXPR | TBRF150 | BRF: Expression | EXPRESSION |
| SICL_SHOW_RULES | REF_TIME_EXPR | SICL_SHOW_RULES | VERSION | TBRF150 | BRF: Expression | VERSION |
| SICL_SHOW_RULES | RULESET | SICL_SHOW_RULES | APPLCLASS | TBRF280 | BRF: Rule Set - Header Data | APPLCLASS |
| SICL_SHOW_RULES | RULESET | SICL_SHOW_RULES | RULESET | TBRF280 | BRF: Rule Set - Header Data | RULESET |
| SICL_SHOW_RULES | RULESET | '0000' | TBRF280 | BRF: Rule Set - Header Data | VERSION | |
| SICL_SHOW_RULES | RULESET | 'A' | TBRF280 | BRF: Rule Set - Header Data | IMPORT_STATUS | |
| SICL_SHOW_RULES | RULESET | SICL_SHOW_RULES | CLIENT | TBRF280 | BRF: Rule Set - Header Data | CLIENT |
