SAP ABAP Table P06DAD_S41_DSP (Structure to view section S41)
Hierarchy
☛
SAP_HRCFR (Software Component) Sub component SAP_HRCFR of SAP_HR
⤷ PY-FR (Application Component) France
⤷ PC06 (Package) HR Payroll: France
⤷ PY-FR (Application Component) France
⤷ PC06 (Package) HR Payroll: France
Basic Data
Table Category | INTTAB | Structure |
Structure | P06DAD_S41_DSP | Table Relationship Diagram |
Short Description | Structure to view section S41 |
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 | SIREN | P06_SIREN | CHAR | 9 | 0 | SIREN number | |||
2 | NUMIC | P06_NUMIC | CHAR5 | CHAR | 5 | 0 | NIC | ||
3 | PERID | P06_MATRICULE30_ENT | CHAR30 | CHAR | 30 | 0 | Personnel number of employee in company | ||
4 | MATRICULE | P06_MATRICULE30 | CHAR30 | CHAR | 30 | 0 | Employee's personnel number in the work place | ||
5 | PER_DEB | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
6 | PER_FIN | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
7 | MOT_DEB1 | P06_MOT_DEB | CHAR3 | CHAR | 3 | 0 | DADS-U: Period start reason code | ||
8 | MOT_DEB2 | P06_MOT_DEB | CHAR3 | CHAR | 3 | 0 | DADS-U: Period start reason code | ||
9 | MOT_DEB3 | P06_MOT_DEB | CHAR3 | CHAR | 3 | 0 | DADS-U: Period start reason code | ||
10 | MOT_DEB4 | P06_MOT_DEB | CHAR3 | CHAR | 3 | 0 | DADS-U: Period start reason code | ||
11 | MOT_DEB5 | P06_MOT_DEB | CHAR3 | CHAR | 3 | 0 | DADS-U: Period start reason code | ||
12 | MOT_FIN1 | P06_MOT_FIN | CHAR3 | CHAR | 3 | 0 | DADS-U: Period end reason code | ||
13 | MOT_FIN2 | P06_MOT_FIN | CHAR3 | CHAR | 3 | 0 | DADS-U: Period end reason code | ||
14 | MOT_FIN3 | P06_MOT_FIN | CHAR3 | CHAR | 3 | 0 | DADS-U: Period end reason code | ||
15 | MOT_FIN4 | P06_MOT_FIN | CHAR3 | CHAR | 3 | 0 | DADS-U: Period end reason code | ||
16 | MOT_FIN5 | P06_MOT_FIN | CHAR3 | CHAR | 3 | 0 | DADS-U: Period end reason code | ||
17 | PCS | P06_PCS | P06_PCS | CHAR | 4 | 0 | Socio-professional category INSEE code | T5F4J | |
18 | CONTRAT | P06_CONTRAT | CHAR2 | CHAR | 2 | 0 | DADS-U: Work contract code | ||
19 | CAR_TRAV | P06_CAR_TRAV | CHAR2 | CHAR | 2 | 0 | DADS-U: Characteristic code of activity or contract | ||
20 | STATPROF | P06_STATPROF | CHAR2 | CHAR | 2 | 0 | DADS-U : Employee professional status code | ||
21 | STATCATEG | P06_STATCATEG_CONV | CHAR2 | CHAR | 2 | 0 | DADS-U: Employee collective agreement group status indicator | ||
22 | STATCATRT | P06_STATCATEG_AGIRC | CHAR2 | CHAR | 2 | 0 | DADS-U: Employee AGIRC-ARRCO group status indicator | ||
23 | CONVCOLL | P06_CONVCOLL | CHAR4 | CHAR | 4 | 0 | DADS-U: Collective agreement code | ||
24 | .INCLUDE | 0 | 0 | DADS-U: Plan (S41.G01.00.018) | |||||
25 | REGIME_BASE | P06_REGIME_BASE | P06_REGIME | CHAR | 3 | 0 | DADS-U: Compulsory basic plan indicator | ||
26 | REGIME_MALADIE | P06_REGIME_MALADIE | P06_REGIME | CHAR | 3 | 0 | Compulsory illness risk scheme indicator | ||
27 | REGIME_ACCTRAV | P06_REGIME_ACCTRAV | P06_REGIME | CHAR | 3 | 0 | Compulsory work accident risk scheme indicator | ||
28 | REGIME_VIEPATR | P06_REGIME_VIEPATR | P06_REGIME | CHAR | 3 | 0 | Compulsory pension plan code (employer part) | ||
29 | REGIME_VIESALAR | P06_REGIME_VIESALAR | P06_REGIME | CHAR | 3 | 0 | DADS-U: Compulsory pension plan code (employee part) | ||
30 | REGIME_ALS_MOS | P06_REGIME_ALS_MOS | CHAR2 | CHAR | 2 | 0 | Alsace-Moselle extension code | ||
31 | REGIME_GEST_MAL | P06_REGIME_GES_MAL | CHAR2 | CHAR | 2 | 0 | Code for maintenance delegation of illness risk | ||
32 | TAUX_TP | P06_TAUX_TP | DEC2_2 | DEC | 4 | 2 | DADS-U: Rate of part-time employment | ||
33 | NOMPAT | P06_NOMPAT | CHAR80 | CHAR | 80 | 0 | Last name | ||
34 | PRENOM | P06_SAL_PRENOM | CHAR40 | CHAR | 40 | 0 | First name | ||
35 | HRSPAIE | DEC | 8 | 0 | |||||
36 | HRSTRAV | DEC | 8 | 0 | |||||
37 | DER_MOIS | P06_DER_MOIS | NUM2 | NUMC | 2 | 0 | DADS-U: Last month with 60 working hours | ||
38 | .INCLUDE | 0 | 0 | DADS-U: working time (S41.G01.00.023) | |||||
39 | DODAH | P06_DUR_ANNEE | CHAR2 | CHAR | 2 | 0 | DADS-U: annual working time 1200 hours | ||
40 | DODTH | P06_DUR_TRIMES | CHAR2 | CHAR | 2 | 0 | DADS-U: quarterly working time 120 hours | ||
41 | DODMH | P06_DUR_MOIS | CHAR2 | CHAR | 2 | 0 | DADS-U: monthly working time 60 hours | ||
42 | HRSCHOM | DEC | 8 | 0 | |||||
43 | AT_SECTION | P06_SECTIO | CHAR2 | CHAR | 2 | 0 | Company section I.A. | ||
44 | AT_RISQUE | P06_CODRIS | CHAR5 | CHAR | 5 | 0 | Risk code | ||
45 | BUREAU | P06_CODBUR | CHAR1 | CHAR | 1 | 0 | Office code | ||
46 | TXACCT | P06DAD_TXACCT | DEC3_2 | DEC | 5 | 2 | Industrial accident rate | ||
47 | SSBRUT | P06_AMOUNT_SSBRUT2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Gross Social Insurance base for the period | ||
48 | NATBASES | P06DAD_NATBASE | P06DAD_NATBASE | CHAR | 2 | 0 | DADS-U: Nature code for contributions bases | ||
49 | SSLIM | P06_AMOUNT_SSLIM2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Base limited to maximum Social Insurance amount | ||
50 | CSG | P06_AMOUNT_CSG2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U : General Social Contribution (CSG) | ||
51 | CRDS | P06_AMOUNT_CRDS2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Social Debt Reimbursement Contribution (CRDS) | ||
52 | BASE_BRUT | P06_AMOUNT_BBRUT2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Gross tax base | ||
53 | NAT_VALEUR | P06_NAT_VAL2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Value imputed income | ||
54 | NAT_NOURR | P06_NAT_NOURR | CHAR1 | CHAR | 1 | 0 | DADS-U: Meals | ||
55 | NAT_LOGMT | P06_NAT_LOGMT | CHAR1 | CHAR | 1 | 0 | DADS-U: Residency | ||
56 | NAT_VOIT | P06_NAT_VOIT | CHAR1 | CHAR | 1 | 0 | DADS-U: Car | ||
57 | NAT_AUTR | P06_NAT_AUTR | CHAR1 | CHAR | 1 | 0 | DADS-U: Other advantages | ||
58 | NTIC | P06_OUTILS_NTIC | CHAR1 | CHAR | 1 | 0 | DADS-U: Tools issued from NTIC | ||
59 | RETENUE | P06_RETENUE2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Deduction from pay | ||
60 | FRAIS_PROF | P06_FRAIS_PROF2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Professional expenses amount | ||
61 | FORFAIT | P06_FORFAIT | CHAR1 | CHAR | 1 | 0 | DADS-U: Lump-sum allowances | ||
62 | REMB_FRAIS | P06_REMB_FRAIS | CHAR1 | CHAR | 1 | 0 | DADS-U: Professional expenses reimbursements | ||
63 | PRIS_EMPL | P06_PRIS_EMPL | CHAR1 | CHAR | 1 | 0 | DADS-U: Covered by employer | ||
64 | REMB_AUTR | P06_REMB_AUTR | CHAR1 | CHAR | 1 | 0 | DADS-U: Reimbursements other than professional expenses | ||
65 | CHEQ_VAC | P06_CHEQ_VAC2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Amount of employer contribution to checks | ||
66 | IMPOTS | P06_IMPOTS2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Taxes withheld at source | ||
67 | IND_EXPA | P06_IND_EXPA2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Relocation allowance | ||
68 | TOT_TAXSAL | P06_AMOUNT_TAXSAL2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Total subject to salary tax | ||
69 | BASE_TAUX1 | P06_AMOUNT_BTAUX1A | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: 1st rate tax base | ||
70 | BASE_TAUX2 | P06_AMOUNT_BTAUX2A | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: 2nd rate tax base | ||
71 | TAXSAL | P06_TAXSAL_DADSU2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Employment tax amount | ||
72 | ACTIVITES | P06_ACTIVITES2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Net taxable income from activities | ||
73 | CONGES_PAYES | P06_CONGES_PAYES2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Amount of paid leave compensation | ||
74 | OTHER_REVENUES | P06_AMOUNT_REV2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Other taxable net income | ||
75 | EPARG_RETR | P06_AMOUNT_EPRT2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | Savings-retirement contributions | ||
76 | IMPAT | P06_AMOUNT_IMP2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Relocation allowance | ||
77 | SERV_PERS | P06_AMOUNT_SERV2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Participation in personal services financing | ||
78 | INDEMN_CPP | P06_AMOUNT_INDCPP2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Maximum paid leave compensation amount | ||
79 | MNT_HSHC | P06_AMOUNT_HSHC2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | Exempt overtime and extra hours remuneration | ||
80 | DOJA | P06_DOJAA | DEC3 | DEC | 3 | 0 | DADS-U: Number of days of flight activity | ||
81 | DOCT | P06_DOCT2 | P06_AMOUNT_DADSU2 | DEC | 10 | 0 | DADS-U: Exempted sums from a CET time savings account | ||
82 | DOCPC | P06_CCPCS | P06_CCPCS | CHAR | 6 | 0 | PCS supplement | ||
83 | DODN | P06_MOT_DEB_N | CHAR9 | CHAR | 9 | 0 | DADS-U: Period start reason code |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P06DAD_S41_DSP | PCS | T5F4J | CINSE |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |