SAP ABAP Table T5DBR (Construction Industry: Flexible Working Hours Model)

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	T5DBR	Table Relationship Diagram
Short Description	Construction Industry: Flexible Working Hours Model

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MOLGA	☑	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
3	FLMOD	☑	P01B_FLMOD	P01B_FLMOD	CHAR	4	0	Flexible Working Hours Model
4	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	MESTD	☐	P01B_MESTD	ANZHL	DEC	7	2	Minimum Remuneration Hours
7	LAAVO	☐	P01B_LAAVO	LGART	CHAR	4	0	Storage Wage Type: Advance	T512W
8	MBSTD	☐	P01B_MBSTD	ANZHL	DEC	7	2	Maximum Retention Hours
9	STDVE	☐	P01B_STDVE	ANZHL	DEC	7	2	Number of Hours before Retention Amount
10	KNZEB	☐	P01B_KNZEB	P01B_KNZEB	CHAR	1	0	Retention Amount Indicator
11	LAAEB	☐	P01B_LAAEB	LGART	CHAR	4	0	Storage Wage Type: Retention Amount	T512W
12	UMPRZ	☐	P01B_UMPRZ	DEC3_2	DEC	5	2	Rate for Converting Overtime to Retention Amount
13	LAEGK	☐	P01B_LAEGK	LGART	CHAR	4	0	Obsolete: Wage Type for Working Time Account	T512W
14	MXAPE	☐	P01B_MXAPE	ANZHL	DEC	7	2	Obsolete(45B): Maximum Deficit Hours Reduction per Period
15	LADAB	☐	P01B_LADAB	LGART	CHAR	4	0	Wage Type for Working Time Account Adjustment	T512W
16	LAKAM	☐	P01B_LAKAM	LGART	CHAR	4	0	Wage Type for Working Time Account Adjustment, Overtime	T512W
17	REFPS	☐	P01B_REFPS	SCHKN	CHAR	8	0	Reference Work Schedule for Standard Working Time	T508A
18	MMSTD	☐	P01B_MMSTD	ANZHL	DEC	7	2	Maximum Retention Hours per Month
19	VOBTR	☐	P01B_VOBTR	BETRG	CURR	9	2	Constant Advance Amount per Hour
20	EBBTR	☐	P01B_EBBTR	BETRG	CURR	9	2	Constant Retention Amount per Hour
21	WAERS	☐	P01B_FWAER	WAERS	CUKY	5	0	Currency Key for Flexible Working Hours Policy	TCURC
22	MVSTD	☐	P01B_MVSTD	ANZHL	DEC	7	2	Maximum Advance Hours
23	MMVST	☐	P01B_MMVST	ANZHL	DEC	7	2	Maximum Advance Hours per Month
24	MSVMA	☐	P01B_MSVMA	ANZHL	DEC	7	2	Maximum Number of Retained Hours for Overtime Calculation
25	KVORA	☐	P01B_KVORA	P01B_KONST	CHAR	5	0	Constant for Previous Hours Lost Due to Weather Conditions	T5DBK
26	KUVOR	☐	P01B_KUVOR	P01B_KONST	CHAR	5	0	Constant for Leave as Winter Compensation Advance Benefit	T5DBK
27	LAWAE	☐	P01B_LAWAE	LGART	CHAR	4	0	Wage Type for Retention Amount with Winter Comp. Processing	T512W
28	LAWAV	☐	P01B_LAWAV	LGART	CHAR	4	0	Wage Type for Advance with Winter Compensation Processing	T512W
29	LAWAW	☐	P01B_LAWAW	LGART	CHAR	4	0	Storage Wage Type Advance Hours for WC from Working Time Acc	T512W
30	KNZMA	☐	P01B_KNZMA	P01B_MAKNZ	CHAR	1	0	Calculation of Overtime
31	LAMEH	☐	P01B_LAMEH	LGART	CHAR	4	0	Wage Type for Overtime	T512W
32	KNZVO	☐	P01B_KNZVO	P01B_KNZVO	CHAR	1	0	Flag: Advance Payment
33	REFPV	☐	P01B_REFPS	SCHKN	CHAR	8	0	Reference Work Schedule for Standard Working Time	T508A
34	VORKG	☐	P01B_VORKG	XFELD	CHAR	1	0	Number of Advance Hours is Unlimited
35	EINKG	☐	P01B_EINKG	XFELD	CHAR	1	0	Number of Retained Hours is Unlimited
36	RDTYP	☐	P01B_RDTYP_FLEX	RDTYP	CHAR	2	0	Cons. Industry: Rounding Rule for Hours in Working Time Acct	T559R
37	MBSTE	☐	P01B_MBSTE	ANZHL	DEC	7	2	One-Time Retention Limit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5DBR	KUVOR	T5DBK	KONST	REF	1	CN
2	T5DBR	KVORA	T5DBK	KONST	REF	1	CN
3	T5DBR	LAAEB	T512W	LGART	REF	1	CN
4	T5DBR	LAAVO	T512W	LGART	REF	1	CN
5	T5DBR	LADAB	T512W	LGART	REF	1	CN
6	T5DBR	LAEGK	T512W	LGART	REF	1	CN
7	T5DBR	LAKAM	T512W	LGART	REF	C	CN
8	T5DBR	LAMEH	T512W	LGART	REF	1	CN
9	T5DBR	LAWAE	T512W	LGART	REF	1	CN
10	T5DBR	LAWAV	T512W	LGART	REF	1	CN
11	T5DBR	LAWAW	T512W	LGART	REF	1	CN
12	T5DBR	MANDT	T000	MANDT	KEY	1	CN
13	T5DBR	MOLGA	T500L	MOLGA	KEY	1	CN
14	T5DBR	RDTYP	T559R	RDTYP	REF	1	CN
15	T5DBR	REFPS	T508A	SCHKZ	REF	1	CN
16	T5DBR	REFPV	T508A	SCHKZ	REF	C	CN
17	T5DBR	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20041209
SAP Release Created in