SAP ABAP View V_ICLPAYMENT (Database View for BW-Extraction of ICLPAY and ICLPAYI)

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_ICLPAYMENT
Short Description	Database View for BW-Extraction of ICLPAY and ICLPAYI
Root table	ICLPAY	Claim Payment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLPAY	ICLPAY
2	ICLPAYI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLPAY	CLIENT	JL	EQ				0	0
2	ICLPAYI	CLIENT	JR	EQ			AND	0	0
3	ICLPAY	ACTIVE	JL	EQ				0	0
4	ICLPAYI	ACTIVE	JR	EQ			AND	0	0
5	ICLPAY	CLAIM	JL	EQ				0	0
6	ICLPAYI	CLAIM	JR	EQ			AND	0	0
7	ICLPAY	SUBCLAIM	JL	EQ				0	0
8	ICLPAYI	SUBCLAIM	JR	EQ			AND	0	0
9	ICLPAY	PAYMENT	JL	EQ				0	0
10	ICLPAYI	PAYMENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	ICLPAY	*		☐		☐
2	CLIENT	ICLPAY	CLIENT		☐	MANDT	☐	Client
3	ACTIVE	ICLPAY	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
4	CLAIM	ICLPAY	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
5	SUBCLAIM	ICLPAY	SUBCLAIM		☐	ICL_SUBCLP	☐	Subclaim of Payment
6	PAYMENT	ICLPAY	PAYMENT		☐	ICL_PAYMENT	☐	Number of Claim Payment
7	CHANGETIME	ICLPAY	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
8	CHANGEDBY	ICLPAY	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
9	DELETED	ICLPAY	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
10	CREATEDBY	ICLPAY	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
11	CREATETIME	ICLPAY	CREATETIME		☐	ICL_CREATEUTC	☐	Created: UTC Date+Time
12	APPROVEDBY	ICLPAY	APPROVEDBY		☐	ICL_PAYMENT13	☐	Checked By
13	APPROVEDTIME	ICLPAY	APPROVEDTIME		☐	ICL_PAYMENT15UTC	☐	Date Checked (UTC Date+Time)
14	TRANSFERTIME	ICLPAY	TRANSFERTIME		☐	ICL_PAYMENT17UTC	☐	Transfer Date (UTC Date+Time)
15	DOCUMENTREF	ICLPAY	DOCUMENTREF		☐	ICL_DOCUMENTREF	☐	Reference for Payment Document Created in Subledger
16	POSTDATE	ICLPAY	POSTDATE		☐	ICL_POSTDATE	☐	Posting Date
17	DOCDATE	ICLPAY	DOCDATE		☐	ICL_DOCDATE	☐	Document Date of Payment
18	DUEDATE	ICLPAY	DUEDATE		☐	ICL_DUEDATENET	☐	Due Date for Net Payment
19	XALREADYPAID	ICLPAY	XALREADYPAID		☐	ICL_ALREADYPAID	☐	Payment Already Made
20	PAYCAT	ICLPAY	PAYCAT		☐	ICL_PAYCAT	☐	Record Type of Payment
21	PAYTYPE	ICLPAY	PAYTYPE		☐	ICL_PAYTYPE	☐	Payment Type (Final Payment, Payment After Closure of Claim)
22	SUBSAL	ICLPAY	SUBSAL		☐	ICL_SUBSAL	☐	Subrogation/Salvage
23	XPAYEE	ICLPAY	XPAYEE		☐	ICL_XPAYEE	☐	Additional Payee (ICLPAYEE)
24	ADDRNUMBER	ICLPAY	ADDRNUMBER		☐	ICL_ADDRNUM	☐	Address Number for Checks
25	CRECADDR	ICLPAY	CRECADDR		☐	ICL_ADDRNUM	☐	Address Number for Checks
26	BKID	ICLPAY	BKID		☐	ICL_BKID	☐	Bank Details ID
27	CURR	ICLPAY	CURR		☐	ICL_PAYMENTCUR	☐	Claim Payment Currency
28	EXCHRATE	ICLPAY	EXCHRATE		☐	ICL_PAYMENT18	☐	Exchange Rate of Payment Currency into Policy Currency
29	STATUS	ICLPAY	STATUS		☐	ICL_PAYMENT12	☐	Internal Payment Status (Database Status)
30	METHOD	ICLPAY	METHOD		☐	ICL_PAYMENT01	☐	Payment Method
31	CHECKNUMBER	ICLPAY	CHECKNUMBER		☐	ICL_CHECK	☐	Check Number for Manual Check Payments
32	NOTE	ICLPAY	NOTE		☐	ICL_PAYMENT04	☐	Payment Note
33	INVOICEREF	ICLPAY	INVOICEREF		☐	ICL_INVOICEREF	☐	External Invoice Number
34	REFCLAIM	ICLPAY	REFCLAIM		☐	ICL_CLAIM_REFPAY	☐	Claim Number (Reassignment Reference)
35	REFSUBCLAIM	ICLPAY	REFSUBCLAIM		☐	ICL_SUBCL_REFPAY	☐	Subclaim (Reassignment Reference)
36	REFPAYMENT	ICLPAY	REFPAYMENT		☐	ICL_PAYMENT_REFPAY	☐	Claim Payment (Reassignment Reference)
37	AMTDONE	ICLPAY	AMTDONE		☐	ICL_AMOUNT_DONE	☐	Amount Paid or Received
38	LIABRATE	ICLPAY	LIABRATE		☐	ICL_LIABRATE_NEG	☐	Negotiated Liability Rate in Percent
39	AMTNEG	ICLPAY	AMTNEG		☐	ICL_AMOUNTNEG	☐	Amount Negotiated
40	SUBROSTATUS	ICLPAY	SUBROSTATUS		☐	ICL_SUBROSTATUS	☐	Legal Status of Subrogation
41	TAXROLE	ICLPAY	TAXROLE		☐	ICL_TAXROLE	☐	Tax Role of Claim Payment Recipient
42	TAX_RPT	ICLPAY	TAX_RPT		☐	ICL_TAXRPT	☐	Flag for Reportable Payments
43	XTAXRPTCT	ICLPAY	XTAXRPTCT		☐	ICL_XTAXRPTCT	☐	Code for Withholding Tax in Statutory Reporting Category
44	MTAXRPTCT	ICLPAY	MTAXRPTCT		☐	ICL_TAXRPTCT	☐	Withholding Tax Code for Statutory Reporting
45	OVRD_TAXRPTCT	ICLPAY	OVRD_TAXRPTCT		☐	ICL_OVRDTAXRPTCT	☐	Manual Withholding Tax Code
46	FUNDSRECDT	ICLPAY	FUNDSRECDT		☐	ICL_SALVFUNDREC	☐	Salvage: Funds Received
47	XSALVESTEND	ICLPAY	XSALVESTEND		☐	ICL_XSALVESTEND	☐	End Estimation of Salvage Value
48	OWNERTYPE_GRP	ICLPAY	OWNERTYPE_GRP		☐	ICL_OWNERTYPE_GRP3	☐	Responsible Organization Category
49	OWNER_GRP	ICLPAY	OWNER_GRP		☐	ICL_OWNER_GRP3	☐	Responsible Organizational Unit
50	REASONREJ	ICLPAY	REASONREJ		☐	ICL_REASONREJ	☐	Rejection Reasons for Payments and Reserves
51	REFEXTSDOC	ICLPAY	REFEXTSDOC		☐	ICL_REFEXTSDOC	☐	Referenced Statistical Payment Entry
52	MOS	ICLPAY	MOS		☐	ICL_MOS	☐	Method of Settlement
53	CL_PAYFREQPLAN	ICLPAY	CL_PAYFREQPLAN		☐	ICL_PAYFREQPLAN	☐	Payment Frequency of Scheduled Payment
54	PMTTO	ICLPAY	PMTTO		☐	ICL_PMTTO	☐	End Date of a Scheduled Payment
55	PMTFR	ICLPAY	PMTFR		☐	ICL_PMTFR	☐	Start Date of a Scheduled Payment
56	SCHEDTYPE	ICLPAY	SCHEDTYPE		☐	ICL_SCHEDULE_TYPE	☐	Type of Scheduled Payment
57	NROFINVREQ	ICLPAY	NROFINVREQ		☐	ICL_INVOICES_REQUIRED	☐	Mininum Number of Inbound Invoices
58	DAMAGEDOBJ	ICLPAY	DAMAGEDOBJ		☐	ICL_DAMOBJ	☐	Damaged Object
59	MIGRATION	ICLPAY	MIGRATION		☐	ICL_PAYMIGRATION	☐	Indicator for Migrated Payments
60	REQEVALCAT	ICLPAY	REQEVALCAT		☐	ICL_REQEVALCAT_D_PE	☐	Determination Category of Receivable Amount
61	-	ICLPAY	ASSIGN_GUID		☐	ICL_ASSIGN_GUID	☐	UUID of Entry to be Linked
62	PAYOUT_SCENARIO	ICLPAY	PAYOUT_SCENARIO		☐	ICL_PAYOUT_SCENARIO_D	☐	Repetitive Payment Scenario
63	*	ICLPAYI	*		☐		☐
64	-	ICLPAYI	CLIENT		☐	MANDT	☐	Client
65	-	ICLPAYI	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
66	-	ICLPAYI	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
67	-	ICLPAYI	SUBCLAIM		☐	ICL_SUBCLP	☐	Subclaim of Payment
68	-	ICLPAYI	PAYMENT		☐	ICL_PAYMENT	☐	Number of Claim Payment
69	PAYMENTITEM	ICLPAYI	PAYMENTITEM		☐	ICL_PAYMENTITEM	☐	Claim Payment Item
70	-	ICLPAYI	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
71	-	ICLPAYI	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
72	-	ICLPAYI	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
73	ITEMSUBCL	ICLPAYI	ITEMSUBCL		☐	ICL_ITEMSUBCLAIM	☐	Subclaim to Which a Payment Item Is Assigned
74	PAYITEMCAT	ICLPAYI	PAYITEMCAT		☐	ICL_PAYITEMCAT	☐	Claim Payment Item Category
75	PAMPAID	ICLPAYI	PAMPAID		☐	ICL_SCLITEMAP	☐	Payment Amount
76	BENTYPE	ICLPAYI	BENTYPE		☐	ICL_BENTYPE	☐	Benefit Type
77	COVTYPE	ICLPAYI	COVTYPE		☐	ICL_COVTYPE	☐	Coverage Type
78	PYMTYPE	ICLPAYI	PYMTYPE		☐	ICL_PYMTYPE	☐	Tax Category
79	PAYTYPEI	ICLPAYI	PAYTYPEI		☐	ICL_PAYTYPE	☐	Payment Type (Final Payment, Payment After Closure of Claim)
80	TREASONSET	ICLPAYI	TREASONSET		☐	ICL_PAYREASONSET	☐	Payment Reason Group
81	TREASON	ICLPAYI	TREASON		☐	ICL_PAYREASON	☐	Payment Reason
82	GROSS_NET	ICLPAYI	GROSS_NET		☐	ICL_GROSS_NET	☐	Tax Category of Amount (Gross/Net)
83	TXCOD	ICLPAYI	TXCOD		☐	ICL_TXCOD	☐	Tax Code
84	REQUESTED	ICLPAYI	REQUESTED		☐	ICL_REQUESTED	☐	Amount Requested
85	POSTDATEI	ICLPAYI	POSTDATEI		☐	ICL_POSTDATE	☐	Posting Date
86	ITEM	ICLPAYI	ITEM		☐	ICL_SCLITEM	☐	Claim Item
87	REFNO	ICLPAYI	REFNO		☐	ICL_SCLITEMREF	☐	External Reference Number
88	PAYITY	ICLPAYI	PAYITY		☐	ICL_PAYITY	☐	Payment Item Type
89	REPID	ICLPAYI	REPID		☐	ICL_REPID	☐	Coinsurance Key
90	VALIDFROM	ICLPAYI	VALIDFROM		☐	ICL_PAYVALIDFROM	☐	Payment Item: Valid From
91	VALIDTO	ICLPAYI	VALIDTO		☐	ICL_PAYVALIDTO	☐	Payment Item: Valid To
92	ASSIGN_GUID	ICLPAYI	ASSIGN_GUID		☐	ICL_ASSIGN_GUID	☐	UUID of Entry to be Linked
93	CDDOCITEM	ICLPAYI	CDDOCITEM		☐	ICL_DOCITEM	☐	Item Number in Payment Plan Document
94	REQUESTED_ORIG	ICLPAYI	REQUESTED_ORIG		☐	ICL_REQUESTED_ORIG	☐	Original Amount Requested
95	P_CHANGETIME	ICLPAYI	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
96	P_CHANGEDBY	ICLPAYI	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
97	P_DELETED	ICLPAYI	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)

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	464