SAP ABAP Table P05T_CVZ_UITW (HCIB: Transfer file table)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PY-NL-RP (Application Component) Reporting
     ⤷ P05T (Package) HR Payroll: The Netherlands

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P05T_CVZ_UITW	Table Relationship Diagram
Short Description	HCIB: Transfer file table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	JUPER	☑	P05_REPER	P05_REPER	CHAR	4	0	Representing Legal Person	T5N9P
3	PABRJ	☑	P05T_CVZ_ANPRJ	GJAHR	NUMC	4	0	HCIB for year period
4	PABRP	☑	P05T_CVZ_ANPRP	PABRP	NUMC	2	0	HCIB for period
5	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
6	PERSID	☑	P05T_CVZ_PERSID	NUM3	NUMC	3	0	HCIB: Sequence number instead of personnel number
7	SEQNO	☑	P05T_CVZ_SEQNO	CHAR4	CHAR	4	0	Alphanumeric symbol for HCIB files
8	GDATE	☐	P05T_GDATE	DATS	DATS	8	0	Creation/Change Date
9	GTIME	☐	P05T_GTIME	UZEIT	TIMS	6	0	Creation/Change Hour
10	CVZ_ORGNR	☐	P05T_CVZ_ORGNR	CHAR10	CHAR	10	0	Organization number for HCIB
11	CVZ_ORGCDE	☐	P05T_CVZ_ORGCDE	CHAR12	CHAR	12	0	Organizational key for HCIB
12	CVZ_ID	☐	P05T_CVZ_ID	NUM8	NUMC	8	0	Insured person's identifier with HCIB
13	CVZ_MAAND	☐	P05T_CVZ_MAAND	NUM2	NUMC	2	0	Month for HCIB
14	CVZ_JAAR	☐	P05T_CVZ_JAAR	NUM4	NUMC	4	0	Year for HCIB
15	CVZ_ACTUEEL	☐	P05T_CVZ_ACTUEEL	P05T_CVZ_ACTUEEL	NUMC	1	0	Current status of insured person for HCIB
16	CVZ_INH_NOMINAAL	☐	P05T_CVZ_INH_NOMINAAL	P05T_CVZ_BEDRAG	DEC	6	2	Deduction for nominal ZVW contribution
17	CVZ_INH_ZVW	☐	P05T_CVZ_INH_ZVW	P05T_CVZ_PERC	DEC	4	3	Translation factor for deduction of ZVW contribution
18	CVZ_INH_AWBZ	☐	P05T_CVZ_INH_AWBZ	P05T_CVZ_PERC	DEC	4	3	Conversion factor for deduction of AWBZ contribution
19	CVZ_HM	☐	P05T_CVZ_HM	P05T_CVZ_HM	CHAR	1	0	Registration number of main person insured/co-insured
20	CVZ_ID_HV	☐	P05T_CVZ_ID_HV	NUM8	NUMC	8	0	Main person insured's identifier for co-insured person
21	CVZ_GESLACHT	☐	P05T_CVZ_GESLACHT	P05T_CVZ_GESLACHT	CHAR	1	0	Gender of insured person
22	CVZ_OVERL	☐	P05T_CVZ_OVERL	P05T_CVZ_OVERL	NUMC	1	0	Reference number deceased
23	CVZ_VOORLETTERS	☐	P05T_CVZ_VOORLETTERS	TEXT6	CHAR	6	0	Initials
24	CVZ_VOORVOEGSEL	☐	P05T_CVZ_VOORVOEGSEL	TEXT10	CHAR	10	0	Name Prefix
25	CVZ_ACHTERNAAM	☐	P05T_CVZ_ACHTERNAAM	TEXT70	CHAR	70	0	Last Name
26	CVZ_PARTNERNAAM	☐	P05T_CVZ_PARTNERNAAM	TEXT35	CHAR	35	0	Partner Name
27	CVZ_ADRES	☐	P05T_CVZ_ADRES	TEXT55	CHAR	55	0	Address for Health Care Insurance Board
28	CVZ_POSTCODE	☐	P05T_CVZ_POSTCODE	CHAR8	CHAR	8	0	Postal Code for HCIB
29	CVZ_WOONPLAATS	☐	P05T_CVZ_WOONPLAATS	TEXT24	CHAR	24	0	City for HCIB
30	CVZ_LAND	☐	P05T_CVZ_LAND	CHAR2	CHAR	2	0	Country indicator for HCIB
31	CVZ_SOFINUMMER	☐	P05T_CVZ_SOFINUMMER	NUM9	NUMC	9	0	Social Security Number for HCIB
32	CVZ_GBDAT	☐	P05T_CVZ_GEBOORTEDATUM	P05T_CVZ_DATUM	CHAR	10	0	Date of Birth for HCIB
33	CVZ_DT_START	☐	P05T_CVZ_DT_START	P05T_CVZ_DATUM	CHAR	10	0	Start Date Deduction
34	CVZ_DT_EIND	☐	P05T_CVZ_DT_EIND	P05T_CVZ_DATUM	CHAR	10	0	End Date deduction
35	CVZ_REGNR	☐	P05T_CVZ_REGISTRATIENR	CHAR20	CHAR	20	0	External registration number
36	FOUTMELDING	☐	P05T_CVZ_FOUTMELDING	P05T_CVZ_FOUTMELDING	NUMC	2	0	Error message code
37	REGNR	☐	P05T_CVZ_REGISTRATIENR	CHAR20	CHAR	20	0	External registration number
38	INH_NOMINAAL	☐	P05T_CVZ_INH_NOMINAAL	P05T_CVZ_BEDRAG	DEC	6	2	Deduction for nominal ZVW contribution
39	INH_PERC_ZVW	☐	P05T_CVZ_INH_ZVW	P05T_CVZ_PERC	DEC	4	3	Translation factor for deduction of ZVW contribution
40	INH_ZVW	☐	P05T_CVZ_INH_BDRG_ZVW	P05T_CVZ_BEDRAG	DEC	6	2	Amount of deduction by pension fund for ZVW contribution
41	INH_PERC_AWBZ	☐	P05T_CVZ_INH_AWBZ	P05T_CVZ_PERC	DEC	4	3	Conversion factor for deduction of AWBZ contribution
42	INH_AWBZ	☐	P05T_CVZ_INH_BDRG_AWBZ	P05T_CVZ_BEDRAG	DEC	6	2	Amount of deduction by pension fund for AWBZ contribution
43	DT_START	☐	P05T_CVZ_DT_START	P05T_CVZ_DATUM	CHAR	10	0	Start Date Deduction
44	DT_EIND	☐	P05T_CVZ_DT_EIND	P05T_CVZ_DATUM	CHAR	10	0	End Date deduction
45	ORGCDE	☐	P05T_CVZ_ORGCDE	CHAR12	CHAR	12	0	Organizational key for HCIB
46	CVZ_FACTOR	☐	P05T_CVZ_FACTOR	P05T_CVZ_FACTOR	DEC	8	7	Country of residence factor
47	CVZ_INH_NOM_F	☐	P05T_CVZ_INH_NOM_F	P05T_CVZ_BEDRAG	DEC	6	2	Nominal contribution amount, adjusted for COR HCIB
48	CVZ_INH_ZVW_F	☐	P05T_CVZ_INH_ZVW_F	P05T_CVZ_BEDRAG	DEC	6	2	Amount ZVW, adjusted for country of residence factor HCIB
49	CVZ_INH_AWBZ_F	☐	P05T_CVZ_INH_AWBZ_F	P05T_CVZ_BEDRAG	DEC	6	2	AWBZ amount, adjusted for country of residence factor HCIB
50	CVZ_DT_OVERL	☐	P05T_CVZ_DT_OVERL	P05T_CVZ_DATUM	CHAR	10	0	Date of death
51	DT_OVERL	☐	P05T_CVZ_DT_OVERL	P05T_CVZ_DATUM	CHAR	10	0	Date of death
52	PREMIELOON_ZVW	☐	P05T_CVZ_PREMIELOON_ZVW	P05T_CVZ_PREMIELOON	DEC	8	2	Cumulative Zvw premium rate (as of 1 Jan. of current year)
53	PREMIELOON_AWBZ	☐	P05T_CVZ_PREMIELOON_AWBZ	P05T_CVZ_PREMIELOON	DEC	8	2	Cumulative premium rate AWBZ (beginning 1 Jan of current yr)
54	WOONLAND	☐	P05T_CVZ_LAND	CHAR2	CHAR	2	0	Country indicator for HCIB
55	FACTOR	☐	P05T_CVZ_FACTOR	P05T_CVZ_FACTOR	DEC	8	7	Country of residence factor
56	CVZ_AANTAL_VERZ	☐	P05T_CVZ_AANT_VERZ	P05T_CVZ_AANT_VERZ	DEC	2	0	Number of insured persons for whom contribution is deducted
57	AANTAL_VER	☐	P05T_CVZ_AANT_VERZ	P05T_CVZ_AANT_VERZ	DEC	2	0	Number of insured persons for whom contribution is deducted
58	ALL_OUDEREN_KORT	☐	P05T_CVZ_ALL_OUDEREN_KORTING		CHAR	1	0	Care Insurance Board: All Elderly Persons' Tax Credit
59	CVZ_INH_ZVW_2008	☐	P05T_CVZ_INH_ZVW_2008	P05T_CVZ_PERC_2008	DEC	6	5	Conversion Factor for Deduction of Zvw Contribution (2008)
60	CVZ_IH_AWBZ_2008	☐	P05T_CVZ_INH_AWBZ_2008	P05T_CVZ_PERC_2008	DEC	6	5	Conversion Factor for AWBZ Contribution (2008)
61	INH_PER_ZVW_2008	☐	P05T_CVZ_INH_ZVW_2008	P05T_CVZ_PERC_2008	DEC	6	5	Conversion Factor for Deduction of Zvw Contribution (2008)
62	INH_PR_AWBZ_2008	☐	P05T_CVZ_INH_AWBZ_2008	P05T_CVZ_PERC_2008	DEC	6	5	Conversion Factor for AWBZ Contribution (2008)
63	CVZ_IH_ZVW_F_08	☐	P05T_CVZ_INH_ZVW_F_2008	P05T_CVZ_CONV_FACTOR	DEC	5	4	Amount Zvw, adjusted for country of residence factor CVZ
64	CVZ_IH_AWBZ_F_08	☐	P05T_CVZ_INH_AWBZ_F_2008	P05T_CVZ_CONV_FACTOR	DEC	5	4	AWBZ amount, adjusted for country of residence factor CVZ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05T_CVZ_UITW	JUPER	T5N9P	REPER	KEY	1	CN
2	P05T_CVZ_UITW	MANDT	T000	MANDT	KEY	1	CN
3	P05T_CVZ_UITW	PERNR	PA0003	PERNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	700