SAP ABAP View ICL_BS_ATTRIB_B (Bundle Attributes and Text Fields (Coll.Subrogation/Recvry))
Hierarchy
INSURANCE (Software Component) SAP Insurance
   FS-CM (Application Component) Claims Management
     ICL_EVENT (Package) FS-CM: Claim Bundle
Basic Data
View Type D Database View 
Database View ICL_BS_ATTRIB_B  
Short Description Bundle Attributes and Text Fields (Coll.Subrogation/Recvry)    
Root table ICLCCEVENT   Claim Bundle 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 ICLCCEVENT ICLCCEVENT
2 TICL001  
3 TICL001T  
4 TICL002  
5 TICL002T  
6 TICL177T  
7 TICL177  
8 TICL140  
9 TICL140T  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TICL001 CLIENT JL EQ 0 0
2 ICLCCEVENT CLIENT JR EQ AND 0 0
3 TICL001 CCTYPE JL EQ 0 0
4 ICLCCEVENT CCTYPE JR EQ AND 0 0
5 TICL001T CLIENT JL EQ 0 0
6 TICL001 CLIENT JR EQ AND 0 0
7 TICL001T CCTYPE JL EQ 0 0
8 TICL001 CCTYPE JR EQ AND 0 0
9 TICL002 CLIENT JL EQ 0 0
10 ICLCCEVENT CLIENT JR EQ AND 0 0
11 TICL002 CCTYPE JL EQ 0 0
12 ICLCCEVENT CCTYPE JR EQ AND 0 0
13 TICL002 SUBTYPE JL EQ 0 0
14 ICLCCEVENT SUBTYPE JR EQ AND 0 0
15 TICL002T CLIENT JL EQ 0 0
16 TICL002 CLIENT JR EQ AND 0 0
17 TICL002T CCTYPE JL EQ 0 0
18 TICL002 CCTYPE JR EQ AND 0 0
19 TICL002T SUBTYPE JL EQ 0 0
20 TICL002 SUBTYPE JR EQ AND 0 0
21 TICL002T LANGU JL EQ 0 0
22 TICL001T LANGU JR EQ AND 0 0
23 TICL001 CLIENT JL EQ 0 0
24 TICL177T CLIENT JR EQ AND 0 0
25 TICL001 CCTYPE JL EQ 0 0
26 TICL177T CCTYPE JR EQ AND 0 0
27 TICL177 CLIENT JL EQ 0 0
28 ICLCCEVENT CLIENT JR EQ AND 0 0
29 TICL177 CCTYPE JL EQ 0 0
30 ICLCCEVENT CCTYPE JR EQ AND 0 0
31 TICL177 SUBTYPE JL EQ 0 0
32 ICLCCEVENT SUBTYPE JR EQ AND 0 0
33 TICL177 CCSBRTYPE JL EQ 0 0
34 ICLCCEVENT CCSBRTYPE JR EQ AND 0 0
35 TICL177 CLIENT JL EQ 0 0
36 TICL177T CLIENT JR EQ AND 0 0
37 TICL177 CCTYPE JL EQ 0 0
38 TICL177T CCTYPE JR EQ AND 0 0
39 TICL177 SUBTYPE JL EQ 0 0
40 TICL177T SUBTYPE JR EQ AND 0 0
41 TICL177 CCSBRTYPE JL EQ 0 0
42 TICL177T CCSBRTYPE JR EQ AND 0 0
43 TICL140 CLIENT JL EQ 0 0
44 ICLCCEVENT CLIENT JR EQ AND 0 0
45 TICL140 STATUS JL EQ 0 0
46 ICLCCEVENT STATUS JR EQ AND 0 0
47 TICL140T CLIENT JL EQ 0 0
48 TICL140 CLIENT JR EQ AND 0 0
49 TICL140T LANGU JL EQ 0 0
50 TICL001T LANGU JR EQ AND 0 0
51 TICL140T STATUS JL EQ 0 0
52 TICL140 STATUS JR EQ AND 0 0
53 ICLCCEVENT DELETED NE 'X' AND 0 0
54 TICL001 TYPE EQ '4' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT ICLCCEVENT CLIENT   MANDT Client
2 ACTIVE ICLCCEVENT ACTIVE   ICL_ACTIVE Table entry is active (A) or in suspense (S)
3 CCEVENT ICLCCEVENT CCEVENT   ICL_CCEVENT Claim Bundle
4 CCTYPE ICLCCEVENT CCTYPE   ICL_CCEVENTCAT Claim Bundle Type
5 CCTYPEN TICL001T CCTYPEN   ICL_CCEVENTCATN Name of Claim Bundle Type
6 TYPE TICL001 TYPE   ICLE_CCEVENTTYP Category of Claim Bundle Type
7 SUBTYPE ICLCCEVENT SUBTYPE   ICL_CCEVENTTY Subtype of Claim Bundle Type
8 SUBTYPENAME TICL002T NAME   ICL_CCEVENTTYN Name of Subtype of Claim Bundle Type
9 CCSBRTYPE ICLCCEVENT CCSBRTYPE   ICL_CCSBRTYPE Subrogation Claim Type in Subrogation
10 CCSBRTYPEN TICL177T CCSBRTYPEN   ICL_CCSBRTYPEN Name of Subrogation Claim Type
11 RANGEFROM ICLCCEVENT RANGEFROM   ICL_CCEVENTFROM Event Period: Date From
12 STATUS ICLCCEVENT STATUS   ICLE_BUNDLE_STATUS_D Status of Claim Bundle
13 STATUSN TICL140T STATUSN   ICL_STATUSN Status Description
14 LANGU TICL001T LANGU   LANGU Language Key
15 LANGU2 TICL177T LANGU   LANGU Language Key
16 SUBTYPE2 TICL177T SUBTYPE   ICL_CCEVENTTY Subtype of Claim Bundle Type
17 CCSBRTYPE2 TICL177T CCSBRTYPE   ICL_CCSBRTYPE Subrogation Claim Type in Subrogation
18 CREATEDBY ICLCCEVENT CREATEDBY   ICL_CREATEDBY Created By
19 CHANGEDBY ICLCCEVENT CHANGEDBY   ICL_CHANGEDBY Changed By
20 CHANGETIME ICLCCEVENT CHANGETIME   ICL_CHANGEUTC1 Changed: UTC Date+Time
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in