SAP ABAP Table P12SB00_DAQ_T_EE_LEAVE_2009 (Social Balance SB00: DAQ EMPLOYEE LEAVE 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
⤷ PY-BE (Application Component) Belgium
⤷ PC12 (Package) HR accounting: Belgium
Basic Data
Table Category | INTTAB | Structure |
Structure | P12SB00_DAQ_T_EE_LEAVE_2009 | Table Relationship Diagram |
Short Description | Social Balance SB00: DAQ EMPLOYEE LEAVE 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 LEAVE DATA Struct. 2009 | |||||
3 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE LEAVE - KEY FIELDS | |||||
4 | LEPNR | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
5 | LERSZ | RSZRR | NUM11 | NUMC | 11 | 0 | INSS - National ID number (00024) | ||
6 | LEMOD | P12_SB_MODEE | P12_SB_MODEE | CHAR | 4 | 0 | Employee Grouping | * | |
7 | LEPIR | P12_SBPERIOD | CHAR6 | CHAR | 6 | 0 | Declaration Period | ||
8 | LEAVE | P12_SB_LEAVE_DATE | P12_SB_LEAVE_DATE | DATS | 8 | 0 | Departure Date | ||
9 | .INCLUDE | 0 | 0 | Social Balance: EE LEAVE ORGANIZATIONAL Data | |||||
10 | LECCD | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
11 | LEPRA | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
12 | LEPSA | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
13 | LEEGR | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | * | |
14 | LEESG | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | * | |
15 | LEKOS | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
16 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE LEAVE BASIC Data | |||||
17 | LEAKT | P12_SB_AKTIVJN | XFELD | CHAR | 1 | 0 | Employee Active for Declaration Purposes | ||
18 | LEANS | ANSTA | NUM1 | NUMC | 1 | 0 | Employment status | ||
19 | LECTT | CTTYP | CTTYP | CHAR | 2 | 0 | Contract Type | * | |
20 | LERSP | RSZSP | RSZSP | CHAR | 2 | 0 | Employee specification | * | |
21 | LEEMP | EMPCT | BSGRD | DEC | 5 | 2 | Employment percentage | ||
22 | LEMWH | P12_SB_MWHWK | DEC3_2 | DEC | 5 | 2 | Mean weekly working hours | ||
23 | LERFM | P12_SB_RFMWH | DEC3_2 | DEC | 5 | 2 | Reference Weekly Working Hours | ||
24 | LEREM | P12_REMES | P12_REMES | NUMC | 3 | 0 | Reorganization measure | ||
25 | LEBEU | BEUWG | DEC3_2 | DEC | 5 | 2 | Contractual Mean Working Hours per week | ||
26 | LEMAN | MASSN | MASSN | CHAR | 2 | 0 | Action Type | * | |
27 | LEMAG | MASSG | MASSG | CHAR | 2 | 0 | Reason for Action | * | |
28 | LEBE2 | P12_BEUW2 | DEC3_2 | DEC | 5 | 2 | Mean number of hours per week | ||
29 | .INCLUDE | 0 | 0 | Social Balance: EMPLOYEE LEAVE CALCULATED Data | |||||
30 | LEFBA | P12_SB_BSOBA | P12_SB_BSOBA | CHAR | 1 | 0 | Relevance for Social Balance Declaration Reporting | ||
31 | LEFTI | P12_SB_FULL_TIME_IND | XFELD | CHAR | 1 | 0 | Full-Time | ||
32 | LEPTI | P12_SB_PART_TIME_IND | XFELD | CHAR | 1 | 0 | Part-Time | ||
33 | LESCT | P12_SB_CTTYP | P12_SB_CTTYP | CHAR | 1 | 0 | Contract Type for Declaration Purposes | ||
34 | LESMG | P12_SB_MASSG | P12_SB_MASSG | CHAR | 1 | 0 | Reason for Contract Termination | ||
35 | .INCLUDE | 0 | 0 | Social Balance: Employee LEAVE CODES Structure | |||||
36 | 0305 | P12_SBCD_0305 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0305 value | ||
37 | .INCLUDE | 0 | 0 | Social Balance: CODE 0305 Structure | |||||
38 | 0305A | P12_SBCD_0305A | P12_DEC15_2 | DEC | 15 | 2 | 0305A - Number of Departures (Full-Time) | ||
39 | 0305B | P12_SBCD_0305B | P12_DEC15_2 | DEC | 15 | 2 | 0305B - Number of Departures (Part-Time) | ||
40 | 0305C | P12_SBCD_0305C | P12_DEC15_2 | DEC | 15 | 2 | 0305C - Number of Departures (FTE) | ||
41 | 0310 | P12_SBCD_0310 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0310 value | ||
42 | .INCLUDE | 0 | 0 | Social Balance: CODE 0310 Structure | |||||
43 | 0310A | P12_SBCD_0310A | P12_DEC15_2 | DEC | 15 | 2 | 0310A -Departures with Unlimited Contracts (Full-Time) | ||
44 | 0310B | P12_SBCD_0310B | P12_DEC15_2 | DEC | 15 | 2 | 0310B - Departures with Unlimited Contracts (Part-Time) | ||
45 | 0310C | P12_SBCD_0310C | P12_DEC15_2 | DEC | 15 | 2 | 0310C - Departures with Unlimited Contracts (FTE) | ||
46 | 0311 | P12_SBCD_0311 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0311 value | ||
47 | .INCLUDE | 0 | 0 | Social Balance: CODE 0311 Structure | |||||
48 | 0311A | P12_SBCD_0311A | P12_DEC15_2 | DEC | 15 | 2 | 0311A - Departures with Fixed-Term Contracts (Full-Time) | ||
49 | 0311B | P12_SBCD_0311B | P12_DEC15_2 | DEC | 15 | 2 | 0311B - Departures with Fixed-Term Contracts (Part-Time) | ||
50 | 0311C | P12_SBCD_0311C | P12_DEC15_2 | DEC | 15 | 2 | 0311C - Departures with Fixed-Term Contracts (FTE) | ||
51 | 0312 | P12_SBCD_0312 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0312 value | ||
52 | .INCLUDE | 0 | 0 | Social Balance: CODE 0312 Structure | |||||
53 | 0312A | P12_SBCD_0312A | P12_DEC15_2 | DEC | 15 | 2 | 0312A - Departures with Specific Job Contracts (Full-Time) | ||
54 | 0312B | P12_SBCD_0312B | P12_DEC15_2 | DEC | 15 | 2 | 0312B - Departures with Specific Job Contracts (Part-Time) | ||
55 | 0312C | P12_SBCD_0312C | P12_DEC15_2 | DEC | 15 | 2 | 0312C - Departures with Specific Job Contracts (FTE) | ||
56 | 0313 | P12_SBCD_0313 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0313 value | ||
57 | .INCLUDE | 0 | 0 | Social Balance: CODE 0313 Structure | |||||
58 | 0313A | P12_SBCD_0313A | P12_DEC15_2 | DEC | 15 | 2 | 0313A - Departures with Replacement Contracts (Full-Time) | ||
59 | 0313B | P12_SBCD_0313B | P12_DEC15_2 | DEC | 15 | 2 | 0313B - Departures with Replacement Contracts (Part-Time) | ||
60 | 0313C | P12_SBCD_0313C | P12_DEC15_2 | DEC | 15 | 2 | 0313C - Departures with Replacement Contracts (FTE) | ||
61 | 0340 | P12_SBCD_0340 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0340 value | ||
62 | .INCLUDE | 0 | 0 | Social Balance: CODE 0340 Structure | |||||
63 | 0340A | P12_SBCD_0340A | P12_DEC15_2 | DEC | 15 | 2 | 0340A - Contract Termination due to Retirement (Full-Time) | ||
64 | 0340B | P12_SBCD_0340B | P12_DEC15_2 | DEC | 15 | 2 | 0340B - Contract Termination due to Retirement (Part-Time) | ||
65 | 0340C | P12_SBCD_0340C | P12_DEC15_2 | DEC | 15 | 2 | 0340C - Contract Termination due to Retirement (FTE) | ||
66 | 0341 | P12_SBCD_0341 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0341 value | ||
67 | .INCLUDE | 0 | 0 | Social Balance: CODE 0341 Structure | |||||
68 | 0341A | P12_SBCD_0341A | P12_DEC15_2 | DEC | 15 | 2 | 0341A - Contract Termination due to SUC (Full-Time) | ||
69 | 0341B | P12_SBCD_0341B | P12_DEC15_2 | DEC | 15 | 2 | 0341B - Contract Termination due to SUC (Part-Time) | ||
70 | 0341C | P12_SBCD_0341C | P12_DEC15_2 | DEC | 15 | 2 | 0341C - Contract Termination due to SUC (FTE) | ||
71 | 0342 | P12_SBCD_0342 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0342 value | ||
72 | .INCLUDE | 0 | 0 | Social Balance: CODE 0342 Structure | |||||
73 | 0342A | P12_SBCD_0342A | P12_DEC15_2 | DEC | 15 | 2 | 0342A - Contract Termination due to Dismissal (Full-Time) | ||
74 | 0342B | P12_SBCD_0342B | P12_DEC15_2 | DEC | 15 | 2 | 0342B - Contract Termination due to Dismissal (Part-Time) | ||
75 | 0342C | P12_SBCD_0342C | P12_DEC15_2 | DEC | 15 | 2 | 0342C - Contract Termination due to Dismissal (FTE) | ||
76 | 0343 | P12_SBCD_0343 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0343 value | ||
77 | .INCLUDE | 0 | 0 | Social Balance: CODE 0343 Structure | |||||
78 | 0343A | P12_SBCD_0343A | P12_DEC15_2 | DEC | 15 | 2 | 0343A - Contract Termination for Other Reasons (Full-Time) | ||
79 | 0343B | P12_SBCD_0343B | P12_DEC15_2 | DEC | 15 | 2 | 0343B - Contract Termination for Other Reasons (Part-Time) | ||
80 | 0343C | P12_SBCD_0343C | P12_DEC15_2 | DEC | 15 | 2 | 0343C - Contract Termination for Other Reasons (FTE) | ||
81 | 0350 | P12_SBCD_0350 | NUMC1 | NUMC | 1 | 0 | Social Balance: Code 0350 value | ||
82 | .INCLUDE | 0 | 0 | Social Balance: CODE 0350 Structure | |||||
83 | 0350A | P12_SBCD_0350A | P12_DEC15_2 | DEC | 15 | 2 | 0350A - Contract Termination (Full-Time) now Self-Employed | ||
84 | 0350B | P12_SBCD_0350B | P12_DEC15_2 | DEC | 15 | 2 | 0350B - Contract Termination (Part-Time) now Self-Employed | ||
85 | 0350C | P12_SBCD_0350C | P12_DEC15_2 | DEC | 15 | 2 | 0350C - Contract Termination (FTE) now Self-Employed |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |