SAP ABAP Table V_ICL_REP_PAYMNT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_ICL_REP_PAYMNT   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 ACTIVE ICL_ACTIVE ICL_ACTIVE CHAR 1   0   Table entry is active (A) or in suspense (S)  
3 CLAIM ICL_CLAIM ICL_CLAIM CHAR 17   0   Number of Claim  
4 C_CHANGETIME ICL_CHANGEUTC1 ICL_TIMESTAMP DEC 15   0   Changed: UTC Date+Time  
5 C_CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
6 C_DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
7 C_CREATEDBY ICL_CREATEDBY XUBNAME CHAR 12   0   Created By USR02
8 C_CREATETIME ICL_CREATEUTC ICL_TIMESTAMP DEC 15   0   Created: UTC Date+Time  
9 ACHANGEDBY ICL_ACHANGEDBY XUBNAME CHAR 12   0   Whole Claim Last Changed By USR02
10 ACHANGETIME ICL_ACHANGETIME ICL_TIMESTAMP DEC 15   0   Whole Claim Last Changed At  
11 EXCLAIMNOCAT ICL_CLAIMNOCAT ICL_CLAIMNOCAT CHAR 1   0   External Number Category  
12 EXCLAIMNO ICL_CLAIMNO ICL_CLAIMNO CHAR 20   0   External Number  
13 C_STATUS ICL_CLSTATUS ICL_STATUS CHAR 2   0   Status of Claim TICL140
14 C_STATUSCHG ICL_STATUSCHG ICL_TIMESTAMP DEC 15   0   Time of Last Status Change  
15 C_STATREASON ICL_FORMSET ICL_FORMSET CHAR 2   0   Reason for Changing the Status TICL047
16 LOSSTYPE ICL_LOSSTYPE ICL_LOSSTYPE CHAR 4   0   Incident Type of a Claim TICL062
17 CLAIMTYPE ICL_CLTYPE ICL_CLTYPE CHAR 4   0   Internal Claim Type TICL011
18 CLTYPEG ICL_CLTYPEG ICL_CLTYPEG NUMC 5   0   Generation of Internal Claim Type TICL011
19 CLTYPEV ICL_CLTYPEV ICL_CLTYPEV NUMC 5   0   Internal Claim Type Version TICL003
20 LOSSEVENT ICL_LOSSEVENT ICL_CCEVENT CHAR 17   0   Cumulative Event ICLCCEVENT
21 POLPROD ICL_POLPROD ICL_POLPROD CHAR 6   0   Policy Product TICL320
22 GENERAT ICL_GENERAT ICL_GENERAT NUMC 5   0   Policy Product Generation TICL320
23 VERSION ICL_POLPRODV ICL_CUST_VERSION NUMC 5   0   Policy Product Version TICL321
24 LRENEWAL ICL_LRENEWAL ICL_TIMESTAMP DEC 15   0   Last Renewal of Contract Before Claim Date/Time  
25 POLICY ICL_POLICY ICL_POLICY CHAR 17   0   Contract Number  
26 LOSSCAUSE ICL_LOSSCAUSE ICL_LOSSCAUSE CHAR 3   0   Cause of Loss/Claim TICL009
27 PERIL ICL_PERIL ICL_PERIL CHAR 4   0   Peril  
28 DATELOSS ICL_LOSSDATE DATE DATS 8   0   Date of Loss/Claim  
29 TIMELOSS ICL_LOSSTIME TIME TIMS 6   0   Time of Claim/Loss  
30 LTIMEZONE ICL_LTIMEZONE TZNZONE CHAR 6   0   Time Zone of Claim/Loss Event TTZZ
31 XDATEESTIM ICL_XLOSSDATE XFELD CHAR 1   0   Date Is Estimate  
32 DATECHANGER ICL_DATECHANGER ICL_DATECHANGER CHAR 2   0   Reason for Changing Claim Date TICL029
33 LOSSREPCOMPA ICL_LOSSREPCOMPA DATE DATS 8   0   Date Claim Reported to Insurance Company  
34 LOSSREPAGENT ICL_LOSSREPAGENT DATE DATS 8   0   Date Claim Reported to Agent  
35 XAUTHREP ICL_XAUTHREP XFELD CHAR 1   0   Claim/Loss Reported to Authority  
36 XSENSITIVE ICL_CLAIMSENS XFELD CHAR 1   0   Sensitive Claim?  
37 COMPLEX ICL_COMPLEX ICL_COMPLEX CHAR 1   0   Complexity of Claim/Subclaim TICL027
38 JURISCOUNTRY ICL_JURICOUNTRY LAND1 CHAR 3   0   Jurisdiction Country T005
39 JURISREGION ICL_JURISREGION REGIO CHAR 3   0   Jurisdiction Region T005S
40 OWNERTYPE ICL_OWNERTYPE OTYPE CHAR 2   0   Object Type of Claim Handler T778O
41 OWNER ICL_CLAIMOWNER ICL_CLAIMOWNER CHAR 12   0   ID of Claim Handler  
42 C_OWNERTYPE_GRP ICL_OWNERTYPE2 OTYPE CHAR 2   0   Object Type of Claim Handler Group  
43 C_OWNER_GRP ICL_CLAIMOWNER2 ICL_CLAIMOWNER CHAR 12   0   Claim Handler Group  
44 VIEWFAULT ICL_VIEWFAULTI ICL_VIEWFAULT CHAR 1   0   Fault of Policyholder from Point of View of Insurer TICL081
45 VIEWFAULTPH ICL_VIEWFAULTPH ICL_VIEWFAULT CHAR 1   0   Party at Fault from Point of View of Policyholder TICL081
46 COVERED ICL_COVERED ICL_COVERED CHAR 1   0   Indication of Compensability  
47 AUTHCLM ICL_AUTHCLM ICL_AUTHCLM CHAR 4   0   Authorization Group for Claims (VIP) TICL113
48 S_SUBCLAIM ICL_SUBCL ICL_SUBCL CHAR 3   0   Subclaim  
49 S_CHANGETIME ICL_CHANGEUTC1 ICL_TIMESTAMP DEC 15   0   Changed: UTC Date+Time  
50 S_CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
51 S_DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
52 S_CREATEDBY ICL_CREATEDBY XUBNAME CHAR 12   0   Created By USR02
53 S_CREATETIME ICL_CREATEUTC ICL_TIMESTAMP DEC 15   0   Created: UTC Date+Time  
54 S_STATUS ICL_SUBCL10 ICL_STATUS CHAR 2   0   Status of Subclaim TICL140
55 S_STATUSCHG ICL_STATUSCHG ICL_TIMESTAMP DEC 15   0   Time of Last Status Change  
56 S_STATREASON ICL_FORMSET ICL_FORMSET CHAR 2   0   Reason for Changing the Status TICL047
57 XCOMPLETE ICL_SUBCL08 XFELD CHAR 1   0   Flag: Claim Item List (Presumably) Complete  
58 SUBCLTYPE ICL_SUBCLTYPE ICL_SUBCLTYPE CHAR 4   0   Subclaim Type TICL004
59 XSALVAGE ICL_SUBCL01 ICL_SUBCL01 CHAR 1   0   Flag: Salvage?  
60 XOTHERINSURE ICL_SUBCL02 XFELD CHAR 1   0   Flag: Other Insurance?  
61 XSUBRO ICL_SUBCL03 ICL_SUBCL03 CHAR 1   0   Subrogation/Recovery Status  
62 XLITIGATION ICL_SUBCL04 XFELD CHAR 1   0   Flag: Litigation?  
63 XNEGOTIATION ICL_SUBCL05 XFELD CHAR 1   0   Flag: Negotiation?  
64 XFRAUD ICL_SUBCL06 XFELD CHAR 1   0   Flag: Potential Fraud?  
65 COVERAGE ICL_POLM ICL_POLM CHAR 4   0   Coverage  
66 XCOVCONFIRMED ICL_COVERED ICL_COVERED CHAR 1   0   Indication of Compensability  
67 HANDLERTYPE ICL_HANDLERTYPE OTYPE CHAR 2   0   Object Category of Subclaim Handler T778O
68 CLAIMHANDLER ICL_SUBCLCH XUBNAME CHAR 12   0   Claim Handler for Subclaim USR02
69 HANDLERTYPE_GRP ICL_HANDLERTYPE2 OTYPE CHAR 2   0   Object Category of Subclaim Handler Group  
70 CLAIMHANDLER_GRP ICL_SUBCLCH2 XUBNAME CHAR 12   0   Claim Handler Group for Subclaims  
71 S_COMPLEX ICL_COMPLEX ICL_COMPLEX CHAR 1   0   Complexity of Claim/Subclaim TICL027
72 P_PAYMENT ICL_PAYMENT ICL_PAYMENT NUMC 5   0   Number of Claim Payment  
73 P_CHANGETIME ICL_CHANGEUTC1 ICL_TIMESTAMP DEC 15   0   Changed: UTC Date+Time  
74 P_CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
75 P_DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
76 P_CREATEDBY ICL_CREATEDBY XUBNAME CHAR 12   0   Created By USR02
77 P_CREATETIME ICL_CREATEUTC ICL_TIMESTAMP DEC 15   0   Created: UTC Date+Time  
78 APPROVEDBY ICL_PAYMENT13 XUBNAME CHAR 12   0   Checked By USR02
79 APPROVEDTIME ICL_PAYMENT15UTC ICL_TIMESTAMP DEC 15   0   Date Checked (UTC Date+Time)  
80 TRANSFERTIME ICL_PAYMENT17UTC ICL_TIMESTAMP DEC 15   0   Transfer Date (UTC Date+Time)  
81 DOCUMENTREF ICL_DOCUMENTREF ICL_DOCUMENTREF CHAR 14   0   Reference for Payment Document Created in Subledger  
82 POSTDATE ICL_POSTDATE DATE DATS 8   0   Posting Date  
83 DOCDATE ICL_DOCDATE DATE DATS 8   0   Document Date of Payment  
84 XALREADYPAID ICL_ALREADYPAID CHAR1 CHAR 1   0   Payment Already Made  
85 PAYCAT ICL_PAYCAT ICL_PAYCAT CHAR 1   0   Record Type of Payment  
86 P_PAYTYPE ICL_PAYTYPE ICL_PAYTYPE CHAR 1   0   Payment Type (Final Payment, Payment After Closure of Claim)  
87 SUBSAL ICL_SUBSAL ICL_SUBRO NUMC 3   0   Subrogation/Salvage  
88 XPAYEE ICL_XPAYEE CHAR1 CHAR 1   0   Additional Payee (ICLPAYEE)  
89 BKID ICL_BKID CHAR4 CHAR 4   0   Bank Details ID BUT0BK
90 CURR ICL_PAYMENTCUR WAERS CUKY 5   0   Claim Payment Currency TCURC
91 EXCHRATE ICL_PAYMENT18 KURSF DEC 9   5   Exchange Rate of Payment Currency into Policy Currency  
92 STATUS ICL_PAYMENT12 ICL_PAYMENT12 CHAR 2   0   Internal Payment Status (Database Status)  
93 METHOD ICL_PAYMENT01 PYMET_KK CHAR 1   0   Payment Method TFK042Z
94 CHECKNUMBER ICL_CHECK ICL_CHECK CHAR 13   0   Check Number for Manual Check Payments  
95 NOTE ICL_PAYMENT04 TEXT50 CHAR 50   0   Payment Note  
96 INVOICEREF ICL_INVOICEREF CHAR20 CHAR 20   0   External Invoice Number  
97 AMTDONE ICL_AMOUNT_DONE ICL_ITAMTS CURR 15   2   Amount Paid or Received  
98 P_LIABRATE ICL_LIABRATE_NEG ICL_PERCENT DEC 5   2   Negotiated Liability Rate in Percent  
99 AMTNEG ICL_AMOUNTNEG ICL_ITAMTS CURR 15   2   Amount Negotiated  
100 TAXROLE ICL_TAXROLE ICL_TAXROLE CHAR 4   0   Tax Role of Claim Payment Recipient  
101 FUNDSRECDT ICL_SALVFUNDREC ICL_SALVFUNDREC DATS 8   0   Salvage: Funds Received  
102 P_OWNERTYPE_GRP ICL_OWNERTYPE_GRP3 OTYPE CHAR 2   0   Responsible Organization Category  
103 P_OWNER_GRP ICL_OWNER_GRP3 XUBNAME CHAR 12   0   Responsible Organizational Unit  
104 REASONREJ ICL_REASONREJ ICL_REASONREJ CHAR 2   0   Rejection Reasons for Payments and Reserves TICL112
105 I_PAYMENTITEM ICL_PAYMENTITEM ICL_PAYMENTITEM NUMC 3   0   Claim Payment Item  
106 I_CHANGETIME ICL_CHANGEUTC1 ICL_TIMESTAMP DEC 15   0   Changed: UTC Date+Time  
107 I_CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
108 I_DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
109 ITEMSUBCL ICL_ITEMSUBCLAIM CHAR3 CHAR 3   0   Subclaim to Which a Payment Item Is Assigned  
110 ITEM ICL_SCLITEM ICL_SCLITEM CHAR 4   0   Claim Item ICLITEM
111 BENTYPE ICL_BENTYPE ICL_BENTYPE CHAR 10   0   Benefit Type TICL055
112 PAYITEMCAT ICL_PAYITEMCAT ICL_PAYITEMCAT CHAR 1   0   Claim Payment Item Category  
113 PAMPAID ICL_SCLITEMAP ICL_ITAMTS CURR 15   2   Payment Amount  
114 REFNO ICL_SCLITEMREF ICL_SCLITEMREF CHAR 15   0   External Reference Number  
115 TREASONSET ICL_PAYREASONSET ICL_PAYREASONSET CHAR 2   0   Payment Reason Group TICL067
116 TREASON ICL_PAYREASON ICL_PAYREASON CHAR 4   0   Payment Reason TICL066
117 PAYTYPEI ICL_PAYTYPE ICL_PAYTYPE CHAR 1   0   Payment Type (Final Payment, Payment After Closure of Claim)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_ICL_REP_PAYMNT ACHANGEDBY USR02 BNAME    
2 V_ICL_REP_PAYMNT APPROVEDBY USR02 BNAME    
3 V_ICL_REP_PAYMNT AUTHCLM TICL113 AUTHCLM REF 1 CN
4 V_ICL_REP_PAYMNT BENTYPE TICL055 BENTYPE    
5 V_ICL_REP_PAYMNT BKID BUT0BK BKVID    
6 V_ICL_REP_PAYMNT CLAIMHANDLER USR02 BNAME    
7 V_ICL_REP_PAYMNT CLAIMTYPE TICL011 CLTYPE    
8 V_ICL_REP_PAYMNT CLIENT T000 MANDT    
9 V_ICL_REP_PAYMNT CLTYPEG TICL011 VERSION    
10 V_ICL_REP_PAYMNT CLTYPEV TICL003 VERSION    
11 V_ICL_REP_PAYMNT COMPLEX TICL027 COMPLEX    
12 V_ICL_REP_PAYMNT CURR TCURC WAERS    
13 V_ICL_REP_PAYMNT C_CHANGEDBY USR02 BNAME    
14 V_ICL_REP_PAYMNT C_CREATEDBY USR02 BNAME    
15 V_ICL_REP_PAYMNT C_STATREASON TICL047 FORMOFSET    
16 V_ICL_REP_PAYMNT C_STATUS TICL140 STATUS    
17 V_ICL_REP_PAYMNT DATECHANGER TICL029 DATECHANGER    
18 V_ICL_REP_PAYMNT GENERAT TICL320 VERSION    
19 V_ICL_REP_PAYMNT HANDLERTYPE T778O OTYPE REF C CN
20 V_ICL_REP_PAYMNT ITEM ICLITEM ITEM    
21 V_ICL_REP_PAYMNT I_CHANGEDBY USR02 BNAME    
22 V_ICL_REP_PAYMNT JURISCOUNTRY T005 LAND1    
23 V_ICL_REP_PAYMNT JURISREGION T005S BLAND    
24 V_ICL_REP_PAYMNT LOSSCAUSE TICL009 LOSSCAUSE    
25 V_ICL_REP_PAYMNT LOSSEVENT ICLCCEVENT CCEVENT    
26 V_ICL_REP_PAYMNT LOSSTYPE TICL062 LOSSTYPE    
27 V_ICL_REP_PAYMNT LTIMEZONE TTZZ TZONE    
28 V_ICL_REP_PAYMNT METHOD TFK042Z ZLSCH    
29 V_ICL_REP_PAYMNT OWNERTYPE T778O OTYPE    
30 V_ICL_REP_PAYMNT POLPROD TICL320 POLPROD    
31 V_ICL_REP_PAYMNT P_CHANGEDBY USR02 BNAME    
32 V_ICL_REP_PAYMNT P_CREATEDBY USR02 BNAME    
33 V_ICL_REP_PAYMNT REASONREJ TICL112 REASONREJ    
34 V_ICL_REP_PAYMNT SUBCLTYPE TICL004 SUBCLTYPE    
35 V_ICL_REP_PAYMNT S_CHANGEDBY USR02 BNAME    
36 V_ICL_REP_PAYMNT S_COMPLEX TICL027 COMPLEX    
37 V_ICL_REP_PAYMNT S_CREATEDBY USR02 BNAME    
38 V_ICL_REP_PAYMNT S_STATREASON TICL047 FORMOFSET    
39 V_ICL_REP_PAYMNT S_STATUS TICL140 STATUS    
40 V_ICL_REP_PAYMNT TREASON TICL066 TREASON REF C CN
41 V_ICL_REP_PAYMNT TREASONSET TICL067 TREASONSET REF C CN
42 V_ICL_REP_PAYMNT VERSION TICL321 VERSION    
43 V_ICL_REP_PAYMNT VIEWFAULT TICL081 VIEWFAULT    
44 V_ICL_REP_PAYMNT VIEWFAULTPH TICL081 VIEWFAULT    
History
Last changed by/on SAP  20130529 
SAP Release Created in