T5DBF

Construction Industry Leave | #other | Component: Construction Industry

🔑 Keys (10)
💰 Amounts (7)
∑ Quantities
📅 Dates (2)
☰ Categorical (26)
Other (28)
🔗 Relations (25)

Column Name	Description
MANDT FK	Client
MOLGA FK	HCM Localization
MOURA	Personnel Subarea Grouping for Leave Types
TGG01 FK	Pay Scale Area Group for Leave in Construction Industry
BAUTY	Employee Subgroup Grouping for Construction Pay	Show values
BAUTU	Employee Subgroup Subgrouping for Construction Ind. Leave	Show values
URALT	Minimum Age for Leave Entitlement
URBTZ	Minimum Length of Service for Leave Entitlement
BEHGR	Challenge Group for Leave Entitlement	Show values
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
GBTR1	Vacation Bonus Amount
GBTR2	Vacation Bonus Amount
GBTR3	Vacation Bonus Amount
GBTR4	Vacation Bonus Amount
GBTR5	Vacation Bonus Amount
GBTR6	Vacation Bonus Amount
GBTR7	Vacation Bonus Amount

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
BAUTY	Employee Subgroup Grouping for Construction Pay	Show values
BAUTU	Employee Subgroup Subgrouping for Construction Ind. Leave	Show values
BEHGR	Challenge Group for Leave Entitlement	Show values
ERBTG	Determine Employment Days	Show values
ERAGL	Determine Adjustment Amounts	Show values
VORL1	Propose Leave Type?	Show values
GRGL1	Vacation Bonus Rule	Show values
ERGL1	Vacation Pay Rule	Show values
VORL2	Propose Leave Type?	Show values
GRGL2	Vacation Bonus Rule	Show values
ERGL2	Vacation Pay Rule	Show values
VORL3	Propose Leave Type?	Show values
GRGL3	Vacation Bonus Rule	Show values
ERGL3	Vacation Pay Rule	Show values
VORL4	Propose Leave Type?	Show values
GRGL4	Vacation Bonus Rule	Show values
ERGL4	Vacation Pay Rule	Show values
VORL5	Propose Leave Type?	Show values
GRGL5	Vacation Bonus Rule	Show values
ERGL5	Vacation Pay Rule	Show values
VORL6	Propose Leave Type?	Show values
GRGL6	Vacation Bonus Rule	Show values
ERGL6	Vacation Pay Rule	Show values
VORL7	Propose Leave Type?	Show values
GRGL7	Vacation Bonus Rule	Show values
ERGL7	Vacation Pay Rule	Show values

Column Name	Description	Domain name
UTAG1	Leave Entitlement in Days	URLTG
UDIV1	Leave Entitlement Divisor	DEC2_4
GPRZ1	Vacation Bonus Percentage Rate	DEC2_2
EPRZ1	Percentage Rate for Vacation Pay	DEC2_2
UTAG2	Leave Entitlement in Days	URLTG
UDIV2	Leave Entitlement Divisor	DEC2_4
GPRZ2	Vacation Bonus Percentage Rate	DEC2_2
EPRZ2	Percentage Rate for Vacation Pay	DEC2_2
UTAG3	Leave Entitlement in Days	URLTG
UDIV3	Leave Entitlement Divisor	DEC2_4
GPRZ3	Vacation Bonus Percentage Rate	DEC2_2
EPRZ3	Percentage Rate for Vacation Pay	DEC2_2
UTAG4	Leave Entitlement in Days	URLTG
UDIV4	Leave Entitlement Divisor	DEC2_4
GPRZ4	Vacation Bonus Percentage Rate	DEC2_2
EPRZ4	Percentage Rate for Vacation Pay	DEC2_2
UTAG5	Leave Entitlement in Days	URLTG
UDIV5	Leave Entitlement Divisor	DEC2_4
GPRZ5	Vacation Bonus Percentage Rate	DEC2_2
EPRZ5	Percentage Rate for Vacation Pay	DEC2_2
UTAG6	Leave Entitlement in Days	URLTG
UDIV6	Leave Entitlement Divisor	DEC2_4
GPRZ6	Vacation Bonus Percentage Rate	DEC2_2
EPRZ6	Percentage Rate for Vacation Pay	DEC2_2
UTAG7	Leave Entitlement in Days	URLTG
UDIV7	Leave Entitlement Divisor	DEC2_4
GPRZ7	Vacation Bonus Percentage Rate	DEC2_2
EPRZ7	Percentage Rate for Vacation Pay	DEC2_2

Master Data Relations \| to Other Relations ↓	Join Conditions
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA1 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA2 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA3 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA4 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA5 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA6 == T512W.LGART`
Wage Type for Vacation Pay HCM Localization ? Client Wage Type for Vacation Pay	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.ELGA7 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA1 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA2 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA3 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA4 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA5 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA6 == T512W.LGART`
Wage Type Vacation Bonus HCM Localization ? Client Wage Type Vacation Bonus	`T5DBF.MOLGA == T512W.MOLGA` `T5DBF.[column in domain "ENDDA"] == T512W.ENDDA` `T5DBF.MANDT == T512W.MANDT` `T5DBF.GLGA7 == T512W.LGART`
Client	`T5DBF.MANDT == T000.MANDT`
HCM Localization	`T5DBF.MOLGA == T500L.MOLGA`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR1 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR2 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR3 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR4 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR5 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR6 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`
Leave Type Leave Type Client Personnel Subarea Grouping for Leave Types	`T5DBF.URAR7 == T533.URAR` `T5DBF.MANDT == T533.MANDT` `T5DBF.MOURA == T533.URMO`

Other Relations \| to Master Data Relations ↑	Join Conditions
Pay Scale Area Group for Leave in Construction Industry HCM Localization Client ? Pay Scale Area Group for Leave in Construction Industry	`T5DBF.MOLGA == T5D0T.MOLGA` `T5DBF.MANDT == T5D0T.MANDT` `T5DBF.[column in domain "TGGTY"] == T5D0T.TGGTY` `T5DBF.TGG01 == T5D0T.TRFGG`
Leave Fund for Construction Industry Leave Fund for Construction Industry Client ?	`T5DBF.URKAS == T5DBA.ZVKAS` `T5DBF.MANDT == T5DBA.MANDT` `T5DBF.[column in domain "ENDDA"] == T5DBA.ENDDA`