SAP ABAP Table ICL_DIAGHIST_SEL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure ICL_DIAGHIST_SEL   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 CLAIM ICL_CLAIM ICL_CLAIM CHAR 17   0   Number of Claim ICLCLAIM
3 BPARTNER ICL_PART BU_PARTNER CHAR 10   0   Claim Participant  
4 PATIENT ICL_DAMOBJBI ICL_DAMOBJ NUMC 4   0   Injured Person ICLDAMOBJ
5 DATEFROM ICL_DATEFROM DATS DATS 8   0   Start Date of Period  
6 ENDDATE ICL_ENDDATE DATUM DATS 8   0   End Date  
7 SUBOBJCAT ICL_SUBOBJCAT ICL_SUBOBJCAT CHAR 2   0   Claim Subobject Category TICL013
8 SUBOBJECT ICL_SUBOBJECTD ICL_SUBOBJECTD CHAR 3   0   Damaged Objects Occurrence Subobject  
9 DIAGSRCCAT ICL_PDOCCAT ICL_PDOCCAT CHAR 2   0   Claim Item Grouping Category TICL138
10 DIAGSRCID ICL_DIAGSRCID ICL_DIAGSRCID CHAR 20   0   Diagnosis Source ID  
11 CATAID1 ICL_CATAID ICL_CATAID CHAR 4   0   Catalog Code TICL350
12 DIAGID1 ICL_PRIMDIAGID ICL_DIAGID CHAR 10   0   Primary Diagnosis TICL351
13 DIAGID2 ICL_SECDIAGID ICL_DIAGID CHAR 10   0   Secondary Diagnosis  
14 DESCRIPTION ICL_DESCRIPTION TEXT50 CHAR 50   0   Diagnosis Description  
15 DIAGTYPE ICL_DIAGTYPE ICL_DIAGTYPE CHAR 2   0   Diagnosis Type TICL360
16 LOCALIZATION ICL_LOCALIZATION ICL_LOCALIZATION CHAR 1   0   Side Localization of a Diagnosis TICL352
17 SEVERITYCODE ICL_SEVERITYCODE ICL_SEVERITYCODE CHAR 1   0   Severity of Diagnosis TICL354
18 MORPHOLOGY ICL_MORPHOLOGY ICL_MORPHOLOGY CHAR 7   0   Morphology TICL356
19 EXCORIATION ICL_EXCORIATION ICL_EXCORIATION CHAR 5   0   Excoriation TICL358
20 GUARANTEE ICL_GUARANTEE ICL_GUARANTEE CHAR 1   0   Diagnostic Certainty TICL363
21 DEPARTMENT ICL_DEPARTMENT ICL_DEPARTMENT CHAR 4   0   Department (Key) TICL364
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ICL_DIAGHIST_SEL CATAID1 TICL350 CATAID KEY 1 CN
2 ICL_DIAGHIST_SEL CLAIM ICLCLAIM CLAIM KEY 1 CN
3 ICL_DIAGHIST_SEL CLIENT T000 MANDT KEY 1 CN
4 ICL_DIAGHIST_SEL DEPARTMENT TICL364 DEPARTMENT KEY 1 CN
5 ICL_DIAGHIST_SEL DIAGID1 TICL351 DIAGID KEY 1 CN
6 ICL_DIAGHIST_SEL DIAGSRCCAT TICL138 PDOCCAT KEY 1 CN
7 ICL_DIAGHIST_SEL DIAGTYPE TICL360 DIAGTYPE KEY 1 CN
8 ICL_DIAGHIST_SEL EXCORIATION TICL358 EXCORIATION KEY 1 CN
9 ICL_DIAGHIST_SEL GUARANTEE TICL363 GUARANTEE KEY 1 CN
10 ICL_DIAGHIST_SEL LOCALIZATION TICL352 LOCALIZATION KEY 1 CN
11 ICL_DIAGHIST_SEL MORPHOLOGY TICL356 MORPHOLOGY KEY 1 CN
12 ICL_DIAGHIST_SEL PATIENT ICLDAMOBJ DAMAGEDOBJ KEY 1 CN
13 ICL_DIAGHIST_SEL SEVERITYCODE TICL354 SEVERITY KEY 1 CN
14 ICL_DIAGHIST_SEL SUBOBJCAT TICL013 SUBOBJCAT KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in