SAP ABAP Table P02_GETIS_EE (Employee Data Withholding Tax Geneva (GeTIS))

Hierarchy

☛ SAP_HRCCH (Software Component) Sub component SAP_HRCCH of SAP_HR
   ⤷ PY-CH (Application Component) Switzerland
     ⤷ PC02 (Package) HR Payroll: Switzerland

Basic Data

Table Category	INTTAB	Structure
Structure	P02_GETIS_EE	Table Relationship Diagram
Short Description	Employee Data Withholding Tax Geneva (GeTIS)

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	ABRNR	☐	P02_ABRNR	CHAR20	CHAR	20	0	Accounting number
2	ABREH	☐	P02_ABREHQST	P02_ABREHQST	CHAR	8	0	Payroll Unit - Withholding Tax	T5C2M
3	SWERR	☐	P02_GETIS_ERROR	XFELD	CHAR	1	0	Error Indicator
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
6	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
7	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
8	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
9	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
10	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
11	FAMST_GETIS	☐	P02_GETIS_FAMST	P02_GETIS_FAMST	NUMC	1	0	Marital Status Key for File (GeTIS)
12	KONKU	☐	P02_GETIS_KONKU	P02_GETIS_O_N	CHAR	1	0	Indicator for Cohabitation (GeTIS)
13	KONFE	☐	P02_GETIS_KONFE	KONFE	CHAR	2	0	Religion Key from Infotype 0002 (Personal Data)	T516T
14	KONFE_GETIS	☐	P02_GETIS_CONFE	P02_GETIS_KONFE	NUMC	2	0	Religion Key for File (GeTIS)
15	FANAM	☐	P02_GETIS_FANAM	PAD_NACHN	CHAR	40	0	Partner Surname
16	FAVOR	☐	P02_GETIS_FAVOR	TEXT25	CHAR	25	0	First Name of Partner
17	CONTS	☐	P02_GETIS_CONTS	P02_GETIS_O_N	CHAR	1	0	Spouse Works in Switzerland (GeTIS)
18	ANZKI	☐	P02_GETIS_ANZKD	DEC03	DEC	3	0	Number of Children for File (GeTIS)
19	GB_K1	☐	P02_GETIS_GBKND	GBDAT	DATS	8	0	Child's Date of Birth
20	GB_K2	☐	P02_GETIS_GBKND	GBDAT	DATS	8	0	Child's Date of Birth
21	GB_K3	☐	P02_GETIS_GBKND	GBDAT	DATS	8	0	Child's Date of Birth
22	GB_K4	☐	P02_GETIS_GBKND	GBDAT	DATS	8	0	Child's Date of Birth
23	GB_K5	☐	P02_GETIS_GBKND	GBDAT	DATS	8	0	Child's Date of Birth
24	WORT01	☐	P02_GETIS_WORT	ORT01	CHAR	35	0	City from Infotype 0006 (Addresses)
25	WSTRASHNR	☐	P02_GETIS_STRASHNR	TEXT60	CHAR	60	0	Street and House Number from Infotype 0006 (Addresses)
26	WSTRAS	☐	P02_GETIS_STRAS	P02_GETIS_STRAS	CHAR	40	0	Street Name (GeTIS)
27	WHNR	☐	P02_GETIS_HNR	P02_GETIS_HNR	CHAR	8	0	House number
28	WCP	☐	P02_GETIS_CP	TEXT20	CHAR	20	0	PO Box (GeTIS)
29	WPSTLZ	☐	P02_GETIS_WPLZ	PSTLZ	CHAR	10	0	Postal Code of City According to Addresses Infotype (0006)
30	WKANTO	☐	KANTO	CHAR2	CHAR	2	0	Canton Indicator
31	WLAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
32	WPACA	☐	P02_GETIS_PACA		CHAR	6	0	Country or Canton of Residence for File (GeTIS)
33	WLOCCG	☐	P02_GETIS_LOCCG	P02_GETIS_LOCCD	NUMC	2	0	Municipality Key for Residence in Canton of Geneva (GeTIS)	*
34	WLOCHG	☐	P02_GETIS_LOCHG		CHAR	40	0	Ind. Municipality for Residences Outside of Geneva (GeTIS)
35	TTYP	☐	P02_GETIS_TTYP		NUMC	1	0	Key for Type of Tax Liability in File (GeTIS)
36	BTYP	☐	P02_GETIS_BTYP		CHAR	2	0	Occupational Category Key (GeTIS)
37	AGMGE	☐	P02_GETIS_ARB_LOCD	P02_GETIS_LOCCD	NUMC	2	0	Municipality Key of Place of Work (GeTIS)	*
38	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
39	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
40	PDAY	☐	P02_GETIS_PDAY	P02_GETIS_PDAY	NUMC	3	0	Number of Workdays (GeTIS)
41	NDAY	☐	P02_GETIS_NDAY	P02_GETIS_NDAY	NUMC	3	0	Number of Absence Days (GeTIS)
42	QSPRO	☐	P02_GETIS_QSPRO	DEC3_2	DEC	5	2	Last Used Tax Rate (GeTIS)
43	QSTAB	☐	P02_CQTAB	P02_CQTAB	CHAR	6	0	Withholding Tax Scale	T5C2K
44	QSTAB_GETIS	☐	P02_GETIS_BCODE	P02_GETIS_BCODE	NUMC	3	0	Pay Scale Key for File (GeTIS)
45	LOHN	☐	P02_GETIS_STBRUT	P02_GETIS_STBRUT	CURR	15	2	Gross Tax ("Prestations soumises"), Rounded down to CHF
46	ABFI	☐	P02_GETIS_ABFI	PRBETRG	CURR	15	2	Capital Payments ("Dont en capital"), Rounded down to CHF
47	FAKZU	☐	P02_GETIS_FAK	PRBETRG	CURR	15	2	Family and Birth of Child Bonus Rounded down to CHF
48	NPZU	☐	P02_GETIS_NPZU	PRBETRG	CURR	15	2	Tax Exempt Bonuses and Incid. Benefits Rounded down to CHF
49	BETR	☐	P02_GETIS_QSBET	PRBETRG	CURR	15	2	Retained Withholding Tax, Rounded down to 5 Rp.
50	KIST	☐	P02_GETIS_KIST	PRBETRG	CURR	15	2	Church Tax Rounded Down to 5 Rp.
51	TOTAL	☐	P02_GETIS_TOTAL	PRBETRG	CURR	15	2	Total Retained Taxes (Total of WHT and Church Tax)
52	CUSTSTATUS	☐	P02Q_CUSTSTATUS		CHAR	1	0	HR-CH: Additional Field for Withholding Tax Evaluations
53	CUSTINFO	☐	P02Q_CUSTINFO		CHAR	30	0	HR-CH: Additional Field for Withholding Tax Evaluations
54	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P02_GETIS_EE	ABREH	T5C2M	ABREINHEIT
2	P02_GETIS_EE	FAMST	T502T	FAMST
3	P02_GETIS_EE	KONFE	T516T	KONFE
4	P02_GETIS_EE	PERSG	T501	PERSG
5	P02_GETIS_EE	QSTAB	T5C2K	QSTAB
6	P02_GETIS_EE	WLAND1	T005	LAND1

History

Last changed by/on	SAP	20130529
SAP Release Created in