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

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