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 |
![]() |
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 | ![]() |
P02_DAQ_QSGE_1NP1 | CHAR | 6 | 0 | Employer Identification Number ("numeroDPI") | |||
2 | ![]() |
P02_ABREHQST | P02_ABREHQST | CHAR | 8 | 0 | Payroll Unit - Withholding Tax | * | |
3 | ![]() |
P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
4 | ![]() |
P02_QSGE_ERROR | XFELD | CHAR | 1 | 0 | Error Indicator | ||
5 | ![]() |
P02_DAQ_QSGE_TAX_TYPE | P02_DAQ_QSGE_TAX_TYPE | NUMC | 2 | 0 | Withholding Tax for Geneva: Tax Type | ||
6 | ![]() |
P02_DAQ_QSGE_XTCT | P02_DAQ_QSGE_XTCT | CHAR | 2 | 0 | Type of Taxpayer ("typeContribuable") | ||
7 | ![]() |
P02_DAQ_QSGE_XCON | P02_DAQ_QSGE_XCON | NUMC | 1 | 0 | ISEL: Religion ("confession") | ||
8 | ![]() |
P02_DAQ_QSGE_XNAV | CHAR16 | CHAR | 16 | 0 | SI Number with Number Group Separator ("nouveauNAVS13") | ||
9 | ![]() |
P02_DAQ_QSGE_XAVS | CHAR14 | CHAR | 14 | 0 | AHV Number with Number Group Separator ("numeroAVS") | ||
10 | ![]() |
P02_DAQ_QSGE_XNPR | PAD_NACHN | CHAR | 40 | 0 | Family Name ("nomPersonne") | ||
11 | ![]() |
P02_DAQ_QSGE_XPPR | PAD_VORNM | CHAR | 40 | 0 | First Name ("prenomPersonne") | ||
12 | ![]() |
P02_DAQ_QSGE_XDNA | P02_DAQ_QSGE_DATE | CHAR | 10 | 0 | Date of Birth ("dateNaissance") | ||
13 | ![]() |
P02_DAQ_QSGE_XSEX | P02_DAQ_QSGE_SEX | NUMC | 1 | 0 | Gender ("sexe") | ||
14 | ![]() |
P02_DAQ_QSGE_XECI | P02_DAQ_QSGE_FAMST | NUMC | 1 | 0 | ISEL: Marital Status ("etatCivil") | ||
15 | ![]() |
P02_DAQ_QSGE_XNCN | PAD_NACHN | CHAR | 40 | 0 | Partner Family Name ("nomConjoint") | ||
16 | ![]() |
P02_DAQ_QSGE_XPCN | PAD_VORNM | CHAR | 40 | 0 | First Name of Partner ("prenomConjoint") | ||
17 | ![]() |
P02_DAQ_QSGE_XCTG | P02_DAQ_QSGE_BOOLEAN3 | CHAR | 1 | 0 | Workplace of Spouse is Geneva ("conjointTravailleGE") | ||
18 | ![]() |
P02_DAQ_QSGE_XCTC | P02_DAQ_QSGE_BOOLEAN3 | CHAR | 1 | 0 | Workplace of Spouse is Switzerland ("conjointTravailleCH") | ||
19 | ![]() |
P02_DAQ_QSGE_XNEI | NUMC2 | NUMC | 2 | 0 | Number of Children under 25 Years ("nbrEnfantsInf25") | ||
20 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
21 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
22 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
23 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
24 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
25 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
26 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
27 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
28 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
29 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
30 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
31 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
32 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
33 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
34 | ![]() |
P02_DAQ_QSGE_XDNE | P02_DAQ_QSGE_YEAR | CHAR | 4 | 0 | Year of Birth of Child ("dateNaissanceEnfantInf25") | ||
35 | ![]() |
P02_DAQ_QSGE_XUNL | P02_DAQ_QSGE_BOOLEAN3 | CHAR | 1 | 0 | Cohabitation ("unionLibre") | ||
36 | ![]() |
P02_DAQ_QSGE_XDCO | P02_DAQ_CO | CHAR | 40 | 0 | Employee Workplace: CO ("CO") | ||
37 | ![]() |
P02_DAQ_QSGE_RTVD | P02_DAQ_QSGE_TYPE_VOIE | CHAR | 20 | 0 | Employee Residence: Street Type ("typeVoie") | ||
38 | ![]() |
P02_DAQ_QSGE_RLVD | P02_DAQ_QSGE_LIANT_VOIE | CHAR | 10 | 0 | Employee Residence: Street Binder Type ("liantVoie") | ||
39 | ![]() |
P02_DAQ_QSGE_RVOD | P02_GETIS_STRAS | CHAR | 40 | 0 | Employee Residence: Street Name ("voie") | ||
40 | ![]() |
P02_DAQ_QSGE_RDNV | P02_DAQ_QSGE_HOUSE_NO | CHAR | 10 | 0 | Employee Residence: Street Number ("numeroVoie") | ||
41 | ![]() |
P02_DAQ_QSGE_RDPY | P02_DAQ_QSGE_ZIP_CODE | CHAR | 30 | 0 | Employee Residence: Postal Code ("NPA") | ||
42 | ![]() |
P02_DAQ_QSGE_RDLC | P02_DAQ_QSGE_LOCTX | CHAR | 40 | 0 | Employee Residence: Municipality ("localite") | ||
43 | ![]() |
P02_DAQ_QSGE_RDPS | LAND1 | CHAR | 3 | 0 | Employee Residence: Country ("pays") | * | |
44 | ![]() |
P02_DAQ_QSGE_RDCN | REGIO | CHAR | 3 | 0 | Employee Residence: Canton | * | |
45 | ![]() |
P02_DAQ_QSGE_RDCP | NUMC | 4 | 0 | Employee Resid.: Munic.in Geneva Canton ("communePolitique") | |||
46 | ![]() |
P02_DAQ_QSGE_XTIM | P02_DAQ_QSGE_TAX_RATE | CHAR | 6 | 0 | Tax Rate ("tauxImposition") | ||
47 | ![]() |
P02_DAQ_QSGE_XPSI | P02_DAQ_QSGE_GROSS | CHAR | 10 | 0 | Gross ("prestationsSoumisesImpot") Rounded to CHF | ||
48 | ![]() |
P02_DAQ_QSGE_XCAP | P02_DAQ_QSGE_XCAP | CHAR | 2 | 0 | Socio-Professional Category ("categorieProfessionnelle") | ||
49 | ![]() |
P02_DAQ_QSGE_XNJA | P02_DAQ_QSGE_DAYS | CHAR | 3 | 0 | Number of Days Absent ("nbrJoursAbsence") | ||
50 | ![]() |
P02_DAQ_QSGE_XNJE | P02_DAQ_QSGE_DAYS | CHAR | 3 | 0 | Number of Days of Actual Work ("nbrJourstravailEffectif") | ||
51 | ![]() |
P02_DAQ_QSGE_XIDE | P02_DAQ_QSGE_AMOUNT_NO_CENT | CHAR | 10 | 0 | Severance ("indemnitesDepart") Rounded to CHF | ||
52 | ![]() |
P02_DAQ_QSGE_XPNP | P02_DAQ_QSGE_AMOUNT_NO_CENT | CHAR | 10 | 0 | Non-Recurrent Benefits ("prestationsNonPeriodiques") | ||
53 | ![]() |
P02_DAQ_QSGE_XAFM | P02_DAQ_QSGE_AMOUNT_NO_CENT | CHAR | 10 | 0 | Family Allowances ("allocationsFamiliales") Rounded to CHF | ||
54 | ![]() |
P02_DAQ_QSGE_XFEN | P02_DAQ_QSGE_AMOUNT_NO_CENT | CHAR | 10 | 0 | Actual Costs ("fraisEffectifsNonInclus") | ||
55 | ![]() |
P02_DAQ_QSGE_XFFN | P02_DAQ_QSGE_AMOUNT_NO_CENT | CHAR | 10 | 0 | Fixed Costs ("fraisForfaitairesNonInclus") | ||
56 | ![]() |
P02_DAQ_QSGE_XCFG | P02_DAQ_QSGE_BOOLEAN3 | CHAR | 1 | 0 | Expenses Compliant with Rules of FER ("conformeFERGeneve") | ||
57 | ![]() |
P02_DAQ_QSGE_XTAC | P02_DAQ_QSGE_ACTIVITY_RATE | CHAR | 7 | 0 | Activity Rate ("tauxActivite") | ||
58 | ![]() |
P02_DAQ_QSGE_XIRS | P02_DAQ_QSGE_AMOUNT_CENT | CHAR | 14 | 0 | Withholding Tax Deduction ("impotsRetenus") | ||
59 | ![]() |
P02_DAQ_QSGE_XCEC | P02_DAQ_QSGE_AMOUNT_CENT | CHAR | 14 | 0 | Church Tax ("contributionEcclesiastique") | ||
60 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
61 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
62 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
63 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
64 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
65 | ![]() |
P02_DAQ_QSGE_FREE_ADR | P02_DAQ_QSGE_FREE_ADR | CHAR | 100 | 0 | Shipping Address ("ligneAdresseX") | ||
66 | ![]() |
P02_DAQ_QSGE_FREE_TEXT | P02_DAQ_QSGE_FREE_TEXT | CHAR | 50 | 0 | Free Text ("ligneX") | ||
67 | ![]() |
P02_DAQ_QSGE_FREE_TEXT | P02_DAQ_QSGE_FREE_TEXT | CHAR | 50 | 0 | Free Text ("ligneX") | ||
68 | ![]() |
P02_DAQ_QSGE_FREE_TEXT | P02_DAQ_QSGE_FREE_TEXT | CHAR | 50 | 0 | Free Text ("ligneX") | ||
69 | ![]() |
P02_DAQ_QSGE_2RSE | TEXT40 | CHAR | 40 | 0 | Employer Company Name ("raisonSocialeEmployeur") | ||
70 | ![]() |
P02_DAQ_QSGE_2CPP | P02_DAQ_QSGE_AMOUNT_CENT | CHAR | 14 | 0 | Commission Collection ("commissionPerception") | ||
71 | ![]() |
P02_DAQ_QSGE_3DIM | P02_DAQ_QSGE_DATE | CHAR | 10 | 0 | Subjection Start ("debut_imposition") Type 3 | ||
72 | ![]() |
P02_DAQ_QSGE_4FIM | P02_DAQ_QSGE_DATE | CHAR | 10 | 0 | Subjection End ("fin_imposition") Type 3 | ||
73 | ![]() |
P02_QSGE_TAX_LIABILITY_TAB | TTYP | 0 | 0 | ||||
74 | ![]() |
P02_QSGE_SORT | NUMC | 1 | 0 | Total Field for ALV |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |