SAP ABAP Table P12SB00_S_EMPLOYEE_END_DATA (Social Balance: EMPLOYEE - DATA valid on end date of SB)

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_S_EMPLOYEE_END_DATA	Table Relationship Diagram
Short Description	Social Balance: EMPLOYEE - DATA valid on end date of SB

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 - BASIC DATA AT end date of SB
2	EEAKT	☐	P12_SB_AKTIVJN	XFELD	CHAR	1	0	Employee Active for Declaration Purposes
3	EEANS	☐	ANSTA	NUM1	NUMC	1	0	Employment status
4	EECTT	☐	CTTYP	CTTYP	CHAR	2	0	Contract Type	*
5	EERSP	☐	RSZSP	RSZSP	CHAR	2	0	Employee specification	*
6	EEEMP	☐	EMPCT	BSGRD	DEC	5	2	Employment percentage
7	EEMWH	☐	P12_SB_MWHWK	DEC3_2	DEC	5	2	Mean weekly working hours
8	EERFM	☐	P12_SB_RFMWH	DEC3_2	DEC	5	2	Reference Weekly Working Hours
9	EEREM	☐	P12_REMES	P12_REMES	NUMC	3	0	Reorganization measure
10	EEBEU	☐	BEUWG	DEC3_2	DEC	5	2	Contractual Mean Working Hours per week
11	EEBE2	☐	P12_BEUW2	DEC3_2	DEC	5	2	Mean number of hours per week
12	.INCLUDE	☐				0	0	Social Balance: EMPLOYEE - CALCULATED DATA AT end date SB
13	EEFBA	☐	P12_SB_BSOBA	P12_SB_BSOBA	CHAR	1	0	Relevance for Social Balance Declaration Reporting
14	EEFTI	☐	P12_SB_FULL_TIME_IND	XFELD	CHAR	1	0	Full-Time
15	EEPTI	☐	P12_SB_PART_TIME_IND	XFELD	CHAR	1	0	Part-Time
16	EESAN	☐	P12_SB_ANSTA	P12_SB_ANSTA	NUMC	1	0	Employment Type
17	EESCT	☐	P12_SB_CTTYP	P12_SB_CTTYP	CHAR	1	0	Contract Type for Declaration Purposes
18	EESLR	☐	P12_SB_HIGHEST_SLART	SLART	CHAR	2	0	Highest Educational Establishment	*
19	EESLB	☐	P12_SB_HIGHEST_SLABS	SLABS	CHAR	2	0	Highest Certificate	*
20	EEDTY	☐	P12_SB_HIGHEST_EDTYP	EDTYP	CHAR	2	0	Highest Education Type
21	.INCLUDE	☐				0	0	Social Balance: Employee DECLARATION CODES Structure
22	0105	☐	P12_SBCD_0105	NUMC1	NUMC	1	0	Social Balance: Code 0105 value
23	.INCLUDE	☐				0	0	Social Balance: CODE 0105 Structure
24	0105A	☐	P12_SBCD_0105A	P12_DEC15_2	DEC	15	2	0105A - Number of Employees at Year End (Full-Time)
25	0105B	☐	P12_SBCD_0105B	P12_DEC15_2	DEC	15	2	0105B - Number of Employees at Year End (Part-Time)
26	0105C	☐	P12_SBCD_0105C	P12_DEC15_2	DEC	15	2	0105C - Number of Employees at Year End (FTE)
27	0110	☐	P12_SBCD_0110	NUMC1	NUMC	1	0	Social Balance: Code 0110 value
28	.INCLUDE	☐				0	0	Social Balance: CODE 0110 Structure
29	0110A	☐	P12_SBCD_0110A	P12_DEC15_2	DEC	15	2	0110A - Employees with Unlimited Contracts at Year End (FT)
30	0110B	☐	P12_SBCD_0110B	P12_DEC15_2	DEC	15	2	0110B - Employees with Unlimited Contracts at Year End (PT)
31	0110C	☐	P12_SBCD_0110C	P12_DEC15_2	DEC	15	2	0110C - Employees with Unlimited Contracts at Year End (FTE)
32	0111	☐	P12_SBCD_0111	NUMC1	NUMC	1	0	Social Balance: Code 0111 value
33	.INCLUDE	☐				0	0	Social Balance: CODE 0111 Structure
34	0111A	☐	P12_SBCD_0111A	P12_DEC15_2	DEC	15	2	0111A - Employees with Fixed Term Contracts at Year End (FT)
35	0111B	☐	P12_SBCD_0111B	P12_DEC15_2	DEC	15	2	0111B - Employees with Fixed Term Contacts at Year End (PT)
36	0111C	☐	P12_SBCD_0111C	P12_DEC15_2	DEC	15	2	0111C - Employees with Fixed Term Contracts Year End (FTE)
37	0112	☐	P12_SBCD_0112	NUMC1	NUMC	1	0	Social Balance: Code 0112 value
38	.INCLUDE	☐				0	0	Social Balance: CODE 0112 Structure
39	0112A	☐	P12_SBCD_0112A	P12_DEC15_2	DEC	15	2	0112A - Employees with Specific Contracts at Year End (FT)
40	0112B	☐	P12_SBCD_0112B	P12_DEC15_2	DEC	15	2	0112B - Employees with Specific Contracts at Year End (PT)
41	0112C	☐	P12_SBCD_0112C	P12_DEC15_2	DEC	15	2	0112C - Employees with Specific Contracts at Year End (FTE)
42	0113	☐	P12_SBCD_0113	NUMC1	NUMC	1	0	Social Balance: Code 0113 value
43	.INCLUDE	☐				0	0	Social Balance: CODE 0113 Structure
44	0113A	☐	P12_SBCD_0113A	P12_DEC15_2	DEC	15	2	0113A - Employees with Replacement Contracts Year End (FT)
45	0113B	☐	P12_SBCD_0113B	P12_DEC15_2	DEC	15	2	0113B - Employees with Replacement Contracts Year End (PT)
46	0113C	☐	P12_SBCD_0113C	P12_DEC15_2	DEC	15	2	0113C - Employees with Replacement Contracts Year End (FTE)
47	0120	☐	P12_SBCD_0120	NUMC1	NUMC	1	0	Social Balance: Code 0120 value
48	.INCLUDE	☐				0	0	Social Balance: CODE 0120 Structure
49	0120A	☐	P12_SBCD_0120A	P12_DEC15_2	DEC	15	2	0120A - Number of Male Employees at Year End (Full-Time)
50	0120B	☐	P12_SBCD_0120B	P12_DEC15_2	DEC	15	2	0120B - Number of Male Employees at Year End (Part-Time)
51	0120C	☐	P12_SBCD_0120C	P12_DEC15_2	DEC	15	2	0120C - Number of Male Employees at Year End (FTE)
52	1200	☐	P12_SBCD_1200	NUMC1	NUMC	1	0	Social Balance: Code 1200 value
53	.INCLUDE	☐				0	0	Social Balance: CODE 1200 Structure
54	1200A	☐	P12_SBCD_1200A	P12_DEC15_2	DEC	15	2	1200A - Male Employees with Primary Education (Full-Time)
55	1200B	☐	P12_SBCD_1200B	P12_DEC15_2	DEC	15	2	1200B - Male Employees with Primary Education (Part-Time)
56	1200C	☐	P12_SBCD_1200C	P12_DEC15_2	DEC	15	2	1200C - Male Employees with Primary Education (FTE)
57	1201	☐	P12_SBCD_1201	NUMC1	NUMC	1	0	Social Balance: Code 1201 value
58	.INCLUDE	☐				0	0	Social Balance: CODE 1201 Structure
59	1201A	☐	P12_SBCD_1201A	P12_DEC15_2	DEC	15	2	1201A - Male Employees with Secondary Education (Full-Time)
60	1201B	☐	P12_SBCD_1201B	P12_DEC15_2	DEC	15	2	1201B - Male Employees with Secondary Education (Part-Time)
61	1201C	☐	P12_SBCD_1201C	P12_DEC15_2	DEC	15	2	1201C - Male Employees with Secondary Education (FTE)
62	1202	☐	P12_SBCD_1202	NUMC1	NUMC	1	0	Social Balance: Code 1202 value
63	.INCLUDE	☐				0	0	Social Balance: CODE 1201 Structure
64	1202A	☐	P12_SBCD_1202A	P12_DEC15_2	DEC	15	2	1202A - Male Employees with Higher Education (Full-Time)
65	1202B	☐	P12_SBCD_1202B	P12_DEC15_2	DEC	15	2	1202B - Male Employees with Higher Education (Part-Time)
66	1202C	☐	P12_SBCD_1202C	P12_DEC15_2	DEC	15	2	1202C - Male Employees with Higher Education (FTE)
67	1203	☐	P12_SBCD_1203	NUMC1	NUMC	1	0	Social Balance: Code 1203 value
68	.INCLUDE	☐				0	0	Social Balance: CODE 1203 Structure
69	1203A	☐	P12_SBCD_1203A	P12_DEC15_2	DEC	15	2	1203A - Male Employees with Uni. Education (Full-Time)
70	1203B	☐	P12_SBCD_1203B	P12_DEC15_2	DEC	15	2	1203B - Male Employees with Uni. Education (Part-Time)
71	1203C	☐	P12_SBCD_1203C	P12_DEC15_2	DEC	15	2	1203C - Male Employees with Uni. Education (FTE)
72	0121	☐	P12_SBCD_0121	NUMC1	NUMC	1	0	Social Balance: Code 0121 value
73	.INCLUDE	☐				0	0	Social Balance: CODE 0121 Structure
74	0121A	☐	P12_SBCD_0121A	P12_DEC15_2	DEC	15	2	0121A - Number of Female Employees at Year End (Full-Time)
75	0121B	☐	P12_SBCD_0121B	P12_DEC15_2	DEC	15	2	0121B - Number of Female Employees at Year End (Part-Time)
76	0121C	☐	P12_SBCD_0121C	P12_DEC15_2	DEC	15	2	0120C - Number of Female Employees at Year End (FTE)
77	1210	☐	P12_SBCD_1210	NUMC1	NUMC	1	0	Social Balance: Code 1210 value
78	.INCLUDE	☐				0	0	Social Balance: CODE 1210 Structure
79	1210A	☐	P12_SBCD_1210A	P12_DEC15_2	DEC	15	2	1210A - Female Employees with Primary Education (Full-Time)
80	1210B	☐	P12_SBCD_1210B	P12_DEC15_2	DEC	15	2	1210B - Female Employees with Primary Education (Part-Time)
81	1210C	☐	P12_SBCD_1210C	P12_DEC15_2	DEC	15	2	1210C - Female Employees with Primary Education (FTE)
82	1211	☐	P12_SBCD_1211	NUMC1	NUMC	1	0	Social Balance: Code 1211 value
83	.INCLUDE	☐				0	0	Social Balance: CODE 1211 Structure
84	1211A	☐	P12_SBCD_1211A	P12_DEC15_2	DEC	15	2	1211A - Female Emps with Secondary Education (Full-Time)
85	1211B	☐	P12_SBCD_1211B	P12_DEC15_2	DEC	15	2	1211B - Female Emps with Secondary Education (Part-Time)
86	1211C	☐	P12_SBCD_1211C	P12_DEC15_2	DEC	15	2	1211C - Female Employees with Secondary Education (FTE)
87	1212	☐	P12_SBCD_1212	NUMC1	NUMC	1	0	Social Balance: Code 1212 value
88	.INCLUDE	☐				0	0	Social Balance: CODE 1211 Structure
89	1212A	☐	P12_SBCD_1212A	P12_DEC15_2	DEC	15	2	1212A - Female Employees with Higher Education (Full-Time)
90	1212B	☐	P12_SBCD_1212B	P12_DEC15_2	DEC	15	2	1212B - Female Employees with Higher Education (Part-Time)
91	1212C	☐	P12_SBCD_1212C	P12_DEC15_2	DEC	15	2	1212C - Female Employees with Higher Education (FTE)
92	1213	☐	P12_SBCD_1213	NUMC1	NUMC	1	0	Social Balance: Code 1213 value
93	.INCLUDE	☐				0	0	Social Balance: CODE 1213 Structure
94	1213A	☐	P12_SBCD_1213A	P12_DEC15_2	DEC	15	2	1213A - Female Employees with Uni. Education (Full-Time)
95	1213B	☐	P12_SBCD_1213B	P12_DEC15_2	DEC	15	2	1213B - Female Employees with Uni. Education (Part-Time)
96	1213C	☐	P12_SBCD_1213C	P12_DEC15_2	DEC	15	2	1213C - Female Employees with Uni. Education (FTE)
97	0130	☐	P12_SBCD_0130	NUMC1	NUMC	1	0	Social Balance: Code 0130 value
98	.INCLUDE	☐				0	0	Social Balance: CODE 0120 Structure
99	0130A	☐	P12_SBCD_0130A	P12_DEC15_2	DEC	15	2	0130A - Number of Managing Directors at Year End (Full-Time)
100	0130B	☐	P12_SBCD_0130B	P12_DEC15_2	DEC	15	2	0130B - Number of Managing Directors at Year End (Part-Time)
101	0130C	☐	P12_SBCD_0130C	P12_DEC15_2	DEC	15	2	0130C - Number of Managing Directors at Year End (FTE)
102	0132	☐	P12_SBCD_0132	NUMC1	NUMC	1	0	Social Balance: Code 0132 value
103	.INCLUDE	☐				0	0	Social Balance: CODE 0120 Structure
104	0132A	☐	P12_SBCD_0132A	P12_DEC15_2	DEC	15	2	0132A - Number of Blue Collar Workers at Year End (FT)
105	0132B	☐	P12_SBCD_0132B	P12_DEC15_2	DEC	15	2	0132B - Number of Blue Collar Workers at Year End (PT)
106	0132C	☐	P12_SBCD_0132C	P12_DEC15_2	DEC	15	2	0132C - Number of Blue Collar Workers at Year End (FTE)
107	0133	☐	P12_SBCD_0133	NUMC1	NUMC	1	0	Social Balance: Code 0133 value
108	.INCLUDE	☐				0	0	Social Balance: CODE 0120 Structure
109	0133A	☐	P12_SBCD_0133A	P12_DEC15_2	DEC	15	2	0133A - Number of Other Workers at Year End (Full-Time)
110	0133B	☐	P12_SBCD_0133B	P12_DEC15_2	DEC	15	2	0133B - Number of Other Workers at Year End (Part-Time)
111	0133C	☐	P12_SBCD_0133C	P12_DEC15_2	DEC	15	2	0133C - Number of Other Workers at Year End (FTE)
112	0134	☐	P12_SBCD_0134	NUMC1	NUMC	1	0	Social Balance: Code 0134 value
113	.INCLUDE	☐				0	0	Social Balance: CODE 0120 Structure
114	0134A	☐	P12_SBCD_0134A	P12_DEC15_2	DEC	15	2	0134A - Number of White Collar Workers at Year End (FT)
115	0134B	☐	P12_SBCD_0134B	P12_DEC15_2	DEC	15	2	0134B - Number of White Collar Workers at Year End (PT)
116	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