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
⤷ 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 |