SAP Table T5DBR
Construction Industry: Flexible Working Hours Model
T5DBR (Construction Industry: Flexible Working Hours Model) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5DBR to other SAP tables.
T5DBR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||||||||||||||
| FLMOD | Flexible Working Hours Model | P01B_FLMOD | CHAR | 4 | 0 | |||||||||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||||||||
| MESTD | Minimum Remuneration Hours | P01B_MESTD | DEC | 7 | 2 | |||||||||||||||
| LAAVO | Storage Wage Type: Advance | P01B_LAAVO | T512W | CHAR | 4 | 0 | ||||||||||||||
| MBSTD | Maximum Retention Hours | P01B_MBSTD | DEC | 7 | 2 | |||||||||||||||
| STDVE | Number of Hours before Retention Amount | P01B_STDVE | DEC | 7 | 2 | |||||||||||||||
| KNZEB | Retention Amount Indicator | P01B_KNZEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LAAEB | Storage Wage Type: Retention Amount | P01B_LAAEB | T512W | CHAR | 4 | 0 | ||||||||||||||
| UMPRZ | Rate for Converting Overtime to Retention Amount | P01B_UMPRZ | DEC | 5 | 2 | |||||||||||||||
| LAEGK | Obsolete: Wage Type for Working Time Account | P01B_LAEGK | T512W | CHAR | 4 | 0 | ||||||||||||||
| MXAPE | Obsolete(45B): Maximum Deficit Hours Reduction per Period | P01B_MXAPE | DEC | 7 | 2 | |||||||||||||||
| LADAB | Wage Type for Working Time Account Adjustment | P01B_LADAB | T512W | CHAR | 4 | 0 | ||||||||||||||
| LAKAM | Wage Type for Working Time Account Adjustment, Overtime | P01B_LAKAM | T512W | CHAR | 4 | 0 | ||||||||||||||
| REFPS | Reference Work Schedule for Standard Working Time | P01B_REFPS | T508A | CHAR | 8 | 0 | ||||||||||||||
| MMSTD | Maximum Retention Hours per Month | P01B_MMSTD | DEC | 7 | 2 | |||||||||||||||
| VOBTR | Constant Advance Amount per Hour | P01B_VOBTR | CURR | 9 | 2 | |||||||||||||||
| EBBTR | Constant Retention Amount per Hour | P01B_EBBTR | CURR | 9 | 2 | |||||||||||||||
| WAERS | Currency Key for Flexible Working Hours Policy | P01B_FWAER | TCURC | CUKY | 5 | 0 | ||||||||||||||
| MVSTD | Maximum Advance Hours | P01B_MVSTD | DEC | 7 | 2 | |||||||||||||||
| MMVST | Maximum Advance Hours per Month | P01B_MMVST | DEC | 7 | 2 | |||||||||||||||
| MSVMA | Maximum Number of Retained Hours for Overtime Calculation | P01B_MSVMA | DEC | 7 | 2 | |||||||||||||||
| KVORA | Constant for Previous Hours Lost Due to Weather Conditions | P01B_KVORA | T5DBK | CHAR | 5 | 0 | ||||||||||||||
| KUVOR | Constant for Leave as Winter Compensation Advance Benefit | P01B_KUVOR | T5DBK | CHAR | 5 | 0 | ||||||||||||||
| LAWAE | Wage Type for Retention Amount with Winter Comp. Processing | P01B_LAWAE | T512W | CHAR | 4 | 0 | ||||||||||||||
| LAWAV | Wage Type for Advance with Winter Compensation Processing | P01B_LAWAV | T512W | CHAR | 4 | 0 | ||||||||||||||
| LAWAW | Storage Wage Type Advance Hours for WC from Working Time Acc | P01B_LAWAW | T512W | CHAR | 4 | 0 | ||||||||||||||
| KNZMA | Calculation of Overtime | P01B_KNZMA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LAMEH | Wage Type for Overtime | P01B_LAMEH | T512W | CHAR | 4 | 0 | ||||||||||||||
| KNZVO | Flag: Advance Payment | P01B_KNZVO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| REFPV | Reference Work Schedule for Standard Working Time | P01B_REFPS | T508A | CHAR | 8 | 0 | ||||||||||||||
| VORKG | Number of Advance Hours is Unlimited | P01B_VORKG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EINKG | Number of Retained Hours is Unlimited | P01B_EINKG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| RDTYP | Cons. Industry: Rounding Rule for Hours in Working Time Acct | P01B_RDTYP_FLEX | T559R | CHAR | 2 | 0 | ||||||||||||||
| MBSTE | One-Time Retention Limit | P01B_MBSTE | DEC | 7 | 2 | |||||||||||||||
T5DBR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5DBR | KUVOR | T5DBR | MANDT | T5DBK | Construction Pay Constants | MANDT |
| T5DBR | KUVOR | T5DBR | KUVOR | T5DBK | Construction Pay Constants | KONST |
| T5DBR | KUVOR | * | T5DBK | Construction Pay Constants | ENDDA | |
| T5DBR | KVORA | * | T5DBK | Construction Pay Constants | ENDDA | |
| T5DBR | KVORA | T5DBR | MANDT | T5DBK | Construction Pay Constants | MANDT |
| T5DBR | KVORA | T5DBR | KVORA | T5DBK | Construction Pay Constants | KONST |
| T5DBR | LAAEB | T5DBR | LAAEB | T512W | Wage Type Valuation | LGART |
| T5DBR | LAAEB | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAAEB | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAAEB | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAAVO | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAAVO | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAAVO | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAAVO | T5DBR | LAAVO | T512W | Wage Type Valuation | LGART |
| T5DBR | LADAB | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LADAB | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LADAB | T5DBR | LADAB | T512W | Wage Type Valuation | LGART |
| T5DBR | LADAB | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAEGK | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAEGK | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAEGK | T5DBR | LAEGK | T512W | Wage Type Valuation | LGART |
| T5DBR | LAEGK | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAKAM | T5DBR | LAKAM | T512W | Wage Type Valuation | LGART |
| T5DBR | LAKAM | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAKAM | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAKAM | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAMEH | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAMEH | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAMEH | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAMEH | T5DBR | LAMEH | T512W | Wage Type Valuation | LGART |
| T5DBR | LAWAE | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAWAE | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAWAE | T5DBR | LAWAE | T512W | Wage Type Valuation | LGART |
| T5DBR | LAWAE | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAWAV | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAWAV | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | LAWAV | T5DBR | LAWAV | T512W | Wage Type Valuation | LGART |
| T5DBR | LAWAV | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAWAW | T5DBR | LAWAW | T512W | Wage Type Valuation | LGART |
| T5DBR | LAWAW | * | T512W | Wage Type Valuation | ENDDA | |
| T5DBR | LAWAW | T5DBR | MANDT | T512W | Wage Type Valuation | MANDT |
| T5DBR | LAWAW | T5DBR | MOLGA | T512W | Wage Type Valuation | MOLGA |
| T5DBR | MANDT | T5DBR | MANDT | T000 | Clients | MANDT |
| T5DBR | MOLGA | T5DBR | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| T5DBR | RDTYP | T5DBR | MANDT | T559R | Rounding Rules | MANDT |
| T5DBR | RDTYP | T5DBR | RDTYP | T559R | Rounding Rules | RDTYP |
| T5DBR | RDTYP | * | T559R | Rounding Rules | RDTNR | |
| T5DBR | REFPS | * | T508A | Work Schedule Rules | MOSID | |
| T5DBR | REFPS | T5DBR | REFPS | T508A | Work Schedule Rules | SCHKZ |
| T5DBR | REFPS | * | T508A | Work Schedule Rules | ENDDA | |
| T5DBR | REFPS | T5DBR | MANDT | T508A | Work Schedule Rules | MANDT |
| T5DBR | REFPS | * | T508A | Work Schedule Rules | ZEITY | |
| T5DBR | REFPS | * | T508A | Work Schedule Rules | MOFID | |
| T5DBR | REFPV | * | T508A | Work Schedule Rules | MOFID | |
| T5DBR | REFPV | * | T508A | Work Schedule Rules | MOSID | |
| T5DBR | REFPV | T5DBR | REFPV | T508A | Work Schedule Rules | SCHKZ |
| T5DBR | REFPV | * | T508A | Work Schedule Rules | ENDDA | |
| T5DBR | REFPV | T5DBR | MANDT | T508A | Work Schedule Rules | MANDT |
| T5DBR | REFPV | * | T508A | Work Schedule Rules | ZEITY | |
| T5DBR | WAERS | T5DBR | MANDT | TCURC | Currency Codes | MANDT |
| T5DBR | WAERS | T5DBR | WAERS | TCURC | Currency Codes | WAERS |
