SAP ABAP Table ICL_SUBROREQ_S_UI (Subrogation/Recovery Receivable incl.User Interface Fields)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_SUBROGATION_UI (Package) Claims: Subrogation: User Interface Layer

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_SUBROREQ_S_UI	Table Relationship Diagram
Short Description	Subrogation/Recovery Receivable incl.User Interface Fields

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	Subrogation/Recovery Receivable: Persistent + Logical Fields
2	.INCLUDE	☐				0	0	Claim Payment
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
5	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
6	SUBCLAIM	☐	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
7	PAYMENT	☐	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment	*
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Attributes of ICLPAY
13	.INCLUDE	☐				0	0	Organizational Include (Short Version)
14	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
15	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
16	APPROVEDBY	☐	ICL_PAYMENT13	XUBNAME	CHAR	12	0	Checked By	USR02
17	APPROVEDTIME	☐	ICL_PAYMENT15UTC	ICL_TIMESTAMP	DEC	15	0	Date Checked (UTC Date+Time)
18	TRANSFERTIME	☐	ICL_PAYMENT17UTC	ICL_TIMESTAMP	DEC	15	0	Transfer Date (UTC Date+Time)
19	DOCUMENTREF	☐	ICL_DOCUMENTREF	ICL_DOCUMENTREF	CHAR	14	0	Reference for Payment Document Created in Subledger
20	POSTDATE	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
21	DOCDATE	☐	ICL_DOCDATE	DATE	DATS	8	0	Document Date of Payment
22	DUEDATE	☐	ICL_DUEDATENET	DATE	DATS	8	0	Due Date for Net Payment
23	XALREADYPAID	☐	ICL_ALREADYPAID	CHAR1	CHAR	1	0	Payment Already Made
24	PAYCAT	☐	ICL_PAYCAT	ICL_PAYCAT	CHAR	1	0	Record Type of Payment
25	PAYTYPE	☐	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
26	SUBSAL	☐	ICL_SUBSAL	ICL_SUBRO	NUMC	3	0	Subrogation/Salvage
27	XPAYEE	☐	ICL_XPAYEE	CHAR1	CHAR	1	0	Additional Payee (ICLPAYEE)
28	ADDRNUMBER	☐	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	ADRC
29	CRECADDR	☐	ICL_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address Number for Checks	*
30	BKID	☐	ICL_BKID	CHAR4	CHAR	4	0	Bank Details ID	BUT0BK
31	CURR	☐	ICL_PAYMENTCUR	WAERS	CUKY	5	0	Claim Payment Currency	TCURC
32	EXCHRATE	☐	ICL_PAYMENT18	KURSF	DEC	9	5	Exchange Rate of Payment Currency into Policy Currency
33	STATUS	☐	ICL_PAYMENT12	ICL_PAYMENT12	CHAR	2	0	Internal Payment Status (Database Status)
34	METHOD	☐	ICL_PAYMENT01	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
35	CHECKNUMBER	☐	ICL_CHECK	ICL_CHECK	CHAR	13	0	Check Number for Manual Check Payments
36	NOTE	☐	ICL_PAYMENT04	TEXT50	CHAR	50	0	Payment Note
37	INVOICEREF	☐	ICL_INVOICEREF	CHAR20	CHAR	20	0	External Invoice Number
38	REFCLAIM	☐	ICL_CLAIM_REFPAY	ICL_CLAIM	CHAR	17	0	Claim Number (Reassignment Reference)	*
39	REFSUBCLAIM	☐	ICL_SUBCL_REFPAY	ICL_SUBCL	CHAR	3	0	Subclaim (Reassignment Reference)	*
40	REFPAYMENT	☐	ICL_PAYMENT_REFPAY	ICL_PAYMENT	NUMC	5	0	Claim Payment (Reassignment Reference)	*
41	AMTDONE	☐	ICL_AMOUNT_DONE	ICL_ITAMTS	CURR	15	2	Amount Paid or Received
42	LIABRATE	☐	ICL_LIABRATE_NEG	ICL_PERCENT	DEC	5	2	Negotiated Liability Rate in Percent
43	AMTNEG	☐	ICL_AMOUNTNEG	ICL_ITAMTS	CURR	15	2	Amount Negotiated
44	SUBROSTATUS	☐	ICL_SUBROSTATUS	ICL_SUBROSTATUS	CHAR	1	0	Legal Status of Subrogation
45	TAXROLE	☐	ICL_TAXROLE	ICL_TAXROLE	CHAR	4	0	Tax Role of Claim Payment Recipient	*
46	TAX_RPT	☐	ICL_TAXRPT	XFELD	CHAR	1	0	Flag for Reportable Payments
47	XTAXRPTCT	☐	ICL_XTAXRPTCT	XFELD	CHAR	1	0	Code for Withholding Tax in Statutory Reporting Category
48	MTAXRPTCT	☐	ICL_TAXRPTCT	QSSKZ	CHAR	2	0	Withholding Tax Code for Statutory Reporting	*
49	OVRD_TAXRPTCT	☐	ICL_OVRDTAXRPTCT	XFELD	CHAR	1	0	Manual Withholding Tax Code
50	FUNDSRECDT	☐	ICL_SALVFUNDREC	ICL_SALVFUNDREC	DATS	8	0	Salvage: Funds Received
51	XSALVESTEND	☐	ICL_XSALVESTEND	XFELD	CHAR	1	0	End Estimation of Salvage Value
52	OWNERTYPE_GRP	☐	ICL_OWNERTYPE_GRP3	OTYPE	CHAR	2	0	Responsible Organization Category	*
53	OWNER_GRP	☐	ICL_OWNER_GRP3	XUBNAME	CHAR	12	0	Responsible Organizational Unit	*
54	REASONREJ	☐	ICL_REASONREJ	ICL_REASONREJ	CHAR	2	0	Rejection Reasons for Payments and Reserves	TICL112
55	REFEXTSDOC	☐	ICL_REFEXTSDOC	ICL_PAYMENT	NUMC	5	0	Referenced Statistical Payment Entry	*
56	MOS	☐	ICL_MOS	ICL_MOS	CHAR	3	0	Method of Settlement	*
57	CL_PAYFREQPLAN	☐	ICL_PAYFREQPLAN	PKEY_VK	CHAR	2	0	Payment Frequency of Scheduled Payment	TVS010B
58	PMTTO	☐	ICL_PMTTO	DATUM	DATS	8	0	End Date of a Scheduled Payment
59	PMTFR	☐	ICL_PMTFR	DATUM	DATS	8	0	Start Date of a Scheduled Payment
60	SCHEDTYPE	☐	ICL_SCHEDULE_TYPE	ICL_SCHEDULE_TYPE	CHAR	2	0	Type of Scheduled Payment	TICL180
61	NROFINVREQ	☐	ICL_INVOICES_REQUIRED	NUMC2	NUMC	2	0	Mininum Number of Inbound Invoices
62	DAMAGEDOBJ	☐	ICL_DAMOBJ	ICL_DAMOBJ	NUMC	4	0	Damaged Object	*
63	MIGRATION	☐	ICL_PAYMIGRATION	CHAR1	CHAR	1	0	Indicator for Migrated Payments
64	REQEVALCAT	☐	ICL_REQEVALCAT_D_PE	ICL_REQEVALCAT_PE	CHAR	1	0	Determination Category of Receivable Amount
65	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
66	PAYOUT_SCENARIO	☐	ICL_PAYOUT_SCENARIO_D	ICL_PAYOUT_SCENARIO	CHAR	1	0	Repetitive Payment Scenario
67	.INCLUDE	☐				0	0	Claim Payment: GUI Structure for Date Specifications
68	CREATEDATE	☐	ICL_CREATEDATE	DATE	DATS	8	0	Created On
69	CREATETIMET	☐	ICL_CREATETIME	TIME	TIMS	6	0	Created At
70	CHANGEDATE	☐	ICL_CHANGEDATE	DATE	DATS	8	0	Changed On
71	CHANGETIMET	☐	ICL_CHANGETIME	TIME	TIMS	6	0	Changed at
72	APPROVEDDATE	☐	ICL_PAYMENT14	DATE	DATS	8	0	Date Checked
73	APPROVEDTIMET	☐	ICL_PAYMENT15	TIME	TIMS	6	0	Time Checked
74	TRANSFERDATE	☐	ICL_PAYMENT16	DATE	DATS	8	0	Date Transferred to Disbursements
75	TRANSFERTIMET	☐	ICL_PAYMENT17	TIME	TIMS	6	0	Transfer Time
76	STATUS_GUI	☐	ICL_STATUS_GUI	ICL_STATUS	CHAR	2	0	Display Status for Payments	*
77	METHODTXT	☐	ICL_METHODTXT	FORMT_PAY	CHAR	30	0	Name of Payment Method	*
78	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
79	PAMPAID	☐	ICL_PAMPAID	ICL_ITAMTS	CURR	15	2	Total Sum of Relevant Payment Orders
80	REQUESTED	☐	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
81	REQUESTED_ORIG	☐	ICL_REQUESTED_ORIG	ICL_ITAMTS	CURR	15	2	Original Amount Requested
82	DESCRIPTION	☐	ICL_BANKDSC	CHAR50	CHAR	50	0	Bank details (for payment)
83	PAYER	☐	ICL_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
84	PAYERN	☐	ICL_PAYERN_D	CHAR50	CHAR	50	0	Description of Payer
85	PARK_FLAG	☐	ICL_SBRREQ_PARKFLAG_D_AL	CHECKBOX	CHAR	1	0	Receivable Is Parked
86	POSTING_STATUS	☐	ICL_POSTINGSTATUS	ICL_POSTINGSTATUS	CHAR	4	0	Posting Status of Payment to Collections/Disbursem. System
87	NEGID	☐	ICL_NEGID_D_PE	SYSUUID_C	CHAR	32	0	Negotiation ID	ICL_NEG
88	NEGNAME	☐	ICL_NEGNAME_D_PE	ICL_NEGNAME_PE	CHAR	10	0	Unique Technical Name of Negotiation
89	NEGDESCR	☐	ICL_NEGDESCR_D_PE	TEXT60	CHAR	60	0	Description of Negotiation
90	NEGTYPE	☐	ICL_NEGTYPE_D_PE	ICL_NEGTYPE_PE	CHAR	1	0	Key of Negotiation Type	*
91	SUBROG_GUID	☐	ICL_SUBROG_GUID_D_PE	SYSUUID_C	CHAR	32	0	Universal Unique Identifier of Subrogation/Recovery
92	STATUSTXT	☐	ICL_SBRREQ_STATUSTXT_D_UI	DDTEXT	CHAR	60	0	Name of Status of Receivable in the Claim
93	STATUS_GUITXT	☐	ICL_SBRREQ_STATUS_GUITXT_D_UI	TEXT25	CHAR	25	0	Name for Display Status of Receivable
94	NEGTYPEN	☐	ICL_NEGTYPEN_D_PE	TEXT30	CHAR	30	0	Name of Type of Negotiation
95	REQEVALCATN	☐	ICL_REQEVALCATN_D_UI	DDTEXT	CHAR	60	0	Name: Determination Category of Receivable Amount
96	XSELECT	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
97	DETAIL_SELECT	☐	ICL_DETAIL_SELECT		CHAR	50	0	Details
98	COLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_SUBROREQ_S_UI	ADDRNUMBER	ADRC	ADDRNUMBER
2	ICL_SUBROREQ_S_UI	APPROVEDBY	USR02	BNAME
3	ICL_SUBROREQ_S_UI	BKID	BUT0BK	BKVID
4	ICL_SUBROREQ_S_UI	CHANGEDBY	USR02	BNAME
5	ICL_SUBROREQ_S_UI	CLAIM	ICLCLAIM	CLAIM
6	ICL_SUBROREQ_S_UI	CLIENT	T000	MANDT
7	ICL_SUBROREQ_S_UI	CL_PAYFREQPLAN	TVS010B	PKEY	REF	1	CN
8	ICL_SUBROREQ_S_UI	CREATEDBY	USR02	BNAME
9	ICL_SUBROREQ_S_UI	CURR	TCURC	WAERS
10	ICL_SUBROREQ_S_UI	METHOD	TFK042Z	ZLSCH
11	ICL_SUBROREQ_S_UI	NEGID	ICL_NEG	NEGID	REF	C	CN
12	ICL_SUBROREQ_S_UI	REASONREJ	TICL112	REASONREJ
13	ICL_SUBROREQ_S_UI	SCHEDTYPE	TICL180	SCHEDTYPE	REF	1	CN
14	ICL_SUBROREQ_S_UI	SUBCLAIM	ICLSUBCL	SUBCLAIM

History

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