SAP ABAP Table P12SB00_DAQ_T_EMPLOYEE_2009 (Social Balance SB00: DAQ EMPLOYEE DATA Table 2009)
Hierarchy
☛
SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
⤷ PY-BE (Application Component) Belgium
⤷ PC12 (Package) HR accounting: Belgium
⤷ PY-BE (Application Component) Belgium
⤷ PC12 (Package) HR accounting: Belgium
Basic Data
Table Category | INTTAB | Structure |
Structure | P12SB00_DAQ_T_EMPLOYEE_2009 | Table Relationship Diagram |
Short Description | Social Balance SB00: DAQ EMPLOYEE DATA Table 2009 |
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 | SECTN | P_99S_SECTN | P_99S_SECTN | CHAR | 4 | 0 | SAP Section Code | ||
2 | .INCLUDE | 0 | 0 | Social Balance SB00: DAQ EMPLOYEE DATA Structure 2009 | |||||
3 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE - KEY FIELDS | |||||
4 | PERNR | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
5 | RSZRR | RSZRR | NUM11 | NUMC | 11 | 0 | INSS - National ID number (00024) | ||
6 | EEMOD | P12_SB_MODEE | P12_SB_MODEE | CHAR | 4 | 0 | Employee Grouping | * | |
7 | EEPIR | P12_SBPERIOD | CHAR6 | CHAR | 6 | 0 | Declaration Period | ||
8 | EEEND | P12_SB_ENDDA_10 | CHAR10 | CHAR | 10 | 0 | Record End Date | ||
9 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE ORGANIZATIONAL Data | |||||
10 | EECCD | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
11 | EEPRA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
12 | EEPSA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
13 | EEEGR | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | * | |
14 | EEESG | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | * | |
15 | EEKOS | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
16 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE - DATA Fields | |||||
17 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
18 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
19 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
20 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE - BASIC DATA AT end date of SB | |||||
21 | EEAKT | P12_SB_AKTIVJN | XFELD | CHAR | 1 | 0 | Employee Active for Declaration Purposes | ||
22 | EEANS | ANSTA | NUM1 | NUMC | 1 | 0 | Employment status | ||
23 | EECTT | CTTYP | CTTYP | CHAR | 2 | 0 | Contract Type | * | |
24 | EERSP | RSZSP | RSZSP | CHAR | 2 | 0 | Employee specification | * | |
25 | EEEMP | EMPCT | BSGRD | DEC | 5 | 2 | Employment percentage | ||
26 | EEMWH | P12_SB_MWHWK | DEC3_2 | DEC | 5 | 2 | Mean weekly working hours | ||
27 | EERFM | P12_SB_RFMWH | DEC3_2 | DEC | 5 | 2 | Reference Weekly Working Hours | ||
28 | EEREM | P12_REMES | P12_REMES | NUMC | 3 | 0 | Reorganization measure | ||
29 | EEBEU | BEUWG | DEC3_2 | DEC | 5 | 2 | Contractual Mean Working Hours per week | ||
30 | EEBE2 | P12_BEUW2 | DEC3_2 | DEC | 5 | 2 | Mean number of hours per week | ||
31 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE - CALCULATED DATA AT end date SB | |||||
32 | EEFBA | P12_SB_BSOBA | P12_SB_BSOBA | CHAR | 1 | 0 | Relevance for Social Balance Declaration Reporting | ||
33 | EEFTI | P12_SB_FULL_TIME_IND | XFELD | CHAR | 1 | 0 | Full-Time | ||
34 | EEPTI | P12_SB_PART_TIME_IND | XFELD | CHAR | 1 | 0 | Part-Time | ||
35 | EESAN | P12_SB_ANSTA | P12_SB_ANSTA | NUMC | 1 | 0 | Employment Type | ||
36 | EESCT | P12_SB_CTTYP | P12_SB_CTTYP | CHAR | 1 | 0 | Contract Type for Declaration Purposes | ||
37 | EESLR | P12_SB_HIGHEST_SLART | SLART | CHAR | 2 | 0 | Highest Educational Establishment | * | |
38 | EESLB | P12_SB_HIGHEST_SLABS | SLABS | CHAR | 2 | 0 | Highest Certificate | * | |
39 | EEDTY | P12_SB_HIGHEST_EDTYP | EDTYP | CHAR | 2 | 0 | Highest Education Type | ||
40 | .INCLUDE | 0 | 0 | Social Balance: Employee DECLARATION CODES Structure | |||||
41 | 0105 | P12_SBCD_0105 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0105 value | ||
42 | .INCLUDE | 0 | 0 | Social Balance: CODE 0105 Structure | |||||
43 | 0105A | P12_SBCD_0105A | P12_DEC15_2 | DEC | 15 | 2 | 0105A - Number of Employees at Year End (Full-Time) | ||
44 | 0105B | P12_SBCD_0105B | P12_DEC15_2 | DEC | 15 | 2 | 0105B - Number of Employees at Year End (Part-Time) | ||
45 | 0105C | P12_SBCD_0105C | P12_DEC15_2 | DEC | 15 | 2 | 0105C - Number of Employees at Year End (FTE) | ||
46 | 0110 | P12_SBCD_0110 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0110 value | ||
47 | .INCLUDE | 0 | 0 | Social Balance: CODE 0110 Structure | |||||
48 | 0110A | P12_SBCD_0110A | P12_DEC15_2 | DEC | 15 | 2 | 0110A - Employees with Unlimited Contracts at Year End (FT) | ||
49 | 0110B | P12_SBCD_0110B | P12_DEC15_2 | DEC | 15 | 2 | 0110B - Employees with Unlimited Contracts at Year End (PT) | ||
50 | 0110C | P12_SBCD_0110C | P12_DEC15_2 | DEC | 15 | 2 | 0110C - Employees with Unlimited Contracts at Year End (FTE) | ||
51 | 0111 | P12_SBCD_0111 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0111 value | ||
52 | .INCLUDE | 0 | 0 | Social Balance: CODE 0111 Structure | |||||
53 | 0111A | P12_SBCD_0111A | P12_DEC15_2 | DEC | 15 | 2 | 0111A - Employees with Fixed Term Contracts at Year End (FT) | ||
54 | 0111B | P12_SBCD_0111B | P12_DEC15_2 | DEC | 15 | 2 | 0111B - Employees with Fixed Term Contacts at Year End (PT) | ||
55 | 0111C | P12_SBCD_0111C | P12_DEC15_2 | DEC | 15 | 2 | 0111C - Employees with Fixed Term Contracts Year End (FTE) | ||
56 | 0112 | P12_SBCD_0112 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0112 value | ||
57 | .INCLUDE | 0 | 0 | Social Balance: CODE 0112 Structure | |||||
58 | 0112A | P12_SBCD_0112A | P12_DEC15_2 | DEC | 15 | 2 | 0112A - Employees with Specific Contracts at Year End (FT) | ||
59 | 0112B | P12_SBCD_0112B | P12_DEC15_2 | DEC | 15 | 2 | 0112B - Employees with Specific Contracts at Year End (PT) | ||
60 | 0112C | P12_SBCD_0112C | P12_DEC15_2 | DEC | 15 | 2 | 0112C - Employees with Specific Contracts at Year End (FTE) | ||
61 | 0113 | P12_SBCD_0113 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0113 value | ||
62 | .INCLUDE | 0 | 0 | Social Balance: CODE 0113 Structure | |||||
63 | 0113A | P12_SBCD_0113A | P12_DEC15_2 | DEC | 15 | 2 | 0113A - Employees with Replacement Contracts Year End (FT) | ||
64 | 0113B | P12_SBCD_0113B | P12_DEC15_2 | DEC | 15 | 2 | 0113B - Employees with Replacement Contracts Year End (PT) | ||
65 | 0113C | P12_SBCD_0113C | P12_DEC15_2 | DEC | 15 | 2 | 0113C - Employees with Replacement Contracts Year End (FTE) | ||
66 | 0120 | P12_SBCD_0120 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0120 value | ||
67 | .INCLUDE | 0 | 0 | Social Balance: CODE 0120 Structure | |||||
68 | 0120A | P12_SBCD_0120A | P12_DEC15_2 | DEC | 15 | 2 | 0120A - Number of Male Employees at Year End (Full-Time) | ||
69 | 0120B | P12_SBCD_0120B | P12_DEC15_2 | DEC | 15 | 2 | 0120B - Number of Male Employees at Year End (Part-Time) | ||
70 | 0120C | P12_SBCD_0120C | P12_DEC15_2 | DEC | 15 | 2 | 0120C - Number of Male Employees at Year End (FTE) | ||
71 | 1200 | P12_SBCD_1200 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1200 value | ||
72 | .INCLUDE | 0 | 0 | Social Balance: CODE 1200 Structure | |||||
73 | 1200A | P12_SBCD_1200A | P12_DEC15_2 | DEC | 15 | 2 | 1200A - Male Employees with Primary Education (Full-Time) | ||
74 | 1200B | P12_SBCD_1200B | P12_DEC15_2 | DEC | 15 | 2 | 1200B - Male Employees with Primary Education (Part-Time) | ||
75 | 1200C | P12_SBCD_1200C | P12_DEC15_2 | DEC | 15 | 2 | 1200C - Male Employees with Primary Education (FTE) | ||
76 | 1201 | P12_SBCD_1201 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1201 value | ||
77 | .INCLUDE | 0 | 0 | Social Balance: CODE 1201 Structure | |||||
78 | 1201A | P12_SBCD_1201A | P12_DEC15_2 | DEC | 15 | 2 | 1201A - Male Employees with Secondary Education (Full-Time) | ||
79 | 1201B | P12_SBCD_1201B | P12_DEC15_2 | DEC | 15 | 2 | 1201B - Male Employees with Secondary Education (Part-Time) | ||
80 | 1201C | P12_SBCD_1201C | P12_DEC15_2 | DEC | 15 | 2 | 1201C - Male Employees with Secondary Education (FTE) | ||
81 | 1202 | P12_SBCD_1202 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1202 value | ||
82 | .INCLUDE | 0 | 0 | Social Balance: CODE 1201 Structure | |||||
83 | 1202A | P12_SBCD_1202A | P12_DEC15_2 | DEC | 15 | 2 | 1202A - Male Employees with Higher Education (Full-Time) | ||
84 | 1202B | P12_SBCD_1202B | P12_DEC15_2 | DEC | 15 | 2 | 1202B - Male Employees with Higher Education (Part-Time) | ||
85 | 1202C | P12_SBCD_1202C | P12_DEC15_2 | DEC | 15 | 2 | 1202C - Male Employees with Higher Education (FTE) | ||
86 | 1203 | P12_SBCD_1203 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1203 value | ||
87 | .INCLUDE | 0 | 0 | Social Balance: CODE 1203 Structure | |||||
88 | 1203A | P12_SBCD_1203A | P12_DEC15_2 | DEC | 15 | 2 | 1203A - Male Employees with Uni. Education (Full-Time) | ||
89 | 1203B | P12_SBCD_1203B | P12_DEC15_2 | DEC | 15 | 2 | 1203B - Male Employees with Uni. Education (Part-Time) | ||
90 | 1203C | P12_SBCD_1203C | P12_DEC15_2 | DEC | 15 | 2 | 1203C - Male Employees with Uni. Education (FTE) | ||
91 | 0121 | P12_SBCD_0121 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0121 value | ||
92 | .INCLUDE | 0 | 0 | Social Balance: CODE 0121 Structure | |||||
93 | 0121A | P12_SBCD_0121A | P12_DEC15_2 | DEC | 15 | 2 | 0121A - Number of Female Employees at Year End (Full-Time) | ||
94 | 0121B | P12_SBCD_0121B | P12_DEC15_2 | DEC | 15 | 2 | 0121B - Number of Female Employees at Year End (Part-Time) | ||
95 | 0121C | P12_SBCD_0121C | P12_DEC15_2 | DEC | 15 | 2 | 0120C - Number of Female Employees at Year End (FTE) | ||
96 | 1210 | P12_SBCD_1210 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1210 value | ||
97 | .INCLUDE | 0 | 0 | Social Balance: CODE 1210 Structure | |||||
98 | 1210A | P12_SBCD_1210A | P12_DEC15_2 | DEC | 15 | 2 | 1210A - Female Employees with Primary Education (Full-Time) | ||
99 | 1210B | P12_SBCD_1210B | P12_DEC15_2 | DEC | 15 | 2 | 1210B - Female Employees with Primary Education (Part-Time) | ||
100 | 1210C | P12_SBCD_1210C | P12_DEC15_2 | DEC | 15 | 2 | 1210C - Female Employees with Primary Education (FTE) | ||
101 | 1211 | P12_SBCD_1211 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1211 value | ||
102 | .INCLUDE | 0 | 0 | Social Balance: CODE 1211 Structure | |||||
103 | 1211A | P12_SBCD_1211A | P12_DEC15_2 | DEC | 15 | 2 | 1211A - Female Emps with Secondary Education (Full-Time) | ||
104 | 1211B | P12_SBCD_1211B | P12_DEC15_2 | DEC | 15 | 2 | 1211B - Female Emps with Secondary Education (Part-Time) | ||
105 | 1211C | P12_SBCD_1211C | P12_DEC15_2 | DEC | 15 | 2 | 1211C - Female Employees with Secondary Education (FTE) | ||
106 | 1212 | P12_SBCD_1212 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1212 value | ||
107 | .INCLUDE | 0 | 0 | Social Balance: CODE 1211 Structure | |||||
108 | 1212A | P12_SBCD_1212A | P12_DEC15_2 | DEC | 15 | 2 | 1212A - Female Employees with Higher Education (Full-Time) | ||
109 | 1212B | P12_SBCD_1212B | P12_DEC15_2 | DEC | 15 | 2 | 1212B - Female Employees with Higher Education (Part-Time) | ||
110 | 1212C | P12_SBCD_1212C | P12_DEC15_2 | DEC | 15 | 2 | 1212C - Female Employees with Higher Education (FTE) | ||
111 | 1213 | P12_SBCD_1213 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 1213 value | ||
112 | .INCLUDE | 0 | 0 | Social Balance: CODE 1213 Structure | |||||
113 | 1213A | P12_SBCD_1213A | P12_DEC15_2 | DEC | 15 | 2 | 1213A - Female Employees with Uni. Education (Full-Time) | ||
114 | 1213B | P12_SBCD_1213B | P12_DEC15_2 | DEC | 15 | 2 | 1213B - Female Employees with Uni. Education (Part-Time) | ||
115 | 1213C | P12_SBCD_1213C | P12_DEC15_2 | DEC | 15 | 2 | 1213C - Female Employees with Uni. Education (FTE) | ||
116 | 0130 | P12_SBCD_0130 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0130 value | ||
117 | .INCLUDE | 0 | 0 | Social Balance: CODE 0120 Structure | |||||
118 | 0130A | P12_SBCD_0130A | P12_DEC15_2 | DEC | 15 | 2 | 0130A - Number of Managing Directors at Year End (Full-Time) | ||
119 | 0130B | P12_SBCD_0130B | P12_DEC15_2 | DEC | 15 | 2 | 0130B - Number of Managing Directors at Year End (Part-Time) | ||
120 | 0130C | P12_SBCD_0130C | P12_DEC15_2 | DEC | 15 | 2 | 0130C - Number of Managing Directors at Year End (FTE) | ||
121 | 0132 | P12_SBCD_0132 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0132 value | ||
122 | .INCLUDE | 0 | 0 | Social Balance: CODE 0120 Structure | |||||
123 | 0132A | P12_SBCD_0132A | P12_DEC15_2 | DEC | 15 | 2 | 0132A - Number of Blue Collar Workers at Year End (FT) | ||
124 | 0132B | P12_SBCD_0132B | P12_DEC15_2 | DEC | 15 | 2 | 0132B - Number of Blue Collar Workers at Year End (PT) | ||
125 | 0132C | P12_SBCD_0132C | P12_DEC15_2 | DEC | 15 | 2 | 0132C - Number of Blue Collar Workers at Year End (FTE) | ||
126 | 0133 | P12_SBCD_0133 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0133 value | ||
127 | .INCLUDE | 0 | 0 | Social Balance: CODE 0120 Structure | |||||
128 | 0133A | P12_SBCD_0133A | P12_DEC15_2 | DEC | 15 | 2 | 0133A - Number of Other Workers at Year End (Full-Time) | ||
129 | 0133B | P12_SBCD_0133B | P12_DEC15_2 | DEC | 15 | 2 | 0133B - Number of Other Workers at Year End (Part-Time) | ||
130 | 0133C | P12_SBCD_0133C | P12_DEC15_2 | DEC | 15 | 2 | 0133C - Number of Other Workers at Year End (FTE) | ||
131 | 0134 | P12_SBCD_0134 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0134 value | ||
132 | .INCLUDE | 0 | 0 | Social Balance: CODE 0120 Structure | |||||
133 | 0134A | P12_SBCD_0134A | P12_DEC15_2 | DEC | 15 | 2 | 0134A - Number of White Collar Workers at Year End (FT) | ||
134 | 0134B | P12_SBCD_0134B | P12_DEC15_2 | DEC | 15 | 2 | 0134B - Number of White Collar Workers at Year End (PT) | ||
135 | 0134C | P12_SBCD_0134C | P12_DEC15_2 | DEC | 15 | 2 | 0134C - Number of White Collar Workers at Year End (FTE) |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |