SAP ABAP Table ICLREPETITIVEPAY (Repetitive Payments)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICLREPETITIVEPAY	Table Relationship Diagram
Short Description	Repetitive 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
4	POSNR	☐	SCCOUNT_SC	SCCOUNT_SC	CHAR	12	0	Item ID
5	SCPOSNR	☐	TIMST_VK	TIMST_VK	CHAR	14	0	Time Stamp (Date and Time)
6	BLTYP	☐	BLTP1_SC	BLTP1_SC	CHAR	2	0	Payment Plan Item Category	*
7	ARCHI	☐	ARCHI_SC	XFELD	CHAR	1	0	Payment item can be written to archive
8	PSNGL	☐	PSNGL_SC	XFELD	CHAR	1	0	Indicator: One-Time Payment
9	PMTFR	☐	PMFTR_SC	DATUM	DATS	8	0	Valid-From Date for Payment Plan Item
10	PMTTO	☐	PMTTO_SC	DATUM	DATS	8	0	Valid-to date for payment plan items
11	RISKFR	☐	RISKFR_SC	DATUM	DATS	8	0	Valid-From Date for Payment Plan Item Risk
12	RISKTO	☐	RISKTO_SC	DATUM	DATS	8	0	Valid-To Date for Risk for Payment Plan Item
13	GSFNR	☐	GSFNR_VK	GSFNR_VK	CHAR	16	0	Business Transaction Number
14	PMEND	☐	PMEND_SC	DATUM	DATS	8	0	End early on
15	RENEW	☐	RENEW_SC	XFELD	CHAR	1	0	Indicator: Renew Item
16	RNEWX	☐	RNEWX_SC	NUMC3	NUMC	3	0	Number of Automatically Renewed Items
17	CCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
18	OPCCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	OPGSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	PRGRP	☐	PRGRP_VK	PRGRP_VK	CHAR	2	0	Product Group	TKKVPRGRP
22	INSTAXS	☐	INSTAXS_VK	INSTAXS_VK	CHAR	4	0	Insurance Tax Schedule	TKKV007A
23	VSARL_VX	☐	VSARL_VX	VSARL_VX	CHAR	6	0	Insurance Type	TLXXVAL
24	AMOUNT_TOTAL	☐	BETRW_SC	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
25	ATFRD	☐	ATFRD_SC	DATUM	DATS	8	0	Valid-From Date for Amount Changes
26	AMOUNT_TRANS	☐	XBETRW_SC	WRTV7	CURR	13	2	Current distrib.amount of payment plan item
27	AMOUNT_NEED	☐	AMNEED_SC	WRTV7	CURR	13	2	Total amount when canceling payment plan early
28	CHARGE_NEED	☐	CHNEED_SC	WRTV7	CURR	13	2	Charges Amount When Ending Payment Plan Item
29	CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	PAYMENTFR	☐	PAYMENTFR_SC	NUM03	NUMC	3	0	Lower Limit for Customer-Initiated Payment (in Percent)
31	PAYMENTTO	☐	PAYMENTTO_SC	NUM03	NUMC	3	0	Upper Limit for Customer-Initiated Payment (in Percent)
32	CRUSER	☐	CRUSER_SC	USNAM	CHAR	12	0	Name of Person who Added Object
33	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
34	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
35	OPHVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
36	OPTVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
37	S_HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	*
38	H_HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	*
39	KONTT	☐	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	*
40	KONTL	☐	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
41	OPKONTT	☐	KONTT_KK	KONTT_KK	CHAR	2	0	Account Assignment Category	*
42	OPKONTL	☐	KONTL_KK	CHAR50	CHAR	50	0	Acct assnmnt string for industry-specific account assngments
43	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
44	BLART	☐	BLART_KK	BLART_KK	CHAR	2	0	Document Type	TFK003
45	VTRE2	☐	VTRE2_SC	VTREF_KK	CHAR	20	0	Reference to Insurance Object
46	VTRE3	☐	VTRE3_SC	VTREF_KK	CHAR	20	0	Target Insurance Object for Cross-Company Code Postings
47	XDERE	☐	XDEREN_SC	XFELD	CHAR	1	0	Indicator: Debt Recognition
48	XDIST	☐	XDIST_SC	XFELD	CHAR	1	0	Indicator: Manual Distribution of Amount in Item
49	VGPART2	☐	VGPART2_SC	BU_PARTNER	CHAR	10	0	Business Partner for Referenced Contract	*
50	VGPART3	☐	VGPART3_SC	BU_PARTNER	CHAR	10	0	Target Business Partner for Cross-Company Code Posting	*
51	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
52	PYGRP	☐	PYGRP_KK	CHAR10	CHAR	10	0	Grouping field for automatic payments
53	GRKEY	☐	GRKEY_KK	CHAR3	CHAR	3	0	Grouping Key for Displaying Open Items
54	VOPBEL	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
55	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
56	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	T059Q
57	STRKZ	☐	STRKZ_KK	STRKZ_KK	CHAR	2	0	Tax Code for Other Taxes	TFK007F
58	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
59	.INCLUDE	☐				0	0	Scheduling Structure for Posting of Single Documents
60	EMGPA	☐	EMGPA_KK	BU_PARTNER	CHAR	10	0	Alternative business partner for payments	BUT000
61	EMBVT	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
62	EMADR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
63	EMCCID	☐	CCID_KK	CHAR6	CHAR	6	0	Payment Card ID for Payments
64	PYMET	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	*
65	PYBUK	☐	PYBUK_KK	BUKRS	CHAR	4	0	Company Code for Automatic Payment Transactions	*
66	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
67	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
68	FAEDS	☐	FAEDS_KK	DATUM	DATS	8	0	Due Date for Cash Discount
69	SKTPZ	☐	SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
70	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
71	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
72	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
73	STUDT	☐	STUDT_KK	DATUM	DATS	8	0	Deferral to
74	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
75	DUN_REASON	☐	DUN_LOCKREASON_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	*
76	DUN_REASON_DAYS	☐	LOCK_DAYS_KK	LOCK_DAYS_KK	NUMC	3	0	Number Of Days An Object Remains Locked
77	PAY_REASON	☐	SPZAH_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Automatic Payment	*
78	PAY_REASON_DAYS	☐	LOCK_DAYS_KK	LOCK_DAYS_KK	NUMC	3	0	Number Of Days An Object Remains Locked
79	CLR_REASON	☐	CLRLO_KK	SPPOS_KK	CHAR	1	0	Clearing Lock Reason	*
80	CLR_REASON_DAYS	☐	LOCK_DAYS_KK	LOCK_DAYS_KK	NUMC	3	0	Number Of Days An Object Remains Locked
81	INT_REASON	☐	SPERZ_KK	SPERZ_KK	CHAR	1	0	Interest Lock Reason	*
82	INT_REASON_DAYS	☐	LOCK_DAYS_KK	LOCK_DAYS_KK	NUMC	3	0	Number Of Days An Object Remains Locked
83	REFCLAIM	☐	REFCLAIM_VK	CHAR8	CHAR	8	0	Reference to Payment in Claims Management System
84	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
85	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
86	TPYMET	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
87	TABWZAE_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
88	TABWZAE_ADR	☐	BU_ADDSC	TEXT60	CHAR	60	0	BP: Address Description
89	XABWZAE_FIX	☐	BU_ADFIX	XFELD	CHAR	1	0	Use fixed address
90	TBANKV	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
91	TCCARD	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
92	.INCLUDE	☐				0	0
93	VTREF_TRANSPOST	☐	VTREF_TRANSPOST_SC	VTREF_KK	CHAR	20	0	Target Insurance Object for Subledger Transfer Posting
94	VGPART_TRANSPOST	☐	VGPART_TRANSPOST_SC	BU_PARTNER	CHAR	10	0	Target Business Partner for Subledger Transfer Posting	*
95	STRNETTO	☐	STRNETTO_SC	STRNETTO_SC	CHAR	1	0	Net Tax
96	STATPOST	☐	STATPOST_SC	XFELD	CHAR	1	0	Post Payment Plan Item w/o Posting Stat.?
97	INSOBJECT	☐	INSOBJECT_MD	INSOBJECT_MD	CHAR	20	0	Identification for an Insurance Object	*
98	INSOBJECTTYP	☐	INSOBJECTTYPC_MD	INSOBJECTTYPC_MD	CHAR	2	0	IO: External Insurance Object Category	*
99	CL_PAYOPTKEY	☐	ICL_PAYOPTKEY	POKEY_VK	CHAR	2	0	Payment Option Key in Claim	*
100	CL_PAYFREQPLAN	☐	ICL_PAYFREQPLAN	PKEY_VK	CHAR	2	0	Payment Frequency of Scheduled Payment	*
101	CL_PAYPLANTEXT	☐	ICL_PAYPLAN_TEXT	TEXT30	CHAR	30	0	Payment Frequency of Scheduled Payment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLREPETITIVEPAY	BLART	TFK003	BLART		1	CN
2	ICLREPETITIVEPAY	CCODE	T001	BUKRS
3	ICLREPETITIVEPAY	CURR	TCURC	WAERS
4	ICLREPETITIVEPAY	EMGPA	BUT000	PARTNER
5	ICLREPETITIVEPAY	FDGRP	T035	GRUPP
6	ICLREPETITIVEPAY	GSBER	TGSB	GSBER
7	ICLREPETITIVEPAY	HVORG	TFKHVO	HVORG		1	CN
8	ICLREPETITIVEPAY	IKEY	TFK056A	IKEY
9	ICLREPETITIVEPAY	INSTAXS	TKKV007A	INSTAXS	KEY	1	CN
10	ICLREPETITIVEPAY	KOSTL	CSKS	KOSTL
11	ICLREPETITIVEPAY	MWSKZ	T007A	MWSKZ		1	CN
12	ICLREPETITIVEPAY	OPCCODE	T001	BUKRS
13	ICLREPETITIVEPAY	OPGSBER	TGSB	GSBER
14	ICLREPETITIVEPAY	OPHVORG	TFKHVO	HVORG		1	CN
15	ICLREPETITIVEPAY	OPTVORG	TFKTVO	TVORG		1	CN
16	ICLREPETITIVEPAY	PRCTR	CEPC	PRCTR
17	ICLREPETITIVEPAY	PRGRP	TKKVPRGRP	PRGRP		1	CN
18	ICLREPETITIVEPAY	QSSKZ	T059Q	QSSKZ
19	ICLREPETITIVEPAY	STRKZ	TFK007F	STRKZ
20	ICLREPETITIVEPAY	TVORG	TFKTVO	TVORG		1	CN
21	ICLREPETITIVEPAY	VSARL_VX	TLXXVAL	VSARL_VX

History

Last changed by/on	SAP	20131127
SAP Release Created in	471