SAP ABAP View V_ICL_REP_PAYMNT (Claims, Subclaims, and Payments (Reporting))

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts

Basic Data

View Type	D	Database View
Database View	V_ICL_REP_PAYMNT
Short Description	Claims, Subclaims, and Payments (Reporting)
Root table	ICLCLAIM	Claim

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLCLAIM	ICLCLAIM
2	ICLSUBCL
3	ICLPAY
4	ICLPAYI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLCLAIM	CLIENT	JL	EQ				0	0
2	ICLSUBCL	CLIENT	JR	EQ			AND	0	0
3	ICLCLAIM	ACTIVE	JL	EQ				0	0
4	ICLSUBCL	ACTIVE	JR	EQ			AND	0	0
5	ICLCLAIM	CLAIM	JL	EQ				0	0
6	ICLSUBCL	CLAIM	JR	EQ			AND	0	0
7	ICLSUBCL	CLIENT	JL	EQ				0	0
8	ICLPAY	CLIENT	JR	EQ			AND	0	0
9	ICLSUBCL	ACTIVE	JL	EQ				0	0
10	ICLPAY	ACTIVE	JR	EQ			AND	0	0
11	ICLSUBCL	CLAIM	JL	EQ				0	0
12	ICLPAY	CLAIM	JR	EQ			AND	0	0
13	ICLSUBCL	SUBCLAIM	JL	EQ				0	0
14	ICLPAY	SUBCLAIM	JR	EQ			AND	0	0
15	ICLPAY	CLIENT	JL	EQ				0	0
16	ICLPAYI	CLIENT	JR	EQ			AND	0	0
17	ICLPAY	ACTIVE	JL	EQ				0	0
18	ICLPAYI	ACTIVE	JR	EQ			AND	0	0
19	ICLPAY	CLAIM	JL	EQ				0	0
20	ICLPAYI	CLAIM	JR	EQ			AND	0	0
21	ICLPAY	SUBCLAIM	JL	EQ				0	0
22	ICLPAYI	SUBCLAIM	JR	EQ			AND	0	0
23	ICLPAY	PAYMENT	JL	EQ				0	0
24	ICLPAYI	PAYMENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ICLCLAIM	CLIENT		☐	MANDT	☐	Client
2	ACTIVE	ICLCLAIM	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
3	CLAIM	ICLCLAIM	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
4	C_CHANGETIME	ICLCLAIM	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
5	C_CHANGEDBY	ICLCLAIM	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
6	C_DELETED	ICLCLAIM	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
7	C_CREATEDBY	ICLCLAIM	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
8	C_CREATETIME	ICLCLAIM	CREATETIME		☐	ICL_CREATEUTC	☐	Created: UTC Date+Time
9	ACHANGEDBY	ICLCLAIM	ACHANGEDBY		☐	ICL_ACHANGEDBY	☐	Whole Claim Last Changed By
10	ACHANGETIME	ICLCLAIM	ACHANGETIME		☐	ICL_ACHANGETIME	☐	Whole Claim Last Changed At
11	EXCLAIMNOCAT	ICLCLAIM	EXCLAIMNOCAT		☐	ICL_CLAIMNOCAT	☐	External Number Category
12	EXCLAIMNO	ICLCLAIM	EXCLAIMNO		☐	ICL_CLAIMNO	☐	External Number
13	C_STATUS	ICLCLAIM	STATUS		☐	ICL_CLSTATUS	☐	Status of Claim
14	C_STATUSCHG	ICLCLAIM	STATUSCHG		☐	ICL_STATUSCHG	☐	Time of Last Status Change
15	C_STATREASON	ICLCLAIM	STATREASON		☐	ICL_FORMSET	☐	Reason for Changing the Status
16	LOSSTYPE	ICLCLAIM	LOSSTYPE		☐	ICL_LOSSTYPE	☐	Incident Type of a Claim
17	CLAIMTYPE	ICLCLAIM	CLAIMTYPE		☐	ICL_CLTYPE	☐	Internal Claim Type
18	CLTYPEG	ICLCLAIM	CLTYPEG		☐	ICL_CLTYPEG	☐	Generation of Internal Claim Type
19	CLTYPEV	ICLCLAIM	CLTYPEV		☐	ICL_CLTYPEV	☐	Internal Claim Type Version
20	LOSSEVENT	ICLCLAIM	LOSSEVENT		☐	ICL_LOSSEVENT	☐	Cumulative Event
21	POLPROD	ICLCLAIM	POLPROD		☐	ICL_POLPROD	☐	Policy Product
22	GENERAT	ICLCLAIM	GENERAT		☐	ICL_GENERAT	☐	Policy Product Generation
23	VERSION	ICLCLAIM	VERSION		☐	ICL_POLPRODV	☐	Policy Product Version
24	LRENEWAL	ICLCLAIM	LRENEWAL		☐	ICL_LRENEWAL	☐	Last Renewal of Contract Before Claim Date/Time
25	POLICY	ICLCLAIM	POLICY		☐	ICL_POLICY	☐	Contract Number
26	LOSSCAUSE	ICLCLAIM	LOSSCAUSE		☐	ICL_LOSSCAUSE	☐	Cause of Loss/Claim
27	PERIL	ICLCLAIM	PERIL		☐	ICL_PERIL	☐	Peril
28	DATELOSS	ICLCLAIM	DATELOSS		☐	ICL_LOSSDATE	☐	Date of Loss/Claim
29	TIMELOSS	ICLCLAIM	TIMELOSS		☐	ICL_LOSSTIME	☐	Time of Claim/Loss
30	LTIMEZONE	ICLCLAIM	LTIMEZONE		☐	ICL_LTIMEZONE	☐	Time Zone of Claim/Loss Event
31	XDATEESTIM	ICLCLAIM	XDATEESTIM		☐	ICL_XLOSSDATE	☐	Date Is Estimate
32	DATECHANGER	ICLCLAIM	DATECHANGER		☐	ICL_DATECHANGER	☐	Reason for Changing Claim Date
33	LOSSREPCOMPA	ICLCLAIM	LOSSREPCOMPA		☐	ICL_LOSSREPCOMPA	☐	Date Claim Reported to Insurance Company
34	LOSSREPAGENT	ICLCLAIM	LOSSREPAGENT		☐	ICL_LOSSREPAGENT	☐	Date Claim Reported to Agent
35	XAUTHREP	ICLCLAIM	XAUTHREP		☐	ICL_XAUTHREP	☐	Claim/Loss Reported to Authority
36	XSENSITIVE	ICLCLAIM	XSENSITIVE		☐	ICL_CLAIMSENS	☐	Sensitive Claim?
37	COMPLEX	ICLCLAIM	COMPLEX		☐	ICL_COMPLEX	☐	Complexity of Claim/Subclaim
38	JURISCOUNTRY	ICLCLAIM	JURISCOUNTRY		☐	ICL_JURICOUNTRY	☐	Jurisdiction Country
39	JURISREGION	ICLCLAIM	JURISREGION		☐	ICL_JURISREGION	☐	Jurisdiction Region
40	OWNERTYPE	ICLCLAIM	OWNERTYPE		☐	ICL_OWNERTYPE	☐	Object Type of Claim Handler
41	OWNER	ICLCLAIM	OWNER		☐	ICL_CLAIMOWNER	☐	ID of Claim Handler
42	C_OWNERTYPE_GRP	ICLCLAIM	OWNERTYPE_GRP		☐	ICL_OWNERTYPE2	☐	Object Type of Claim Handler Group
43	C_OWNER_GRP	ICLCLAIM	OWNER_GRP		☐	ICL_CLAIMOWNER2	☐	Claim Handler Group
44	VIEWFAULT	ICLCLAIM	VIEWFAULT		☐	ICL_VIEWFAULTI	☐	Fault of Policyholder from Point of View of Insurer
45	VIEWFAULTPH	ICLCLAIM	VIEWFAULTPH		☐	ICL_VIEWFAULTPH	☐	Party at Fault from Point of View of Policyholder
46	COVERED	ICLCLAIM	COVERED		☐	ICL_COVERED	☐	Indication of Compensability
47	AUTHCLM	ICLCLAIM	AUTHCLM		☐	ICL_AUTHCLM	☐	Authorization Group for Claims (VIP)
48	S_SUBCLAIM	ICLSUBCL	SUBCLAIM		☐	ICL_SUBCL	☐	Subclaim
49	S_CHANGETIME	ICLSUBCL	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
50	S_CHANGEDBY	ICLSUBCL	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
51	S_DELETED	ICLSUBCL	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
52	S_CREATEDBY	ICLSUBCL	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
53	S_CREATETIME	ICLSUBCL	CREATETIME		☐	ICL_CREATEUTC	☐	Created: UTC Date+Time
54	S_STATUS	ICLSUBCL	STATUS		☐	ICL_SUBCL10	☐	Status of Subclaim
55	S_STATUSCHG	ICLSUBCL	STATUSCHG		☐	ICL_STATUSCHG	☐	Time of Last Status Change
56	S_STATREASON	ICLSUBCL	STATREASON		☐	ICL_FORMSET	☐	Reason for Changing the Status
57	XCOMPLETE	ICLSUBCL	XCOMPLETE		☐	ICL_SUBCL08	☐	Flag: Claim Item List (Presumably) Complete
58	SUBCLTYPE	ICLSUBCL	SUBCLTYPE		☐	ICL_SUBCLTYPE	☐	Subclaim Type
59	XSALVAGE	ICLSUBCL	XSALVAGE		☐	ICL_SUBCL01	☐	Flag: Salvage?
60	XOTHERINSURE	ICLSUBCL	XOTHERINSURE		☐	ICL_SUBCL02	☐	Flag: Other Insurance?
61	XSUBRO	ICLSUBCL	XSUBRO		☐	ICL_SUBCL03	☐	Subrogation/Recovery Status
62	XLITIGATION	ICLSUBCL	XLITIGATION		☐	ICL_SUBCL04	☐	Flag: Litigation?
63	XNEGOTIATION	ICLSUBCL	XNEGOTIATION		☐	ICL_SUBCL05	☐	Flag: Negotiation?
64	XFRAUD	ICLSUBCL	XFRAUD		☐	ICL_SUBCL06	☐	Flag: Potential Fraud?
65	COVERAGE	ICLSUBCL	COVERAGE		☐	ICL_POLM	☐	Coverage
66	XCOVCONFIRMED	ICLSUBCL	XCOVCONFIRMED		☐	ICL_COVERED	☐	Indication of Compensability
67	HANDLERTYPE	ICLSUBCL	HANDLERTYPE		☐	ICL_HANDLERTYPE	☐	Object Category of Subclaim Handler
68	CLAIMHANDLER	ICLSUBCL	CLAIMHANDLER		☐	ICL_SUBCLCH	☐	Claim Handler for Subclaim
69	HANDLERTYPE_GRP	ICLSUBCL	HANDLERTYPE_GRP		☐	ICL_HANDLERTYPE2	☐	Object Category of Subclaim Handler Group
70	CLAIMHANDLER_GRP	ICLSUBCL	CLAIMHANDLER_GRP		☐	ICL_SUBCLCH2	☐	Claim Handler Group for Subclaims
71	S_COMPLEX	ICLSUBCL	COMPLEX		☐	ICL_COMPLEX	☐	Complexity of Claim/Subclaim
72	P_PAYMENT	ICLPAY	PAYMENT		☐	ICL_PAYMENT	☐	Number of Claim Payment
73	P_CHANGETIME	ICLPAY	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
74	P_CHANGEDBY	ICLPAY	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
75	P_DELETED	ICLPAY	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
76	P_CREATEDBY	ICLPAY	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
77	P_CREATETIME	ICLPAY	CREATETIME		☐	ICL_CREATEUTC	☐	Created: UTC Date+Time
78	APPROVEDBY	ICLPAY	APPROVEDBY		☐	ICL_PAYMENT13	☐	Checked By
79	APPROVEDTIME	ICLPAY	APPROVEDTIME		☐	ICL_PAYMENT15UTC	☐	Date Checked (UTC Date+Time)
80	TRANSFERTIME	ICLPAY	TRANSFERTIME		☐	ICL_PAYMENT17UTC	☐	Transfer Date (UTC Date+Time)
81	DOCUMENTREF	ICLPAY	DOCUMENTREF		☐	ICL_DOCUMENTREF	☐	Reference for Payment Document Created in Subledger
82	POSTDATE	ICLPAY	POSTDATE		☐	ICL_POSTDATE	☐	Posting Date
83	DOCDATE	ICLPAY	DOCDATE		☐	ICL_DOCDATE	☐	Document Date of Payment
84	XALREADYPAID	ICLPAY	XALREADYPAID		☐	ICL_ALREADYPAID	☐	Payment Already Made
85	PAYCAT	ICLPAY	PAYCAT		☐	ICL_PAYCAT	☐	Record Type of Payment
86	P_PAYTYPE	ICLPAY	PAYTYPE		☐	ICL_PAYTYPE	☐	Payment Type (Final Payment, Payment After Closure of Claim)
87	SUBSAL	ICLPAY	SUBSAL		☐	ICL_SUBSAL	☐	Subrogation/Salvage
88	XPAYEE	ICLPAY	XPAYEE		☐	ICL_XPAYEE	☐	Additional Payee (ICLPAYEE)
89	BKID	ICLPAY	BKID		☐	ICL_BKID	☐	Bank Details ID
90	CURR	ICLPAY	CURR		☐	ICL_PAYMENTCUR	☐	Claim Payment Currency
91	EXCHRATE	ICLPAY	EXCHRATE		☐	ICL_PAYMENT18	☐	Exchange Rate of Payment Currency into Policy Currency
92	STATUS	ICLPAY	STATUS		☐	ICL_PAYMENT12	☐	Internal Payment Status (Database Status)
93	METHOD	ICLPAY	METHOD		☐	ICL_PAYMENT01	☐	Payment Method
94	CHECKNUMBER	ICLPAY	CHECKNUMBER		☐	ICL_CHECK	☐	Check Number for Manual Check Payments
95	NOTE	ICLPAY	NOTE		☐	ICL_PAYMENT04	☐	Payment Note
96	INVOICEREF	ICLPAY	INVOICEREF		☐	ICL_INVOICEREF	☐	External Invoice Number
97	AMTDONE	ICLPAY	AMTDONE		☐	ICL_AMOUNT_DONE	☐	Amount Paid or Received
98	P_LIABRATE	ICLPAY	LIABRATE		☐	ICL_LIABRATE_NEG	☐	Negotiated Liability Rate in Percent
99	AMTNEG	ICLPAY	AMTNEG		☐	ICL_AMOUNTNEG	☐	Amount Negotiated
100	TAXROLE	ICLPAY	TAXROLE		☐	ICL_TAXROLE	☐	Tax Role of Claim Payment Recipient
101	FUNDSRECDT	ICLPAY	FUNDSRECDT		☐	ICL_SALVFUNDREC	☐	Salvage: Funds Received
102	P_OWNERTYPE_GRP	ICLPAY	OWNERTYPE_GRP		☐	ICL_OWNERTYPE_GRP3	☐	Responsible Organization Category
103	P_OWNER_GRP	ICLPAY	OWNER_GRP		☐	ICL_OWNER_GRP3	☐	Responsible Organizational Unit
104	REASONREJ	ICLPAY	REASONREJ		☐	ICL_REASONREJ	☐	Rejection Reasons for Payments and Reserves
105	I_PAYMENTITEM	ICLPAYI	PAYMENTITEM		☐	ICL_PAYMENTITEM	☐	Claim Payment Item
106	I_CHANGETIME	ICLPAYI	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
107	I_CHANGEDBY	ICLPAYI	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
108	I_DELETED	ICLPAYI	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
109	ITEMSUBCL	ICLPAYI	ITEMSUBCL		☐	ICL_ITEMSUBCLAIM	☐	Subclaim to Which a Payment Item Is Assigned
110	ITEM	ICLPAYI	ITEM		☐	ICL_SCLITEM	☐	Claim Item
111	BENTYPE	ICLPAYI	BENTYPE		☐	ICL_BENTYPE	☐	Benefit Type
112	PAYITEMCAT	ICLPAYI	PAYITEMCAT		☐	ICL_PAYITEMCAT	☐	Claim Payment Item Category
113	PAMPAID	ICLPAYI	PAMPAID		☐	ICL_SCLITEMAP	☐	Payment Amount
114	REFNO	ICLPAYI	REFNO		☐	ICL_SCLITEMREF	☐	External Reference Number
115	TREASONSET	ICLPAYI	TREASONSET		☐	ICL_PAYREASONSET	☐	Payment Reason Group
116	TREASON	ICLPAYI	TREASON		☐	ICL_PAYREASON	☐	Payment Reason
117	PAYTYPEI	ICLPAYI	PAYTYPEI		☐	ICL_PAYTYPE	☐	Payment Type (Final Payment, Payment After Closure of Claim)

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	463