SAP ABAP Table ICLE_BULKSBR_SCR_ITEM (Collective Subrogatn: Completely Formatted Single Data f.GUI)
Hierarchy
INSURANCE (Software Component) SAP Insurance
   FS-CM (Application Component) Claims Management
     ICL_EVENT (Package) FS-CM: Claim Bundle
Basic Data
Table Category INTTAB    Structure 
Structure ICLE_BULKSBR_SCR_ITEM   Table Relationship Diagram
Short Description Collective Subrogatn: Completely Formatted Single Data f.GUI    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 SEL XFELD XFELD CHAR 1   0   Checkbox  
2 .INCLUDE       0   0   Collective Subrogatn: Completely Formatted Bundle Data f.GUI  
3 .INCLUDE       0   0   Claim Bundle  
4 CLIENT MANDT MANDT CLNT 3   0   Client T000
5 ACTIVE ICL_ACTIVE ICL_ACTIVE CHAR 1   0   Table entry is active (A) or in suspense (S)  
6 CCEVENT ICL_CCEVENT ICL_CCEVENT CHAR 17   0   Claim Bundle *
7 .INCLUDE       0   0   Shadow Tables Versioning: Include for Original Table  
8 CHANGETIME ICL_CHANGEUTC1 ICL_TIMESTAMP DEC 15   0   Changed: UTC Date+Time  
9 CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
10 DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
11 .INCLUDE       0   0   Claim Bundle  
12 .INCLUDE       0   0   Organizational Include (Short Version)  
13 CREATEDBY ICL_CREATEDBY XUBNAME CHAR 12   0   Created By USR02
14 CREATETIME ICL_CREATEUTC ICL_TIMESTAMP DEC 15   0   Created: UTC Date+Time  
15 CCTYPE ICL_CCEVENTCAT ICL_CCEVENTCAT CHAR 2   0   Claim Bundle Type TICL001
16 SUBTYPE ICL_CCEVENTTY ICL_CCEVENTTY CHAR 2   0   Subtype of Claim Bundle Type TICL002
17 CURR ICL_CCEVENTCUR WAERS CUKY 5   0   Currency of Claim Bundle Reserve TCURC
18 LIMIT ICL_CCEVENTLIM ICL_TOAMT CURR 17   2   Claim Bundle Compensation Reserve  
19 LIMITE ICL_CCEVENTLIME   CURR 17   2   Claim Bundle Expenses Reserve  
20 CODE ICL_CCEVENTCODE CHAR12 CHAR 12   0   External Name for Claim Bundle  
21 NAME ICL_CCEVENTNAME TEXT20 CHAR 20   0   Name of Claim Bundle  
22 RANGEFROM ICL_CCEVENTFROM DATE DATS 8   0   Event Period: Date From  
23 RANGETO ICL_CCEVENTTO DATE DATS 8   0   Event Period: Date To  
24 HOTLINE ICL_CCEVENTTEL CHAR30 CHAR 30   0   Coordinator phone number  
25 LOCATYPE ICL_CCEVENTLOCA ICL_LOCTYPE NUMC 1   0   Define Location via Region '1', Postal Code '2', Address '3'  
26 STATUS ICLE_BUNDLE_STATUS_D ICL_STATUS CHAR 2   0   Status of Claim Bundle TICL140
27 BUNDLECAUSE ICL_BUNDLECAUSE ICL_BUNDLECAUSE CHAR 3   0   Reason for Creation of Claim Bundle TICL012
28 OWNER ICL_BUNDLEOWNER XUBNAME CHAR 12   0   Claim Bundle Handler USR02
29 INVOICEREF_BULK ICL_INVOICEREF_BULK CHAR16 CHAR 16   0   External Collective Invoice Number  
30 EXTERNALREF_BULK ICL_EXTERNALREF_BULK ICL_EXTERNALREF_BULK CHAR 20   0   External Collective Reference  
31 ISSUEDATE ICL_ISSUEDATE_INVBULK DATS DATS 8   0   Collective Invoice Date  
32 AMOUNT_TOTAL ICL_AMOUNT_BULKINV_TOTAL ICL_AMOUNT CURR 15   2   Net Total Amount of Collective Invoice (acc. to Coll.Inv.)  
33 PAYMENTLEVEL ICL_PAYMENTLEVEL ICL_PAYMENTLEVEL NUMC 1   0   Payment Level of a Collective Invoice  
34 DATASOURCE ICL_DATASOURCE ICL_DATASOURCE CHAR 2   0   Data Origin TICL136
35 RECEIVEDATE ICL_RECEIVEDATE DATS DATS 8   0   Date Received  
36 CLMINPROCESS ICL_CLMSTATUS_INPROCESS XFELD CHAR 1   0   Dependent Claim Exists with Status "In Process"  
37 RELEASED ICL_STATUS_RELEASED XFELD CHAR 1   0   Status "Released"  
38 CANCEL ICL_STATUS_CANCEL XFELD CHAR 1   0   Status "Cancelled"  
39 INPROCESS ICL_STATUS_INPROCESS XFELD CHAR 1   0   Status "In Process"  
40 CLMINPROC_CNTR ICL_CLMSTATUS_INPROCESS_CNTR ICL_CLMSTATUS_INPROCESS_CNTR INT4 10   0   Counter for Number of Open Claims  
41 STHANDLER ICLE_STHANDLER XFELD CHAR 1   0   "Bundle Processing" Process Is Active  
42 WF_STATUS ICL_WF_STATUS ICL_WF_STATUS NUMC 1   0   Workflow Status  
43 .INCLUDE       0   0   Collective Subrogation: Special Attributes  
44 CCSBRBNDL ICL_CCSBRBNDL ICL_CCEVENT CHAR 17   0   Number of Collective Subrogation/Recovery ICLCCEVENT
45 CCSBRTYPE ICL_CCSBRTYPE ICL_CCSBRTYPE CHAR 2   0   Subrogation Claim Type in Subrogation TICL177
46 CHREASONSBR ICL_CHREASONSBR ICL_CHREASONSBR CHAR 2   0   Change Reason for Status of Collective Subrogation/Recovery TICL175
47 BILLINGDATE ICL_BILLINGDATE DATE DATS 8   0   Next Billing Date  
48 RESUBDATE ICL_RESUBDATE DATE DATS 8   0   Date of Resubmission  
49 SBRNOTIFDATE ICL_SBRNOTIFDATE DATE DATS 8   0   Date on Which Subrogation Claim Was Reported  
50 .INCLUDE       0   0   Collective Subrogation: Special Attributes (only for GUI)  
51 BULKSBR ICL_BULKSBR ICL_BULKSBR CHAR 3   0   Number of Collective Subrogation/Recovery Settlement *
52 CCTYPEN ICL_CCEVENTCATN TEXT25 CHAR 25   0   Name of Claim Bundle Type  
53 CCSUBTYPEN ICL_CCEVENTTYN TEXT25 CHAR 25   0   Name of Subtype of Claim Bundle Type  
54 INSURED ICL_INSURED BU_PARTNER CHAR 10   0   Insured Person BUT000
55 DESCRIP BU_DESCRIP BU_TEXT50 CHAR 50   0   Short name of business partner  
56 DATELOSS ICL_LOSSDATE DATE DATS 8   0   Date of Loss/Claim  
57 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
58 LANDX LANDX TEXT15 CHAR 15   0   Country Name  
59 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
60 BEZEI BEZEI20 TEXT20 CHAR 20   0   Description  
61 CLAIMTYPE ICL_CLTYPE ICL_CLTYPE CHAR 4   0   Internal Claim Type TICL011
62 CLTYPEN ICL_CLTYPEN TEXT30 CHAR 30   0   Internal Claim Type Name  
63 POLPROD ICL_POLPROD ICL_POLPROD CHAR 6   0   Policy Product TICL320
64 POLPRODN ICL_POLPRODN TEXT30 CHAR 30   0   Name of Policy Product  
65 PLINEOFBUS ICL_LINEOFBUS ICL_LINEOFBUS CHAR 3   0   Insurance Line of Business TICL007
66 PLINEOFBUSN ICL_LINEOFBUSN TEXT30 CHAR 30   0   Name of Insurance Line of Business  
67 CCSBRTYPEN ICL_CCSBRTYPEN TEXT40 CHAR 40   0   Name of Subrogation Claim Type  
68 XSUBRO ICL_SUBCL03 ICL_SUBCL03 CHAR 1   0   Subrogation/Recovery Status  
69 XSUBROTXT ICL_XSUBROTXT TEXT25 CHAR 25   0   Subrogation Status (Text)  
70 PAY_STATUS ICL_PAYMENT12 ICL_PAYMENT12 CHAR 2   0   Internal Payment Status (Database Status)  
71 PAY_STATUSTXT ICL_STATUSTXT DDTEXT CHAR 60   0   Name of Status of Claim Payment  
72 CHREASONSBRN ICL_CHREASONSBRN TEXT40 CHAR 40   0   Name of Change Reason for the Subrogation Status  
73 .INCLUDE       0   0   Collective Subrogation: Special Attributes (only for GUI)  
74 ACCEVT ICLE_ACCFORM ICL_CCEVENT CHAR 17   0   Accident Event *
75 ACCDATE ICLE_ACCDATE DATE DATS 8   0   Accident Date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ICLE_BULKSBR_SCR_ITEM BUNDLECAUSE TICL012 BUNDLECAUSE    
2 ICLE_BULKSBR_SCR_ITEM CCSBRBNDL ICLCCEVENT CCEVENT REF 1 CN
3 ICLE_BULKSBR_SCR_ITEM CCSBRTYPE TICL177 CCSBRTYPE REF 1 CN
4 ICLE_BULKSBR_SCR_ITEM CCTYPE TICL001 CCTYPE    
5 ICLE_BULKSBR_SCR_ITEM CHANGEDBY USR02 BNAME    
6 ICLE_BULKSBR_SCR_ITEM CHREASONSBR TICL175 CHREASONSBR REF 1 CN
7 ICLE_BULKSBR_SCR_ITEM CLAIMTYPE TICL011 CLTYPE REF 1 CN
8 ICLE_BULKSBR_SCR_ITEM CLIENT T000 MANDT    
9 ICLE_BULKSBR_SCR_ITEM COUNTRY T005 LAND1 REF 1 CN
10 ICLE_BULKSBR_SCR_ITEM CREATEDBY USR02 BNAME    
11 ICLE_BULKSBR_SCR_ITEM CURR TCURC WAERS    
12 ICLE_BULKSBR_SCR_ITEM DATASOURCE TICL136 DATASOURCE KEY    
13 ICLE_BULKSBR_SCR_ITEM INSURED BUT000 PARTNER REF 1 CN
14 ICLE_BULKSBR_SCR_ITEM OWNER USR02 BNAME    
15 ICLE_BULKSBR_SCR_ITEM PLINEOFBUS TICL007 PLINEOFBUS REF 1 CN
16 ICLE_BULKSBR_SCR_ITEM POLPROD TICL320 POLPROD REF 1 CN
17 ICLE_BULKSBR_SCR_ITEM REGION T005S BLAND REF 1 CN
18 ICLE_BULKSBR_SCR_ITEM STATUS TICL140 STATUS    
19 ICLE_BULKSBR_SCR_ITEM SUBTYPE TICL002 SUBTYPE    
History
Last changed by/on SAP  20130529 
SAP Release Created in 472