SAP ABAP Table P12SB00_DAQ_T_EE_LEAVE_2009 (Social Balance SB00: DAQ EMPLOYEE LEAVE 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_EE_LEAVE_2009	Table Relationship Diagram
Short Description	Social Balance SB00: DAQ EMPLOYEE LEAVE DATA Table 2009

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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 LEAVE DATA Struct. 2009
3	.INCLUDE				0	0	Social Balance: EMPLOYEE LEAVE - KEY FIELDS
4	LEPNR	P_PERNR	PERNR	NUMC	8	0	Personnel Number
5	LERSZ	RSZRR	NUM11	NUMC	11	0	INSS - National ID number (00024)
6	LEMOD	P12_SB_MODEE	P12_SB_MODEE	CHAR	4	0	Employee Grouping	*
7	LEPIR	P12_SBPERIOD	CHAR6	CHAR	6	0	Declaration Period
8	LEAVE	P12_SB_LEAVE_DATE	P12_SB_LEAVE_DATE	DATS	8	0	Departure Date
9	.INCLUDE				0	0	Social Balance: EE LEAVE ORGANIZATIONAL Data
10	LECCD	BUKRS	BUKRS	CHAR	4	0	Company Code	*
11	LEPRA	PERSA	PERSA	CHAR	4	0	Personnel Area	*
12	LEPSA	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
13	LEEGR	PERSG	PERSG	CHAR	1	0	Employee Group	*
14	LEESG	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
15	LEKOS	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
16	.INCLUDE				0	0	Social Balance: EMPLOYEE LEAVE BASIC Data
17	LEAKT	P12_SB_AKTIVJN	XFELD	CHAR	1	0	Employee Active for Declaration Purposes
18	LEANS	ANSTA	NUM1	NUMC	1	0	Employment status
19	LECTT	CTTYP	CTTYP	CHAR	2	0	Contract Type	*
20	LERSP	RSZSP	RSZSP	CHAR	2	0	Employee specification	*
21	LEEMP	EMPCT	BSGRD	DEC	5	2	Employment percentage
22	LEMWH	P12_SB_MWHWK	DEC3_2	DEC	5	2	Mean weekly working hours
23	LERFM	P12_SB_RFMWH	DEC3_2	DEC	5	2	Reference Weekly Working Hours
24	LEREM	P12_REMES	P12_REMES	NUMC	3	0	Reorganization measure
25	LEBEU	BEUWG	DEC3_2	DEC	5	2	Contractual Mean Working Hours per week
26	LEMAN	MASSN	MASSN	CHAR	2	0	Action Type	*
27	LEMAG	MASSG	MASSG	CHAR	2	0	Reason for Action	*
28	LEBE2	P12_BEUW2	DEC3_2	DEC	5	2	Mean number of hours per week
29	.INCLUDE				0	0	Social Balance: EMPLOYEE LEAVE CALCULATED Data
30	LEFBA	P12_SB_BSOBA	P12_SB_BSOBA	CHAR	1	0	Relevance for Social Balance Declaration Reporting
31	LEFTI	P12_SB_FULL_TIME_IND	XFELD	CHAR	1	0	Full-Time
32	LEPTI	P12_SB_PART_TIME_IND	XFELD	CHAR	1	0	Part-Time
33	LESCT	P12_SB_CTTYP	P12_SB_CTTYP	CHAR	1	0	Contract Type for Declaration Purposes
34	LESMG	P12_SB_MASSG	P12_SB_MASSG	CHAR	1	0	Reason for Contract Termination
35	.INCLUDE				0	0	Social Balance: Employee LEAVE CODES Structure
36	0305	P12_SBCD_0305	NUMC1	NUMC	1	0	Social Balance: Code 0305 value
37	.INCLUDE				0	0	Social Balance: CODE 0305 Structure
38	0305A	P12_SBCD_0305A	P12_DEC15_2	DEC	15	2	0305A - Number of Departures (Full-Time)
39	0305B	P12_SBCD_0305B	P12_DEC15_2	DEC	15	2	0305B - Number of Departures (Part-Time)
40	0305C	P12_SBCD_0305C	P12_DEC15_2	DEC	15	2	0305C - Number of Departures (FTE)
41	0310	P12_SBCD_0310	NUMC1	NUMC	1	0	Social Balance: Code 0310 value
42	.INCLUDE				0	0	Social Balance: CODE 0310 Structure
43	0310A	P12_SBCD_0310A	P12_DEC15_2	DEC	15	2	0310A -Departures with Unlimited Contracts (Full-Time)
44	0310B	P12_SBCD_0310B	P12_DEC15_2	DEC	15	2	0310B - Departures with Unlimited Contracts (Part-Time)
45	0310C	P12_SBCD_0310C	P12_DEC15_2	DEC	15	2	0310C - Departures with Unlimited Contracts (FTE)
46	0311	P12_SBCD_0311	NUMC1	NUMC	1	0	Social Balance: Code 0311 value
47	.INCLUDE				0	0	Social Balance: CODE 0311 Structure
48	0311A	P12_SBCD_0311A	P12_DEC15_2	DEC	15	2	0311A - Departures with Fixed-Term Contracts (Full-Time)
49	0311B	P12_SBCD_0311B	P12_DEC15_2	DEC	15	2	0311B - Departures with Fixed-Term Contracts (Part-Time)
50	0311C	P12_SBCD_0311C	P12_DEC15_2	DEC	15	2	0311C - Departures with Fixed-Term Contracts (FTE)
51	0312	P12_SBCD_0312	NUMC1	NUMC	1	0	Social Balance: Code 0312 value
52	.INCLUDE				0	0	Social Balance: CODE 0312 Structure
53	0312A	P12_SBCD_0312A	P12_DEC15_2	DEC	15	2	0312A - Departures with Specific Job Contracts (Full-Time)
54	0312B	P12_SBCD_0312B	P12_DEC15_2	DEC	15	2	0312B - Departures with Specific Job Contracts (Part-Time)
55	0312C	P12_SBCD_0312C	P12_DEC15_2	DEC	15	2	0312C - Departures with Specific Job Contracts (FTE)
56	0313	P12_SBCD_0313	NUMC1	NUMC	1	0	Social Balance: Code 0313 value
57	.INCLUDE				0	0	Social Balance: CODE 0313 Structure
58	0313A	P12_SBCD_0313A	P12_DEC15_2	DEC	15	2	0313A - Departures with Replacement Contracts (Full-Time)
59	0313B	P12_SBCD_0313B	P12_DEC15_2	DEC	15	2	0313B - Departures with Replacement Contracts (Part-Time)
60	0313C	P12_SBCD_0313C	P12_DEC15_2	DEC	15	2	0313C - Departures with Replacement Contracts (FTE)
61	0340	P12_SBCD_0340	NUMC1	NUMC	1	0	Social Balance: Code 0340 value
62	.INCLUDE				0	0	Social Balance: CODE 0340 Structure
63	0340A	P12_SBCD_0340A	P12_DEC15_2	DEC	15	2	0340A - Contract Termination due to Retirement (Full-Time)
64	0340B	P12_SBCD_0340B	P12_DEC15_2	DEC	15	2	0340B - Contract Termination due to Retirement (Part-Time)
65	0340C	P12_SBCD_0340C	P12_DEC15_2	DEC	15	2	0340C - Contract Termination due to Retirement (FTE)
66	0341	P12_SBCD_0341	NUMC1	NUMC	1	0	Social Balance: Code 0341 value
67	.INCLUDE				0	0	Social Balance: CODE 0341 Structure
68	0341A	P12_SBCD_0341A	P12_DEC15_2	DEC	15	2	0341A - Contract Termination due to SUC (Full-Time)
69	0341B	P12_SBCD_0341B	P12_DEC15_2	DEC	15	2	0341B - Contract Termination due to SUC (Part-Time)
70	0341C	P12_SBCD_0341C	P12_DEC15_2	DEC	15	2	0341C - Contract Termination due to SUC (FTE)
71	0342	P12_SBCD_0342	NUMC1	NUMC	1	0	Social Balance: Code 0342 value
72	.INCLUDE				0	0	Social Balance: CODE 0342 Structure
73	0342A	P12_SBCD_0342A	P12_DEC15_2	DEC	15	2	0342A - Contract Termination due to Dismissal (Full-Time)
74	0342B	P12_SBCD_0342B	P12_DEC15_2	DEC	15	2	0342B - Contract Termination due to Dismissal (Part-Time)
75	0342C	P12_SBCD_0342C	P12_DEC15_2	DEC	15	2	0342C - Contract Termination due to Dismissal (FTE)
76	0343	P12_SBCD_0343	NUMC1	NUMC	1	0	Social Balance: Code 0343 value
77	.INCLUDE				0	0	Social Balance: CODE 0343 Structure
78	0343A	P12_SBCD_0343A	P12_DEC15_2	DEC	15	2	0343A - Contract Termination for Other Reasons (Full-Time)
79	0343B	P12_SBCD_0343B	P12_DEC15_2	DEC	15	2	0343B - Contract Termination for Other Reasons (Part-Time)
80	0343C	P12_SBCD_0343C	P12_DEC15_2	DEC	15	2	0343C - Contract Termination for Other Reasons (FTE)
81	0350	P12_SBCD_0350	NUMC1	NUMC	1	0	Social Balance: Code 0350 value
82	.INCLUDE				0	0	Social Balance: CODE 0350 Structure
83	0350A	P12_SBCD_0350A	P12_DEC15_2	DEC	15	2	0350A - Contract Termination (Full-Time) now Self-Employed
84	0350B	P12_SBCD_0350B	P12_DEC15_2	DEC	15	2	0350B - Contract Termination (Part-Time) now Self-Employed
85	0350C	P12_SBCD_0350C	P12_DEC15_2	DEC	15	2	0350C - Contract Termination (FTE) now Self-Employed