SAP ABAP Table V_ICLPAYMENT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ICLPAYMENT	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	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	ICLCLAIM
4	SUBCLAIM	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
5	PAYMENT	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment
6	CHANGETIME	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	CHANGEDBY	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
8	DELETED	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
9	CREATEDBY	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
10	CREATETIME	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
11	APPROVEDBY	ICL_PAYMENT13	XUBNAME	CHAR	12	0	Checked By	USR02
12	APPROVEDTIME	ICL_PAYMENT15UTC	ICL_TIMESTAMP	DEC	15	0	Date Checked (UTC Date+Time)
13	TRANSFERTIME	ICL_PAYMENT17UTC	ICL_TIMESTAMP	DEC	15	0	Transfer Date (UTC Date+Time)
14	DOCUMENTREF	ICL_DOCUMENTREF	ICL_DOCUMENTREF	CHAR	14	0	Reference for Payment Document Created in Subledger
15	POSTDATE	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
16	DOCDATE	ICL_DOCDATE	DATE	DATS	8	0	Document Date of Payment
17	DUEDATE	ICL_DUEDATENET	DATE	DATS	8	0	Due Date for Net Payment
18	XALREADYPAID	ICL_ALREADYPAID	CHAR1	CHAR	1	0	Payment Already Made
19	PAYCAT	ICL_PAYCAT	ICL_PAYCAT	CHAR	1	0	Record Type of Payment
20	PAYTYPE	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
21	SUBSAL	ICL_SUBSAL	ICL_SUBRO	NUMC	3	0	Subrogation/Salvage
22	XPAYEE	ICL_XPAYEE	CHAR1	CHAR	1	0	Additional Payee (ICLPAYEE)
23	ADDRNUMBER	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	ADRC
24	CRECADDR	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks
25	BKID	ICL_BKID	CHAR4	CHAR	4	0	Bank Details ID	BUT0BK
26	CURR	ICL_PAYMENTCUR	WAERS	CUKY	5	0	Claim Payment Currency	TCURC
27	EXCHRATE	ICL_PAYMENT18	KURSF	DEC	9	5	Exchange Rate of Payment Currency into Policy Currency
28	STATUS	ICL_PAYMENT12	ICL_PAYMENT12	CHAR	2	0	Internal Payment Status (Database Status)
29	METHOD	ICL_PAYMENT01	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
30	CHECKNUMBER	ICL_CHECK	ICL_CHECK	CHAR	13	0	Check Number for Manual Check Payments
31	NOTE	ICL_PAYMENT04	TEXT50	CHAR	50	0	Payment Note
32	INVOICEREF	ICL_INVOICEREF	CHAR20	CHAR	20	0	External Invoice Number
33	REFCLAIM	ICL_CLAIM_REFPAY	ICL_CLAIM	CHAR	17	0	Claim Number (Reassignment Reference)
34	REFSUBCLAIM	ICL_SUBCL_REFPAY	ICL_SUBCL	CHAR	3	0	Subclaim (Reassignment Reference)
35	REFPAYMENT	ICL_PAYMENT_REFPAY	ICL_PAYMENT	NUMC	5	0	Claim Payment (Reassignment Reference)
36	AMTDONE	ICL_AMOUNT_DONE	ICL_ITAMTS	CURR	15	2	Amount Paid or Received
37	LIABRATE	ICL_LIABRATE_NEG	ICL_PERCENT	DEC	5	2	Negotiated Liability Rate in Percent
38	AMTNEG	ICL_AMOUNTNEG	ICL_ITAMTS	CURR	15	2	Amount Negotiated
39	SUBROSTATUS	ICL_SUBROSTATUS	ICL_SUBROSTATUS	CHAR	1	0	Legal Status of Subrogation
40	TAXROLE	ICL_TAXROLE	ICL_TAXROLE	CHAR	4	0	Tax Role of Claim Payment Recipient
41	TAX_RPT	ICL_TAXRPT	XFELD	CHAR	1	0	Flag for Reportable Payments
42	XTAXRPTCT	ICL_XTAXRPTCT	XFELD	CHAR	1	0	Code for Withholding Tax in Statutory Reporting Category
43	MTAXRPTCT	ICL_TAXRPTCT	QSSKZ	CHAR	2	0	Withholding Tax Code for Statutory Reporting
44	OVRD_TAXRPTCT	ICL_OVRDTAXRPTCT	XFELD	CHAR	1	0	Manual Withholding Tax Code
45	FUNDSRECDT	ICL_SALVFUNDREC	ICL_SALVFUNDREC	DATS	8	0	Salvage: Funds Received
46	XSALVESTEND	ICL_XSALVESTEND	XFELD	CHAR	1	0	End Estimation of Salvage Value
47	OWNERTYPE_GRP	ICL_OWNERTYPE_GRP3	OTYPE	CHAR	2	0	Responsible Organization Category
48	OWNER_GRP	ICL_OWNER_GRP3	XUBNAME	CHAR	12	0	Responsible Organizational Unit
49	REASONREJ	ICL_REASONREJ	ICL_REASONREJ	CHAR	2	0	Rejection Reasons for Payments and Reserves	TICL112
50	REFEXTSDOC	ICL_REFEXTSDOC	ICL_PAYMENT	NUMC	5	0	Referenced Statistical Payment Entry
51	MOS	ICL_MOS	ICL_MOS	CHAR	3	0	Method of Settlement
52	CL_PAYFREQPLAN	ICL_PAYFREQPLAN	PKEY_VK	CHAR	2	0	Payment Frequency of Scheduled Payment	TVS010B
53	PMTTO	ICL_PMTTO	DATUM	DATS	8	0	End Date of a Scheduled Payment
54	PMTFR	ICL_PMTFR	DATUM	DATS	8	0	Start Date of a Scheduled Payment
55	SCHEDTYPE	ICL_SCHEDULE_TYPE	ICL_SCHEDULE_TYPE	CHAR	2	0	Type of Scheduled Payment	TICL180
56	NROFINVREQ	ICL_INVOICES_REQUIRED	NUMC2	NUMC	2	0	Mininum Number of Inbound Invoices
57	DAMAGEDOBJ	ICL_DAMOBJ	ICL_DAMOBJ	NUMC	4	0	Damaged Object
58	MIGRATION	ICL_PAYMIGRATION	CHAR1	CHAR	1	0	Indicator for Migrated Payments
59	REQEVALCAT	ICL_REQEVALCAT_D_PE	ICL_REQEVALCAT_PE	CHAR	1	0	Determination Category of Receivable Amount
60	PAYOUT_SCENARIO	ICL_PAYOUT_SCENARIO_D	ICL_PAYOUT_SCENARIO	CHAR	1	0	Repetitive Payment Scenario
61	PAYMENTITEM	ICL_PAYMENTITEM	ICL_PAYMENTITEM	NUMC	3	0	Claim Payment Item
62	ITEMSUBCL	ICL_ITEMSUBCLAIM	CHAR3	CHAR	3	0	Subclaim to Which a Payment Item Is Assigned
63	PAYITEMCAT	ICL_PAYITEMCAT	ICL_PAYITEMCAT	CHAR	1	0	Claim Payment Item Category
64	PAMPAID	ICL_SCLITEMAP	ICL_ITAMTS	CURR	15	2	Payment Amount
65	BENTYPE	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
66	COVTYPE	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type
67	PYMTYPE	ICL_PYMTYPE	ICL_PYMTYPE	CHAR	4	0	Tax Category	TICL551
68	PAYTYPEI	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
69	TREASONSET	ICL_PAYREASONSET	ICL_PAYREASONSET	CHAR	2	0	Payment Reason Group	TICL067
70	TREASON	ICL_PAYREASON	ICL_PAYREASON	CHAR	4	0	Payment Reason	TICL066
71	GROSS_NET	ICL_GROSS_NET	ICL_GROSS_NET	CHAR	1	0	Tax Category of Amount (Gross/Net)
72	TXCOD	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code
73	REQUESTED	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
74	POSTDATEI	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
75	ITEM	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	ICLITEM
76	REFNO	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
77	PAYITY	ICL_PAYITY	ICL_PAYITY	CHAR	10	0	Payment Item Type	TICL291
78	REPID	ICL_REPID		CHAR	10	0	Coinsurance Key
79	VALIDFROM	ICL_PAYVALIDFROM	DATE	DATS	8	0	Payment Item: Valid From
80	VALIDTO	ICL_PAYVALIDTO	DATE	DATS	8	0	Payment Item: Valid To
81	ASSIGN_GUID	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
82	CDDOCITEM	ICL_DOCITEM	ICL_DOCITEM	NUMC	4	0	Item Number in Payment Plan Document
83	REQUESTED_ORIG	ICL_REQUESTED_ORIG	ICL_ITAMTS	CURR	15	2	Original Amount Requested
84	P_CHANGETIME	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
85	P_CHANGEDBY	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
86	P_DELETED	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_ICLPAYMENT	ADDRNUMBER	ADRC	ADDRNUMBER
2	V_ICLPAYMENT	APPROVEDBY	USR02	BNAME
3	V_ICLPAYMENT	BENTYPE	TICL055	BENTYPE
4	V_ICLPAYMENT	BKID	BUT0BK	BKVID
5	V_ICLPAYMENT	CHANGEDBY	USR02	BNAME
6	V_ICLPAYMENT	CLAIM	ICLCLAIM	CLAIM
7	V_ICLPAYMENT	CLIENT	T000	MANDT
8	V_ICLPAYMENT	CL_PAYFREQPLAN	TVS010B	PKEY	REF	1	CN
9	V_ICLPAYMENT	CREATEDBY	USR02	BNAME
10	V_ICLPAYMENT	CURR	TCURC	WAERS
11	V_ICLPAYMENT	ITEM	ICLITEM	ITEM
12	V_ICLPAYMENT	METHOD	TFK042Z	ZLSCH
13	V_ICLPAYMENT	PAYITY	TICL291	PAYITY
14	V_ICLPAYMENT	PYMTYPE	TICL551	PYMTYPE
15	V_ICLPAYMENT	P_CHANGEDBY	USR02	BNAME
16	V_ICLPAYMENT	REASONREJ	TICL112	REASONREJ
17	V_ICLPAYMENT	SCHEDTYPE	TICL180	SCHEDTYPE	REF	1	CN
18	V_ICLPAYMENT	SUBCLAIM	ICLSUBCL	SUBCLAIM
19	V_ICLPAYMENT	TREASON	TICL066	TREASON	REF	C	CN
20	V_ICLPAYMENT	TREASONSET	TICL067	TREASONSET	REF	C	CN