T5CS1_CE

HR-CH CE: Maximum Wage, Exemptions Distribution Mechanisms | #other | Component: Switzerland

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other
🔗 Relations (12)

Column Name	Description
MANDT FK	Client
ANWSCHLCH FK	Application key Switzerland
ANWSCHL FK	Application key for Social insurance Switzerland
MOSV FK	Payroll unit grouping for SI
DIST_NUM	Sequence Number of the Distribution
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Application Key for Social Insurance Switzerland Application key for Social insurance Switzerland Application key Switzerland	`T5CS1_CE.MANDT == T5CS4.MANDT` `T5CS1_CE.ANWSCHL == T5CS4.ANWSCHL` `T5CS1_CE.ANWSCHLCH == T5CS4.ANWSCHLCH`
Application key CH	`T5CS1_CE.MANDT == T5C3I.MANDT` `T5CS1_CE.ANWSCHLCH == T5C3I.ANWSCHLCH`
Determination of Maximum Wage at Person level ? ? Client Determination of Maximum Wage at Person level	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.CALC_PERS_LOHN == T512W.LGART`
Wage Type ? ? Client Determination (Max. Wage) Threshold Deficit on Person Level	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.CALC_PERS_LUFT == T512W.LGART`
Distributed Remaining Maximum Wage of Person ? ? Client Distributed Remaining Maximum Wage of Person	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.DIST_REST_LOHN == T512W.LGART`
Wage Type ? ? Client Distributed Remaining Threshold Deficit Max Wage Per Person	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.DIST_REST_LUFT == T512W.LGART`
Grouping Reason	`T5CS1_CE.GPRSN == T7CCE_GPREASON.GPRSN`
Client	`T5CS1_CE.MANDT == T000.MANDT`
Payroll unit grouping for SI	`T5CS1_CE.MANDT == T5CSH.MANDT` `T5CS1_CE.MOSV == T5CSH.MOSV`
Wage Type ? ? Client Original Annual Max. Wage / Exemption	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.ORIG_LOHN_JAHR == T512W.LGART`
Wage Type ? ? Client Original Month Maximum Wage / Exemption	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.ORIG_LOHN_PER == T512W.LGART`
Original Maximum Wage Deficit ? ? Client Original Maximum Wage Deficit	`T5CS1_CE.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1_CE.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1_CE.MANDT == T512W.MANDT` `T5CS1_CE.ORIG_LUFT == T512W.LGART`