SAP ABAP Table T5DBF (Construction Industry Leave)
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷
PY-DE-CI (Application Component) Construction Industry
⤷
P01B (Package) Payroll: Construction Industry
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | T5DBF |
|
| Short Description | Construction Industry Leave |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| 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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | T500L | |
| 3 | |
MOURA | MODIF | NUMC | 2 | 0 | Personnel Subarea Grouping for Leave Types | ||
| 4 | |
P01B_TGG01 | TRFGG | CHAR | 2 | 0 | Pay Scale Area Group for Leave in Construction Industry | T5D0T | |
| 5 | |
P01B_BAUTY | P01B_BAUTY | CHAR | 1 | 0 | Employee Subgroup Grouping for Construction Pay | ||
| 6 | |
P01B_BAUTU | P01B_BAUTU | CHAR | 1 | 0 | Employee Subgroup Subgrouping for Construction Ind. Leave | ||
| 7 | |
P01B_URALT | NUM2 | NUMC | 2 | 0 | Minimum Age for Leave Entitlement | ||
| 8 | |
P01B_URBTZ | NUM2 | NUMC | 2 | 0 | Minimum Length of Service for Leave Entitlement | ||
| 9 | |
P01B_BEHGR | P01B_BEHGR | CHAR | 2 | 0 | Challenge Group for Leave Entitlement | ||
| 10 | |
ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
| 11 | |
BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
| 12 | |
P01B_URKAS | P01B_ZVKAS | CHAR | 2 | 0 | Leave Fund for Construction Industry | T5DBA | |
| 13 | |
P01B_ERBTG | XFELD | CHAR | 1 | 0 | Determine Employment Days | ||
| 14 | |
P01B_ERAGL | XFELD | CHAR | 1 | 0 | Determine Adjustment Amounts | ||
| 15 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 16 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 17 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 18 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 19 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 20 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 21 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 22 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 23 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 24 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 25 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 26 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 27 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 28 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 29 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 30 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 31 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 32 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 33 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 34 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 35 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 36 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 37 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 38 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 39 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 40 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 41 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 42 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 43 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 44 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 45 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 46 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 47 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 48 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 49 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 50 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 51 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 52 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 53 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 54 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 55 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 56 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 57 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 58 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 59 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 60 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 61 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 62 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 63 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 64 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 65 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 66 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 67 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 68 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 69 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 70 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 71 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 72 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 73 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 74 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 75 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 76 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 77 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 78 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 79 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 80 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W | |
| 81 | |
P01B_URART | URART | CHAR | 2 | 0 | Leave Type | T533 | |
| 82 | |
P01B_VORLG | XFELD | CHAR | 1 | 0 | Propose Leave Type? | ||
| 83 | |
P01B_UTAGE | URLTG | DEC | 5 | 2 | Leave Entitlement in Days | ||
| 84 | |
P01B_UDIVS | DEC2_4 | DEC | 6 | 4 | Leave Entitlement Divisor | ||
| 85 | |
P01B_GREGL | P01B_GREGL | CHAR | 2 | 0 | Vacation Bonus Rule | ||
| 86 | |
P01B_GPRZS | DEC2_2 | DEC | 4 | 2 | Vacation Bonus Percentage Rate | ||
| 87 | |
P01B_GBTRG | P_99D_WERT3 | CURR | 6 | 2 | Vacation Bonus Amount | ||
| 88 | |
P01B_LGAGD | LGART | CHAR | 4 | 0 | Wage Type Vacation Bonus | T512W | |
| 89 | |
P01B_EGRGL | P01B_EGRGL | CHAR | 2 | 0 | Vacation Pay Rule | ||
| 90 | |
P01B_EGPRZ | DEC2_2 | DEC | 4 | 2 | Percentage Rate for Vacation Pay | ||
| 91 | |
P01B_LGAEG | LGART | CHAR | 4 | 0 | Wage Type for Vacation Pay | T512W |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | T5DBF | ELGA1 | |
|
REF | C | CN |
| 2 | T5DBF | ELGA2 | |
|
REF | C | CN |
| 3 | T5DBF | ELGA3 | |
|
REF | C | CN |
| 4 | T5DBF | ELGA4 | |
|
REF | C | CN |
| 5 | T5DBF | ELGA5 | |
|
REF | C | CN |
| 6 | T5DBF | ELGA6 | |
|
REF | C | CN |
| 7 | T5DBF | ELGA7 | |
|
REF | C | CN |
| 8 | T5DBF | GLGA1 | |
|
REF | C | CN |
| 9 | T5DBF | GLGA2 | |
|
REF | C | CN |
| 10 | T5DBF | GLGA3 | |
|
REF | C | CN |
| 11 | T5DBF | GLGA4 | |
|
REF | C | CN |
| 12 | T5DBF | GLGA5 | |
|
REF | C | CN |
| 13 | T5DBF | GLGA6 | |
|
REF | C | CN |
| 14 | T5DBF | GLGA7 | |
|
REF | C | CN |
| 15 | T5DBF | MANDT | |
|
KEY | 1 | CN |
| 16 | T5DBF | MOLGA | |
|
KEY | 1 | CN |
| 17 | T5DBF | TGG01 | |
|
KEY | 1 | CN |
| 18 | T5DBF | URAR1 | |
|
REF | C | CN |
| 19 | T5DBF | URAR2 | |
|
REF | C | CN |
| 20 | T5DBF | URAR3 | |
|
REF | C | CN |
| 21 | T5DBF | URAR4 | |
|
REF | C | CN |
| 22 | T5DBF | URAR5 | |
|
REF | C | CN |
| 23 | T5DBF | URAR6 | |
|
REF | C | CN |
| 24 | T5DBF | URAR7 | |
|
REF | C | CN |
| 25 | T5DBF | URKAS | |
|
REF | C | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |