SAP ABAP Table ICL_MI_PAYH (Payments)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_MULTIPLE_INSURANCE (Package) FS-CM: Multiple Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_MI_PAYH	Table Relationship Diagram
Short Description	Payments

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	.INCLUDE	☐				0	0	Claim Payment: Payment Header of Payment
2	.INCLUDE	☐				0	0	Claim Payment: Overview of All Payments
3	SEL	☐	ICL_SEL_PAYO	BOOLE	CHAR	1	0	Flag for Active Payment
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
6	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
7	SUBCLAIM	☐	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
8	PAYMENT	☐	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment	*
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
10	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
11	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
12	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
13	.INCLUDE	☐				0	0	Attributes of ICLPAY
14	.INCLUDE	☐				0	0	Organizational Include (Short Version)
15	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
16	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
17	APPROVEDBY	☐	ICL_PAYMENT13	XUBNAME	CHAR	12	0	Checked By	*
18	APPROVEDTIME	☐	ICL_PAYMENT15UTC	ICL_TIMESTAMP	DEC	15	0	Date Checked (UTC Date+Time)
19	TRANSFERTIME	☐	ICL_PAYMENT17UTC	ICL_TIMESTAMP	DEC	15	0	Transfer Date (UTC Date+Time)
20	DOCUMENTREF	☐	ICL_DOCUMENTREF	ICL_DOCUMENTREF	CHAR	14	0	Reference for Payment Document Created in Subledger
21	POSTDATE	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
22	DOCDATE	☐	ICL_DOCDATE	DATE	DATS	8	0	Document Date of Payment
23	DUEDATE	☐	ICL_DUEDATENET	DATE	DATS	8	0	Due Date for Net Payment
24	XALREADYPAID	☐	ICL_ALREADYPAID	CHAR1	CHAR	1	0	Payment Already Made
25	PAYCAT	☐	ICL_PAYCAT	ICL_PAYCAT	CHAR	1	0	Record Type of Payment
26	PAYTYPE	☐	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
27	SUBSAL	☐	ICL_SUBSAL	ICL_SUBRO	NUMC	3	0	Subrogation/Salvage
28	XPAYEE	☐	ICL_XPAYEE	CHAR1	CHAR	1	0	Additional Payee (ICLPAYEE)
29	ADDRNUMBER	☐	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	*
30	CRECADDR	☐	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	*
31	BKID	☐	ICL_BKID	CHAR4	CHAR	4	0	Bank Details ID
32	CURR	☐	ICL_PAYMENTCUR	WAERS	CUKY	5	0	Claim Payment Currency	TCURC
33	EXCHRATE	☐	ICL_PAYMENT18	KURSF	DEC	9	5	Exchange Rate of Payment Currency into Policy Currency
34	STATUS	☐	ICL_PAYMENT12	ICL_PAYMENT12	CHAR	2	0	Internal Payment Status (Database Status)
35	METHOD	☐	ICL_PAYMENT01	PYMET_KK	CHAR	1	0	Payment Method	*
36	CHECKNUMBER	☐	ICL_CHECK	ICL_CHECK	CHAR	13	0	Check Number for Manual Check Payments
37	NOTE	☐	ICL_PAYMENT04	TEXT50	CHAR	50	0	Payment Note
38	INVOICEREF	☐	ICL_INVOICEREF	CHAR20	CHAR	20	0	External Invoice Number
39	REFCLAIM	☐	ICL_CLAIM_REFPAY	ICL_CLAIM	CHAR	17	0	Claim Number (Reassignment Reference)	*
40	REFSUBCLAIM	☐	ICL_SUBCL_REFPAY	ICL_SUBCL	CHAR	3	0	Subclaim (Reassignment Reference)	*
41	REFPAYMENT	☐	ICL_PAYMENT_REFPAY	ICL_PAYMENT	NUMC	5	0	Claim Payment (Reassignment Reference)	*
42	AMTDONE	☐	ICL_AMOUNT_DONE	ICL_ITAMTS	CURR	15	2	Amount Paid or Received
43	LIABRATE	☐	ICL_LIABRATE_NEG	ICL_PERCENT	DEC	5	2	Negotiated Liability Rate in Percent
44	AMTNEG	☐	ICL_AMOUNTNEG	ICL_ITAMTS	CURR	15	2	Amount Negotiated
45	SUBROSTATUS	☐	ICL_SUBROSTATUS	ICL_SUBROSTATUS	CHAR	1	0	Legal Status of Subrogation
46	TAXROLE	☐	ICL_TAXROLE	ICL_TAXROLE	CHAR	4	0	Tax Role of Claim Payment Recipient	TICL550
47	TAX_RPT	☐	ICL_TAXRPT	XFELD	CHAR	1	0	Flag for Reportable Payments
48	XTAXRPTCT	☐	ICL_XTAXRPTCT	XFELD	CHAR	1	0	Code for Withholding Tax in Statutory Reporting Category
49	MTAXRPTCT	☐	ICL_TAXRPTCT	QSSKZ	CHAR	2	0	Withholding Tax Code for Statutory Reporting	*
50	OVRD_TAXRPTCT	☐	ICL_OVRDTAXRPTCT	XFELD	CHAR	1	0	Manual Withholding Tax Code
51	FUNDSRECDT	☐	ICL_SALVFUNDREC	ICL_SALVFUNDREC	DATS	8	0	Salvage: Funds Received
52	XSALVESTEND	☐	ICL_XSALVESTEND	XFELD	CHAR	1	0	End Estimation of Salvage Value
53	OWNERTYPE_GRP	☐	ICL_OWNERTYPE_GRP3	OTYPE	CHAR	2	0	Responsible Organization Category	*
54	OWNER_GRP	☐	ICL_OWNER_GRP3	XUBNAME	CHAR	12	0	Responsible Organizational Unit	*
55	REASONREJ	☐	ICL_REASONREJ	ICL_REASONREJ	CHAR	2	0	Rejection Reasons for Payments and Reserves	TICL112
56	REFEXTSDOC	☐	ICL_REFEXTSDOC	ICL_PAYMENT	NUMC	5	0	Referenced Statistical Payment Entry	*
57	MOS	☐	ICL_MOS	ICL_MOS	CHAR	3	0	Method of Settlement	*
58	CL_PAYFREQPLAN	☐	ICL_PAYFREQPLAN	PKEY_VK	CHAR	2	0	Payment Frequency of Scheduled Payment	TVS010B
59	PMTTO	☐	ICL_PMTTO	DATUM	DATS	8	0	End Date of a Scheduled Payment
60	PMTFR	☐	ICL_PMTFR	DATUM	DATS	8	0	Start Date of a Scheduled Payment
61	SCHEDTYPE	☐	ICL_SCHEDULE_TYPE	ICL_SCHEDULE_TYPE	CHAR	2	0	Type of Scheduled Payment	TICL180
62	NROFINVREQ	☐	ICL_INVOICES_REQUIRED	NUMC2	NUMC	2	0	Mininum Number of Inbound Invoices
63	DAMAGEDOBJ	☐	ICL_DAMOBJ	ICL_DAMOBJ	NUMC	4	0	Damaged Object	*
64	MIGRATION	☐	ICL_PAYMIGRATION	CHAR1	CHAR	1	0	Indicator for Migrated Payments
65	REQEVALCAT	☐	ICL_REQEVALCAT_D_PE	ICL_REQEVALCAT_PE	CHAR	1	0	Determination Category of Receivable Amount
66	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
67	PAYOUT_SCENARIO	☐	ICL_PAYOUT_SCENARIO_D	ICL_PAYOUT_SCENARIO	CHAR	1	0	Repetitive Payment Scenario
68	.INCLUDE	☐				0	0	Claim Payment: Overview of All Payments
69	.INCLUDE	☐				0	0	Claim Payment: GUI Structure for Date Specifications
70	CREATEDATE	☐	ICL_CREATEDATE	DATE	DATS	8	0	Created On
71	CREATETIMET	☐	ICL_CREATETIME	TIME	TIMS	6	0	Created At
72	CHANGEDATE	☐	ICL_CHANGEDATE	DATE	DATS	8	0	Changed On
73	CHANGETIMET	☐	ICL_CHANGETIME	TIME	TIMS	6	0	Changed at
74	APPROVEDDATE	☐	ICL_PAYMENT14	DATE	DATS	8	0	Date Checked
75	APPROVEDTIMET	☐	ICL_PAYMENT15	TIME	TIMS	6	0	Time Checked
76	TRANSFERDATE	☐	ICL_PAYMENT16	DATE	DATS	8	0	Date Transferred to Disbursements
77	TRANSFERTIMET	☐	ICL_PAYMENT17	TIME	TIMS	6	0	Transfer Time
78	.INCLUDE	☐				0	0	Claim Payment: GUI Structure for Classifying Attributes
79	STATUSTXT	☐	ICL_STATUSTXT	DDTEXT	CHAR	60	0	Name of Status of Claim Payment
80	STATUS_GUI	☐	ICL_STATUS_GUI	ICL_STATUS	CHAR	2	0	Display Status for Payments	*
81	STATUS_GUITXT	☐	ICL_STATUS_GUITXT	TEXT25	CHAR	25	0	Name for Display Status of Payment
82	FINALP	☐	ICL_FINALP	CHAR1	CHAR	1	0	Flag for Final Payment
83	FINALPTXT	☐	ICL_FINALPTXT	CHAR17	CHAR	17	0	Text Field for Claim Payment Category
84	PAYCATTXT	☐	ICL_PAYCATTXT	CHAR30	CHAR	30	0	Long Text of Record Type of a Payment
85	PAYTYPETXT	☐	ICL_PAYTYPETXT	CHAR30	CHAR	30	0	Text for Payment Type (Partial Payment or Final Payment)
86	PYMTYPEDESC	☐	ICL_PYMDESC	TEXT25	CHAR	25	0	Name of Tax Category
87	REACTIVATEDP	☐	ICL_REACTP	CHAR1	CHAR	1	0	Indicator for Reactivated Payment
88	.INCLUDE	☐				0	0	GUI Structure for Attributes Referring to Tax
89	MSSNBPTIN	☐	ICL_MSSNBPTIN	XFELD	CHAR	1	0	Missing Tax ID Number of Business Partner
90	MTAXRPTCTTXT	☐	ICL_TAXRPTCTTXT	TEXT40	CHAR	40	0	Name for Withholding Tax Code Statutory Reporting Category
91	XTAXCALC	☐	ICL_TAXCALC	XFELD	CHAR	1	0	Determine Tax
92	.INCLUDE	☐				0	0	GUI Structure for Attributes with Organizational Unit
93	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
94	.INCLUDE	☐				0	0	GUI Structure for Amounts of a Payment
95	PAMPAID	☐	ICL_PAIDLOSS	ICL_AMOUNT	CURR	15	2	Payments Made
96	REQUESTED	☐	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
97	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	*
98	BENTYPENAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
99	.INCLUDE	☐				0	0	GUI Structure for Attributes Referring to Payment Method
100	METHODTXT	☐	ICL_METHODTXT	FORMT_PAY	CHAR	30	0	Name of Payment Method	*
101	DESCRIPTION	☐	ICL_BANKDSC	CHAR50	CHAR	50	0	Bank details (for payment)
102	DESCRIPTION_STREET	☐	ICL_ADDRDSC	TEXT60	CHAR	60	0	Check Address (Payment)
103	STDADDR	☐	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	*
104	METHOD2	☐	ICL_PAYMENT01	PYMET_KK	CHAR	1	0	Payment Method	*
105	MANCHECK	☐	ICL_CHECKMANUEL	CHAR1	CHAR	1	0	Flag for Manual Check
106	MANCHECK2	☐	ICL_CHECKMANUEL	CHAR1	CHAR	1	0	Flag for Manual Check
107	XBULK	☐	ICL_XBULKPAYMENT	CHAR1	CHAR	1	0	Flag for Bulk Payment
108	XMETHOD_BULK	☐	ICL_XBULKPAYMENT	CHAR1	CHAR	1	0	Flag for Bulk Payment
109	CL_PAYPLANTEXT	☐	ICL_PAYPLAN_TEXT	TEXT30	CHAR	30	0	Payment Frequency of Scheduled Payment
110	.INCLUDE	☐				0	0	GUI Structure for Contract Partner of Payment
111	BPARTNER	☐	ICL_PPAYEE	BU_PARTNER	CHAR	10	0	Claim Payment Recipient	*
112	ROLE	☐	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
113	BP_PUSH	☐	ICL_PUSH	CHAR1	CHAR	1	0	Addressee of Check
114	XNEW	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
115	DESCRIP	☐	ICL_PAYEDSC	CHAR50	CHAR	50	0	Payee
116	ADDRESSEE	☐	ICL_PAYEDSC	CHAR50	CHAR	50	0	Payee
117	BPARTNER2	☐	ICL_ADDPAYEE1N	BU_PARTNER	CHAR	10	0	Name of Additional Payee	ICLPART
118	ROLE2	☐	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
119	ROLENAME2	☐	ICL_ROLEN	TEXT25	CHAR	25	0	Long Name of Participant Role
120	BP_PUSH2	☐	ICL_PUSH	CHAR1	CHAR	1	0	Addressee of Check
121	XNEW2	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
122	TAXROLE2	☐	ICL_TAXROLE	ICL_TAXROLE	CHAR	4	0	Tax Role of Claim Payment Recipient	*
123	ADDPAYEE1	☐	ICL_ADDPAYEE1	CHAR50	CHAR	50	0	Additional Payee (for Check Payments)
124	CRECEIVER	☐	ICL_CRECEIVER	BU_PARTNER	CHAR	10	0	Postal Check Recipient	*
125	PAYER	☐	ICL_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
126	APAYEE	☐	ICL_APAYEE	CHAR14	CHAR	14	0	Display of Additional Payee
127	.INCLUDE	☐				0	0	GUI Structure for Payment Approval Processing
128	XAPPROVE	☐	ICL_XAPPROVE	XFELD	CHAR	1	0	Flag for Mandatory Approval of Payments
129	APPROVAL_REASON	☐	ICL_PAY_AREASON	CHAR1	CHAR	1	0	Approval Reason for a Payment
130	REASONREJT	☐	ICL_REASONREJT	TEXT25	CHAR	25	0	Name of Rejection Reason
131	APPROVEDBY_LONG	☐	ICL_PAYAPPT	CHAR50	CHAR	50	0	Released By
132	REASONAPRT	☐	ICL_REASONREJT	TEXT25	CHAR	25	0	Name of Rejection Reason
133	.INCLUDE	☐				0	0	GUI Structure for Subrogation
134	RECPAYIND	☐	ICL_RECVPAY	XFELD	CHAR	1	0	Indicator: Incoming Payment
135	.INCLUDE	☐				0	0	GUI Structure for Salvage
136	XREFEXTSDOC	☐	ICL_XREFEXTSDOC	ICL_XREFEXTSDOC	CHAR	1	0	Flag: Referenced Statistical Payment Amount
137	REFEXTSDOCTXT	☐	ICL_REFEXTSDOCTXT	CHAR30	CHAR	30	0	Text for Referenced Payment
138	.INCLUDE	☐				0	0	GUI Structure for Collections/Disbursements
139	PYGRP	☐	ICL_PYGRP	CHAR10	CHAR	10	0	Payment Group for FS-CD Interface (for Checks)
140	.INCLUDE	☐				0	0	Park payment alv elements
141	PARK_FLAG	☐	ICL_PARKFLAG	CHECKBOX	CHAR	1	0	Parked Payment
142	POSTING_STATUS	☐	ICL_POSTINGSTATUS	ICL_POSTINGSTATUS	CHAR	4	0	Posting Status of Payment to Collections/Disbursem. System
143	.INCLUDE	☐				0	0	Subrogation Header - GUI Fields Only (Derived from DB)
144	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
145	SUBCLTYPE_NAME	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
146	SUBCLTYPEDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
147	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
148	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
149	COVTYPE_NAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
150	CLAIMANT	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
151	CLAIMANTN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
152	SUBROGEE	☐	ICL_SUBROGEE	BU_PARTNER	CHAR	10	0	Party to Subrogate Against	*
153	SUBROGEEN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
154	INSCOMP	☐	ICL_INSCOMP	BU_PARTNER	CHAR	10	0	Insurance Company of Participant	*
155	INSCOMPN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
156	XNOINS	☐	ICL_XNOINS	XFELD	CHAR	1	0	Flag: Not Insured
157	REFERENCE	☐	ICL_REFERENCE	ICL_REFERENCE	CHAR	30	0	Reference (Contract Number or Customer Number)
158	PAIDLOSS	☐	ICL_PAIDLOSS	ICL_AMOUNT	CURR	15	2	Payments Made
159	DEDUCTIBLE	☐	ICL_DEDUCT	ICL_ITAMTS	CURR	15	2	Deductible
160	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
161	GUILTRATE	☐	ICL_GUILTRATE	ICL_PERCENT	DEC	5	2	Liability Rate
162	XINTRACOMPANY	☐	ICL_INTRACOMPANY	XFELD	CHAR	1	0	Intra-Company
163	INITIAL_RESERVE	☐	ICL_RESERVEFI	ICL_ITAMTS	CURR	15	2	Initial Reserve
164	SUBROPOT	☐	ICL_SUBROPOT	ICL_ITAMTS	CURR	15	2	Subrogation Potential
165	SUBRONEG	☐	ICL_SUBRONEG	ICL_ITAMTS	CURR	15	2	Negotiated Subrogation Amount
166	SUBRONEG_MOD	☐	ICL_SUBRONEG_MOD	ICL_ITAMTS	CURR	15	2	Modified Negotiated Subrogation Amount
167	PAMRECEIVED	☐	ICL_RECEIVED	ICL_ITAMTS	CURR	15	2	Amount Received To Date Including Deductible
168	RECOVERED_LOSS	☐	ICL_RECOVERED_LOSS	ICL_ITAMTS	CURR	15	2	Recovered Loss
169	REIMB_DEDUCTIBLE	☐	ICL_REIMB_DED	ICL_ITAMTS	CURR	15	2	Portion of Deductible to Be Reimbursed
170	.INCLUDE	☐				0	0	GUI Structure for ALV Tree Control
171	NODEKEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
172	PHCODI	☐	ICL_PHCODI	ICL_PHCODI	CHAR	5	0	Category for Processing Payments in Direct Input	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_MI_PAYH	BPARTNER2	ICLPART	PARTICIPANT
2	ICL_MI_PAYH	CHANGEDBY	USR02	BNAME
3	ICL_MI_PAYH	CLAIM	ICLCLAIM	CLAIM
4	ICL_MI_PAYH	CLIENT	T000	MANDT
5	ICL_MI_PAYH	CL_PAYFREQPLAN	TVS010B	PKEY	REF	1	CN
6	ICL_MI_PAYH	CREATEDBY	USR02	BNAME
7	ICL_MI_PAYH	CURR	TCURC	WAERS
8	ICL_MI_PAYH	REASONREJ	TICL112	REASONREJ
9	ICL_MI_PAYH	SCHEDTYPE	TICL180	SCHEDTYPE	REF	1	CN
10	ICL_MI_PAYH	SUBCLAIM	ICLSUBCL	SUBCLAIM
11	ICL_MI_PAYH	TAXROLE	TICL550	TAXROLE

History

Last changed by/on	SAP	20130529
SAP Release Created in	473