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