SAP ABAP Table P12SB00_DAQ_T_EE_DETAIL_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_EE_DETAIL_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 DETAIL DATA Struct. 2009
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 Data
19	EDAKT	☐	P12_SB_AKTIVJN	XFELD	CHAR	1	0	Employee Active for Declaration Purposes
20	EDANS	☐	ANSTA	NUM1	NUMC	1	0	Employment status
21	EDCTT	☐	CTTYP	CTTYP	CHAR	2	0	Contract Type	*
22	EDRSP	☐	RSZSP	RSZSP	CHAR	2	0	Employee specification	*
23	EDEMP	☐	EMPCT	BSGRD	DEC	5	2	Employment percentage
24	EDMWH	☐	P12_SB_MWHWK	DEC3_2	DEC	5	2	Mean weekly working hours
25	EDRFM	☐	P12_SB_RFMWH	DEC3_2	DEC	5	2	Reference Weekly Working Hours
26	EDREM	☐	P12_REMES	P12_REMES	NUMC	3	0	Reorganization measure
27	EDBEU	☐	BEUWG	DEC3_2	DEC	5	2	Contractual Mean Working Hours per week
28	EDBE2	☐	P12_BEUW2	DEC3_2	DEC	5	2	Mean number of hours per week
29	EDBPC	☐	P12_CI_BEGPC	P12_CI_BEGPC	CHAR	9	0	Joint Commission (00046)	*
30	EDNAC	☐	P12P_ONSSAPLCODE76	P12P_ONSSAPLCODE76	NUMC	5	0	Employee Activity Code (NACE) (00228)	*
31	.INCLUDE	☐				0	0	Social Balance: EMPLOYEE DETAIL SB Calculated Data
32	EDFBA	☐	P12_SB_BSOBA	P12_SB_BSOBA	CHAR	1	0	Relevance for Social Balance Declaration Reporting
33	EDFTI	☐	P12_SB_FULL_TIME_IND	XFELD	CHAR	1	0	Full-Time
34	EDPTI	☐	P12_SB_PART_TIME_IND	XFELD	CHAR	1	0	Part-Time
35	EDSCT	☐	P12_SB_CTTYP	P12_SB_CTTYP	CHAR	1	0	Contract Type for Declaration Purposes
36	.INCLUDE	☐				0	0	Social Balance: Employee DECLARATION CODES Structure
37	0100	☐	P12_SBCD_0100	NUMC1	NUMC	1	0	0100 - Average Number of Employees
38	.INCLUDE	☐				0	0	Social Balance: CODE 0100 Structure
39	0100A	☐	P12_SBCD_0100A	P12_DEC15_2	DEC	15	2	0100A - Average Number of Employees (Full-Time)
40	0100B	☐	P12_SBCD_0100B	P12_DEC15_2	DEC	15	2	0100B - Average Number of Employees (Part-Time)
41	0100C	☐	P12_SBCD_0100C	P12_DEC15_2	DEC	15	2	0100C - Average Number of Employees (FTE)
42	0100D	☐	P12_SBCD_0100D	P12_DEC15_2	DEC	15	2	0100D - Average Number of Employees (FTE Previous)
43	.INCLUDE	☐				0	0	Social Balance: CODE 0101 Structure
44	0101A	☐	P12_SBCD_0101A	P12_DEC15_2	DEC	15	2	0101A - Number of Hours Worked (Full-Time)
45	0101B	☐	P12_SBCD_0101B	P12_DEC15_2	DEC	15	2	0101B - Number of Hours Worked (Part-Time)
46	0101C	☐	P12_SBCD_0101C	P12_DEC15_2	DEC	15	2	0101C - Number of Hours Worked (Total)
47	0101D	☐	P12_SBCD_0101D	P12_DEC15_2	DEC	15	2	0101D - Number of Hours Worked (Total Previous)
48	.INCLUDE	☐				0	0	Social Balance: CODE 0102 Structure
49	0102A	☐	P12_SBCD_0102A	P12_DEC15_2	DEC	15	2	0102A - Personnel Costs (Full-Time)
50	0102B	☐	P12_SBCD_0102B	P12_DEC15_2	DEC	15	2	0102B - Personnel Costs (Part-Time)
51	0102C	☐	P12_SBCD_0102C	P12_DEC15_2	DEC	15	2	0102C - Personnel Costs (Total)
52	0102D	☐	P12_SBCD_0102D	P12_DEC15_2	DEC	15	2	0102D - Personnel Costs (Total Previous)
53	.INCLUDE	☐				0	0	Social Balance: CODE 0103 Structure
54	0103C	☐	P12_SBCD_0103C	P12_DEC15_2	DEC	15	2	0103C - Amount of Benefits on Top of Wages (Total)
55	0103D	☐	P12_SBCD_0103D	P12_DEC15_2	DEC	15	2	0103D - Amount of Benefits on Top of Wages (Total Previous)

History

Last changed by/on	SAP	20130529
SAP Release Created in	600