SAP ABAP Table P12SB00_DAQ_S_EE_DETAIL_2013 (Social Balance SB00: DAQ EMPLOYEE DETAIL DATA Struct. 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_S_EE_DETAIL_2013	Table Relationship Diagram
Short Description	Social Balance SB00: DAQ EMPLOYEE DETAIL DATA Struct. 2013

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

History

Last changed by/on	SAP	20131127
SAP Release Created in