SAP ABAP Table P12SB00_DAQ_T_EE_DETAIL_2013 (Social Balance SB00: DAQ EMPLOYEE DATA Table 2013)

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_DETAIL_2013	Table Relationship Diagram
Short Description	Social Balance SB00: DAQ EMPLOYEE DATA Table 2013

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 DETAIL DATA Struct. 2013
3	.INCLUDE				0	0	Social Balance: EMPLOYEE DETAIL - KEY FIELDS
4	EDPNR	P_PERNR	PERNR	NUMC	8	0	Personnel Number
5	EDRSZ	RSZRR	NUM11	NUMC	11	0	INSS - National ID number (00024)
6	EDMOD	P12_SB_MODEE	P12_SB_MODEE	CHAR	4	0	Employee Grouping	*
7	EDPIR	P12_SBPERIOD	CHAR6	CHAR	6	0	Declaration Period
8	EDLST	P12_SB_ENDDA_PERIOD_10	CHAR10	CHAR	10	0	Period End Date
9	EDBEG	P12_SB_BEGDA_10	CHAR10	CHAR	10	0	Record Start Date
10	EDEND	P12_SB_ENDDA_10	CHAR10	CHAR	10	0	Record End Date
11	.INCLUDE				0	0	Social Balance: EE EXTERNAL ORGANIZATIONAL Data
12	EDCCD	BUKRS	BUKRS	CHAR	4	0	Company Code	*
13	EDPRA	PERSA	PERSA	CHAR	4	0	Personnel Area	*
14	EDPSA	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
15	EDEGR	PERSG	PERSG	CHAR	1	0	Employee Group	*
16	EDESG	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
17	EDKOS	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
18	.INCLUDE				0	0	Social Balance: EMPLOYEE DETAIL Social Balance BASIC D 2013
19	EDGES	GESCH	GESCH	CHAR	1	0	Gender Key
20	EDAKT	P12_SB_AKTIVJN	XFELD	CHAR	1	0	Employee Active for Declaration Purposes
21	EDANS	ANSTA	NUM1	NUMC	1	0	Employment status
22	EDCTT	CTTYP	CTTYP	CHAR	2	0	Contract Type	*
23	EDRSP	RSZSP	RSZSP	CHAR	2	0	Employee specification	*
24	EDEMP	EMPCT	BSGRD	DEC	5	2	Employment percentage
25	EDMWH	P12_SB_MWHWK	DEC3_2	DEC	5	2	Mean weekly working hours
26	EDRFM	P12_SB_RFMWH	DEC3_2	DEC	5	2	Reference Weekly Working Hours
27	EDREM	P12_REMES	P12_REMES	NUMC	3	0	Reorganization measure
28	EDBEU	BEUWG	DEC3_2	DEC	5	2	Contractual Mean Working Hours per week
29	EDBE2	P12_BEUW2	DEC3_2	DEC	5	2	Mean number of hours per week
30	EDBPC	BEGPC	BEGPC	CHAR	7	0	Joint Commission (00046)	*
31	EDNAC	P12P_ONSSAPLCODE76	P12P_ONSSAPLCODE76	NUMC	5	0	Employee Activity Code (NACE) (00228)	*
32	.INCLUDE				0	0	Social Balance: EMPLOYEE DETAIL SB Calculated Data
33	EDFBA	P12_SB_BSOBA	P12_SB_BSOBA	CHAR	1	0	Relevance for Social Balance Declaration Reporting
34	EDFTI	P12_SB_FULL_TIME_IND	XFELD	CHAR	1	0	Full-Time
35	EDPTI	P12_SB_PART_TIME_IND	XFELD	CHAR	1	0	Part-Time
36	EDSCT	P12_SB_CTTYP	P12_SB_CTTYP	CHAR	1	0	Contract Type for Declaration Purposes
37	.INCLUDE				0	0	Social Balance: Employee DECLARATION CODES Structure 2013
38	0100	P12_SBCD_0100	NUMC1	NUMC	1	0	0100 - Average Number of Employees
39	.INCLUDE				0	0	Social Balance: CODE 1001 Structure
40	1001A	P12_SBCD_1001A	P12_DEC15_2	DEC	15	2	1001A - Average Number of Employees Full-Time (Men)
41	1001B	P12_SBCD_1001B	P12_DEC15_2	DEC	15	2	1001B - Average Number of Employees Full-Time (Women)
42	1001C	P12_SBCD_1001C	P12_DEC15_2	DEC	15	2	1001C - Average Number of Employees Full-Time (Total)
43	.INCLUDE				0	0	Social Balance: CODE 1002 Structure
44	1002A	P12_SBCD_1002A	P12_DEC15_2	DEC	15	2	1002A - Average Number of Employees Part-Time (Men)
45	1002B	P12_SBCD_1002B	P12_DEC15_2	DEC	15	2	1002B - Average Number of Employees Part-Time (Women)
46	1002C	P12_SBCD_1002C	P12_DEC15_2	DEC	15	2	1002C - Average Number of Employees Part-Time (Total)
47	.INCLUDE				0	0	Social Balance: CODE 1003 Structure
48	1003A	P12_SBCD_1003A	P12_DEC15_2	DEC	15	2	1003A - Average Number of Employees FTE (Men)
49	1003B	P12_SBCD_1003B	P12_DEC15_2	DEC	15	2	1003B - Average Number of Employees FTE (Women)
50	1003C	P12_SBCD_1003C	P12_DEC15_2	DEC	15	2	1003C - Average Number of Employees FTE (Total)
51	.INCLUDE				0	0	Social Balance: CODE 1011 Structure
52	1011A	P12_SBCD_1011A	P12_DEC15_2	DEC	15	2	1011A - Number of Hours Worked Full-Time (Men)
53	1011B	P12_SBCD_1011B	P12_DEC15_2	DEC	15	2	1011B - Number of Hours Worked Full-Time (Women)
54	1011C	P12_SBCD_1011C	P12_DEC15_2	DEC	15	2	1011C - Number of Hours Worked Full-Time (Total)
55	.INCLUDE				0	0	Social Balance: CODE 1012 Structure
56	1012A	P12_SBCD_1012A	P12_DEC15_2	DEC	15	2	1012A - Number of Hours Worked Part-Time (Men)
57	1012B	P12_SBCD_1012B	P12_DEC15_2	DEC	15	2	1012B - Number of Hours Worked Part-Time (Women)
58	1012C	P12_SBCD_1012C	P12_DEC15_2	DEC	15	2	1012C - Number of Hours Worked Part-Time (Total)
59	.INCLUDE				0	0	Social Balance: CODE 1013 Structure
60	1013A	P12_SBCD_1013A	P12_DEC15_2	DEC	15	2	1013A - Number of Hours Worked Total (Men)
61	1013B	P12_SBCD_1013B	P12_DEC15_2	DEC	15	2	1013B - Number of Hours Worked Total (Women)
62	1013C	P12_SBCD_1013C	P12_DEC15_2	DEC	15	2	1013C - Number of Hours Worked Total (All)
63	.INCLUDE				0	0	Social Balance: CODE 1021 Structure
64	1021A	P12_SBCD_1021A	P12_DEC15_2	DEC	15	2	1021A - Personnel Costs Full-Time (Men)
65	1021B	P12_SBCD_1021B	P12_DEC15_2	DEC	15	2	1021B - Personnel Costs Full-Time (Women)
66	1021C	P12_SBCD_1021C	P12_DEC15_2	DEC	15	2	1021C - Personnel Costs Full-Time (Total)
67	.INCLUDE				0	0	Social Balance: CODE 1022 Structure
68	1022A	P12_SBCD_1022A	P12_DEC15_2	DEC	15	2	1022A - Personnel Costs Part-Time (Men)
69	1022B	P12_SBCD_1022B	P12_DEC15_2	DEC	15	2	1022B - Personnel Costs Part-Time (Women)
70	1022C	P12_SBCD_1022C	P12_DEC15_2	DEC	15	2	1022C - Personnel Costs Part-Time (Total)
71	.INCLUDE				0	0	Social Balance: CODE 1023 Structure
72	1023A	P12_SBCD_1023A	P12_DEC15_2	DEC	15	2	1023A - Personnel Costs Total (Men)
73	1023B	P12_SBCD_1023B	P12_DEC15_2	DEC	15	2	1023B - Personnel Costs Total (Women)
74	1023C	P12_SBCD_1023C	P12_DEC15_2	DEC	15	2	1023C - Personnel Costs Total (All)
75	.INCLUDE				0	0	Social Balance: CODE 1033 Structure
76	1033A	P12_SBCD_1033A	P12_DEC15_2	DEC	15	2	1033A - Amount of Benefits on Top of Wages (Men)
77	1033B	P12_SBCD_1033B	P12_DEC15_2	DEC	15	2	1033B - Amount of Benefits on Top of Wages (Women)
78	1033C	P12_SBCD_1033C	P12_DEC15_2	DEC	15	2	1033C - Amount of Benefits on Top of Wages (Total)
79	.INCLUDE				0	0	Social Balance: CODE Previous Year 1003 Structure
80	P003A	P12_SBCD_PREV_1003A	P12_DEC15_2	DEC	15	2	1003A - Average Previous Year Number of Employees FTE (Men)
81	P003B	P12_SBCD_PREV_1003B	P12_DEC15_2	DEC	15	2	1003B - Average Prev. Year Number of Employees FTE (Women)
82	P003C	P12_SBCD_PREV_1003C	P12_DEC15_2	DEC	15	2	1003C - Average Previous Year Number of Employees FTE (All)
83	.INCLUDE				0	0	Social Balance: CODE Previous Year 1013 Structure
84	P013A	P12_SBCD_PREV_1013A	P12_DEC15_2	DEC	15	2	1013A - Previous Year Number of Hours Worked (Men)
85	P013B	P12_SBCD_PREV_1013B	P12_DEC15_2	DEC	15	2	1013B - Previous Year Number of Hours Worked (Women)
86	P013C	P12_SBCD_PREV_1013C	P12_DEC15_2	DEC	15	2	1013C - Previous Year Number of Hours Worked (Total)
87	.INCLUDE				0	0	Social Balance: CODE Previous Year 1023 Structure
88	P023A	P12_SBCD_PREV_1023A	P12_DEC15_2	DEC	15	2	1023A - Previous Year Personnel Costs (Men)
89	P023B	P12_SBCD_PREV_1023B	P12_DEC15_2	DEC	15	2	1023B - Previous Year Personnel Costs (Women)
90	P023C	P12_SBCD_PREV_1023C	P12_DEC15_2	DEC	15	2	1023C - Previous Year Personnel Costs (Total)
91	.INCLUDE				0	0	Social Balance: CODE Previous Year 1033 Structure
92	P033A	P12_SBCD_PREV_1033A	P12_DEC15_2	DEC	15	2	1033A - Prev. Year Amount of Benefits onTop of Wages (Men)
93	P033B	P12_SBCD_PREV_1033B	P12_DEC15_2	DEC	15	2	1033B - Prev. Year Amount of Benefits onTop of Wages (Women)
94	P033C	P12_SBCD_PREV_1033C	P12_DEC15_2	DEC	15	2	1033C - Prev.Year Amount of Benefits on Top of Wages (Total)