SAP ABAP Table P02_QSGE_EMPLOYEE (Employee Data)

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_QSGE_EMPLOYEE	Table Relationship Diagram
Short Description	Employee Data

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_DAQ_QSGE_1NP1		CHAR	6	0	Employer Identification Number ("numeroDPI")
2	ABREH	☐	P02_ABREHQST	P02_ABREHQST	CHAR	8	0	Payroll Unit - Withholding Tax	*
3	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
4	ERROR	☐	P02_QSGE_ERROR	XFELD	CHAR	1	0	Error Indicator
5	TAX_TYPE	☐	P02_DAQ_QSGE_TAX_TYPE	P02_DAQ_QSGE_TAX_TYPE	NUMC	2	0	Withholding Tax for Geneva: Tax Type
6	TAX_SUBTYPE	☐	P02_DAQ_QSGE_XTCT	P02_DAQ_QSGE_XTCT	CHAR	2	0	Type of Taxpayer ("typeContribuable")
7	CONF	☐	P02_DAQ_QSGE_XCON	P02_DAQ_QSGE_XCON	NUMC	1	0	ISEL: Religion ("confession")
8	NAHVN	☐	P02_DAQ_QSGE_XNAV	CHAR16	CHAR	16	0	SI Number with Number Group Separator ("nouveauNAVS13")
9	AHVNR	☐	P02_DAQ_QSGE_XAVS	CHAR14	CHAR	14	0	AHV Number with Number Group Separator ("numeroAVS")
10	NAME	☐	P02_DAQ_QSGE_XNPR	PAD_NACHN	CHAR	40	0	Family Name ("nomPersonne")
11	FNAME	☐	P02_DAQ_QSGE_XPPR	PAD_VORNM	CHAR	40	0	First Name ("prenomPersonne")
12	BIRTHD	☐	P02_DAQ_QSGE_XDNA	P02_DAQ_QSGE_DATE	CHAR	10	0	Date of Birth ("dateNaissance")
13	SEX	☐	P02_DAQ_QSGE_XSEX	P02_DAQ_QSGE_SEX	NUMC	1	0	Gender ("sexe")
14	MARSTAT	☐	P02_DAQ_QSGE_XECI	P02_DAQ_QSGE_FAMST	NUMC	1	0	ISEL: Marital Status ("etatCivil")
15	PARTN_NAME	☐	P02_DAQ_QSGE_XNCN	PAD_NACHN	CHAR	40	0	Partner Family Name ("nomConjoint")
16	PARTN_FNAME	☐	P02_DAQ_QSGE_XPCN	PAD_VORNM	CHAR	40	0	First Name of Partner ("prenomConjoint")
17	PARTN_WORK_GE	☐	P02_DAQ_QSGE_XCTG	P02_DAQ_QSGE_BOOLEAN3	CHAR	1	0	Workplace of Spouse is Geneva ("conjointTravailleGE")
18	PARTN_WORK_CH	☐	P02_DAQ_QSGE_XCTC	P02_DAQ_QSGE_BOOLEAN3	CHAR	1	0	Workplace of Spouse is Switzerland ("conjointTravailleCH")
19	NO_CHILDREN	☐	P02_DAQ_QSGE_XNEI	NUMC2	NUMC	2	0	Number of Children under 25 Years ("nbrEnfantsInf25")
20	GBDAT_CHILD15	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
21	GBDAT_CHILD14	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
22	GBDAT_CHILD13	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
23	GBDAT_CHILD12	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
24	GBDAT_CHILD11	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
25	GBDAT_CHILD10	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
26	GBDAT_CHILD9	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
27	GBDAT_CHILD8	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
28	GBDAT_CHILD7	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
29	GBDAT_CHILD6	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
30	GBDAT_CHILD5	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
31	GBDAT_CHILD4	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
32	GBDAT_CHILD3	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
33	GBDAT_CHILD2	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
34	GBDAT_CHILD1	☐	P02_DAQ_QSGE_XDNE	P02_DAQ_QSGE_YEAR	CHAR	4	0	Year of Birth of Child ("dateNaissanceEnfantInf25")
35	CONCUB	☐	P02_DAQ_QSGE_XUNL	P02_DAQ_QSGE_BOOLEAN3	CHAR	1	0	Cohabitation ("unionLibre")
36	RES_CO	☐	P02_DAQ_QSGE_XDCO	P02_DAQ_CO	CHAR	40	0	Employee Workplace: CO ("CO")
37	RES_STR_TYPE	☐	P02_DAQ_QSGE_RTVD	P02_DAQ_QSGE_TYPE_VOIE	CHAR	20	0	Employee Residence: Street Type ("typeVoie")
38	RES_STR_BIND	☐	P02_DAQ_QSGE_RLVD	P02_DAQ_QSGE_LIANT_VOIE	CHAR	10	0	Employee Residence: Street Binder Type ("liantVoie")
39	RES_STREET	☐	P02_DAQ_QSGE_RVOD	P02_GETIS_STRAS	CHAR	40	0	Employee Residence: Street Name ("voie")
40	RES_HSNO	☐	P02_DAQ_QSGE_RDNV	P02_DAQ_QSGE_HOUSE_NO	CHAR	10	0	Employee Residence: Street Number ("numeroVoie")
41	RES_ZIP	☐	P02_DAQ_QSGE_RDPY	P02_DAQ_QSGE_ZIP_CODE	CHAR	30	0	Employee Residence: Postal Code ("NPA")
42	RES_LOC	☐	P02_DAQ_QSGE_RDLC	P02_DAQ_QSGE_LOCTX	CHAR	40	0	Employee Residence: Municipality ("localite")
43	RES_COUNTRY	☐	P02_DAQ_QSGE_RDPS	LAND1	CHAR	3	0	Employee Residence: Country ("pays")	*
44	RES_CANTON	☐	P02_DAQ_QSGE_RDCN	REGIO	CHAR	3	0	Employee Residence: Canton	*
45	RES_LOC_GE	☐	P02_DAQ_QSGE_RDCP		NUMC	4	0	Employee Resid.: Munic.in Geneva Canton ("communePolitique")
46	TAX_RATE	☐	P02_DAQ_QSGE_XTIM	P02_DAQ_QSGE_TAX_RATE	CHAR	6	0	Tax Rate ("tauxImposition")
47	GROSS	☐	P02_DAQ_QSGE_XPSI	P02_DAQ_QSGE_GROSS	CHAR	10	0	Gross ("prestationsSoumisesImpot") Rounded to CHF
48	PROF_SOC_CAT	☐	P02_DAQ_QSGE_XCAP	P02_DAQ_QSGE_XCAP	CHAR	2	0	Socio-Professional Category ("categorieProfessionnelle")
49	NO_ABSENCE	☐	P02_DAQ_QSGE_XNJA	P02_DAQ_QSGE_DAYS	CHAR	3	0	Number of Days Absent ("nbrJoursAbsence")
50	NO_WORKDAYS	☐	P02_DAQ_QSGE_XNJE	P02_DAQ_QSGE_DAYS	CHAR	3	0	Number of Days of Actual Work ("nbrJourstravailEffectif")
51	SEVER_PAY	☐	P02_DAQ_QSGE_XIDE	P02_DAQ_QSGE_AMOUNT_NO_CENT	CHAR	10	0	Severance ("indemnitesDepart") Rounded to CHF
52	NON_PERI_PAY	☐	P02_DAQ_QSGE_XPNP	P02_DAQ_QSGE_AMOUNT_NO_CENT	CHAR	10	0	Non-Recurrent Benefits ("prestationsNonPeriodiques")
53	FAM_ALLOW	☐	P02_DAQ_QSGE_XAFM	P02_DAQ_QSGE_AMOUNT_NO_CENT	CHAR	10	0	Family Allowances ("allocationsFamiliales") Rounded to CHF
54	EFF_EXPENSE	☐	P02_DAQ_QSGE_XFEN	P02_DAQ_QSGE_AMOUNT_NO_CENT	CHAR	10	0	Actual Costs ("fraisEffectifsNonInclus")
55	FIX_EXPENSE	☐	P02_DAQ_QSGE_XFFN	P02_DAQ_QSGE_AMOUNT_NO_CENT	CHAR	10	0	Fixed Costs ("fraisForfaitairesNonInclus")
56	EXP_RULE_FER	☐	P02_DAQ_QSGE_XCFG	P02_DAQ_QSGE_BOOLEAN3	CHAR	1	0	Expenses Compliant with Rules of FER ("conformeFERGeneve")
57	ACT_RATE	☐	P02_DAQ_QSGE_XTAC	P02_DAQ_QSGE_ACTIVITY_RATE	CHAR	7	0	Activity Rate ("tauxActivite")
58	WITHH_TAX	☐	P02_DAQ_QSGE_XIRS	P02_DAQ_QSGE_AMOUNT_CENT	CHAR	14	0	Withholding Tax Deduction ("impotsRetenus")
59	CHURCH_TAX	☐	P02_DAQ_QSGE_XCEC	P02_DAQ_QSGE_AMOUNT_CENT	CHAR	14	0	Church Tax ("contributionEcclesiastique")
60	FREE_ADDR1	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
61	FREE_ADDR2	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
62	FREE_ADDR3	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
63	FREE_ADDR4	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
64	FREE_ADDR5	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
65	FREE_ADDR6	☐	P02_DAQ_QSGE_FREE_ADR	P02_DAQ_QSGE_FREE_ADR	CHAR	100	0	Shipping Address ("ligneAdresseX")
66	FREE_TEXT1	☐	P02_DAQ_QSGE_FREE_TEXT	P02_DAQ_QSGE_FREE_TEXT	CHAR	50	0	Free Text ("ligneX")
67	FREE_TEXT2	☐	P02_DAQ_QSGE_FREE_TEXT	P02_DAQ_QSGE_FREE_TEXT	CHAR	50	0	Free Text ("ligneX")
68	FREE_TEXT3	☐	P02_DAQ_QSGE_FREE_TEXT	P02_DAQ_QSGE_FREE_TEXT	CHAR	50	0	Free Text ("ligneX")
69	OTH_NAME	☐	P02_DAQ_QSGE_2RSE	TEXT40	CHAR	40	0	Employer Company Name ("raisonSocialeEmployeur")
70	OTH_COMMI	☐	P02_DAQ_QSGE_2CPP	P02_DAQ_QSGE_AMOUNT_CENT	CHAR	14	0	Commission Collection ("commissionPerception")
71	3BEGDA	☐	P02_DAQ_QSGE_3DIM	P02_DAQ_QSGE_DATE	CHAR	10	0	Subjection Start ("debut_imposition") Type 3
72	3ENDDA	☐	P02_DAQ_QSGE_4FIM	P02_DAQ_QSGE_DATE	CHAR	10	0	Subjection End ("fin_imposition") Type 3
73	TAX_LIAB	☐	P02_QSGE_TAX_LIABILITY_TAB		TTYP	0	0
74	SUMM	☐	P02_QSGE_SORT		NUMC	1	0	Total Field for ALV

History

Last changed by/on	SAP	20110901
SAP Release Created in