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