T5CS1

HR-CH: Control of SI | #other | Component: Switzerland

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (4)
🔗 Relations (44)

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
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
ROUT1	HR-CH: Module for SI calculation	CHAR8
ROUT2	HR-CH: Module for SI calculation	CHAR8
ROUT3	HR-CH: Module for SI calculation	CHAR8
PGMNA	Module Pool Name	MODULPOOL

Master Data Relations	Join Conditions
AHV-free wage for pensioners ? ? Client AHV-free wage for pensioners	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.AHVFREI == T512W.LGART`
HR-CH: AHV Administrative Costs Contribution ? ? Client HR-CH: AHV Administrative Costs Contribution	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.AHV_VERW == T512W.LGART`
Application key for Social insurance Switzerland Application key for Social insurance Switzerland Application key Switzerland	`T5CS1.MANDT == T5CS4.MANDT` `T5CS1.ANWSCHL == T5CS4.ANWSCHL` `T5CS1.ANWSCHLCH == T5CS4.ANWSCHLCH`
Application key Switzerland	`T5CS1.MANDT == T5C3I.MANDT` `T5CS1.ANWSCHLCH == T5C3I.ANWSCHLCH`
HR-CH: Gross up for insurances ? ? Client HR-CH: Gross up for insurances	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.AUFR_KUM == T512W.LGART`
HR-CH: Basis wage type for SI ? ? Client HR-CH: Basis wage type for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.BASIS == T512W.LGART`
HR-CH: Annual basis SI ? ? Client HR-CH: Annual basis SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.BAS_JAHR == T512W.LGART`
Annual Basis SI with Gross up (C2) ? ? Client Annual Basis SI with Gross up (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.BAS_JAHR2 == T512W.LGART`
HR-CH: Contribution rate for employer contribution ? ? Client HR-CH: Contribution rate for employer contribution	`T5CS1.[column in domain "ENDDA"] == T511K.ENDDA` `T5CS1.[column in domain "MOLGA"] == T511K.MOLGA` `T5CS1.MANDT == T511K.MANDT` `T5CS1.BEITR_AG == T511K.KONST`
HR-CH: Employee contribution rate ? ? Client HR-CH: Employee contribution rate	`T5CS1.[column in domain "ENDDA"] == T511K.ENDDA` `T5CS1.[column in domain "MOLGA"] == T511K.MOLGA` `T5CS1.MANDT == T511K.MANDT` `T5CS1.BEITR_AN == T511K.KONST`
HR-CH: Gross pay ? ? Client HR-CH: Gross pay	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.BRUTTO == T512W.LGART`
HR-CH: Period wage not obligatory for SI ? ? Client HR-CH: Period wage not obligatory for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.FREI_PER == T512W.LGART`
HR-CH: Exemption limit for second job ? ? Client HR-CH: Exemption limit for second job	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.FR_AHV_NE == T512W.LGART`
HR-CH: Pensioner Exemption ? ? Client HR-CH: Pensioner Exemption	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.FR_RENT == T512W.LGART`
Foreign Key f. Wage Type w. Monthly Pensioner Exempt. Amount ? ? Client Pensioner Exemption Amount for Monthly Use	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.FR_RENT_MA == T512W.LGART`
HR-CH: Cumulations for SI (CRT) ? ? Client HR-CH: Cumulations for SI (CRT)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.GES_CRT == T512W.LGART`
HR_CH: Annual basis SI without gross up ? ? Client HR_CH: Annual basis SI without gross up	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.GES_JAHR == T512W.LGART`
Annual Basis SI Without Gross up (C2) ? ? Client Annual Basis SI Without Gross up (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.GES_JAHR2 == T512W.LGART`
HR-CH: Annual wage ceiling SI (upper limit) ? ? Client HR-CH: Annual wage ceiling SI (upper limit)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_JAHR == T512W.LGART`
Annual Maximum Wage SI (Upper Limit) (C2) ? ? Client Annual Maximum Wage SI (Upper Limit) (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_JAHR2 == T512W.LGART`
HR-CH: Wage ceiling space for social insurance ? ? Client HR-CH: Wage ceiling space for social insurance	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_LUFT == T512W.LGART`
Maximum Wage Deficit for Social Insurance (C2) ? ? Client Maximum Wage Deficit for Social Insurance (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_LUFT2 == T512W.LGART`
HR-CH: Period wage ceiling SI (Upper limit) ? ? Client HR-CH: Period wage ceiling SI (Upper limit)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_PER == T512W.LGART`
HR-CH: Annual minimum wage for SI ? ? Client HR-CH: Annual minimum wage for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_U_JH == T512W.LGART`
HR-CH: Minimal period wage for SI ? ? Client HR-CH: Minimal period wage for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.HLOHN_U_PE == T512W.LGART`
Client	`T5CS1.MANDT == T000.MANDT`
Payroll unit grouping for SI	`T5CS1.MANDT == T5CSH.MANDT` `T5CS1.MOSV == T5CSH.MOSV`
Cancellation annual net wage types ? ? Client Cancellation annual net wage types	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.NETTO_RESET == T512W.LGART`
HR-CH: Obligatory annual wage for SI ? ? Client HR-CH: Obligatory annual wage for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PFL_JAHR == T512W.LGART`
Liable Annual Wage (with Gross up) for SI (C2) ? ? Client Liable Annual Wage (with Gross up) for SI (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PFL_JAHR2 == T512W.LGART`
HR-CH: Obligatory monthly wage for SI ? ? Client HR-CH: Obligatory monthly wage for SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PFL_PER == T512W.LGART`
Liable Monthly Wage for SI (C2) ? ? Client Liable Monthly Wage for SI (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PFL_PER2 == T512W.LGART`
HR-CH: Employer contribution to SI ? ? Client HR-CH: Employer contribution to SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AG == T512W.LGART`
HR-CH: Employer's Contribution to SI (C2) ? ? Client HR-CH: Employer's Contribution to SI (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AG2 == T512W.LGART`
HR-CH: Employer contribution to SI ? ? Client HR-CH: Employer contribution to SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AG_KUM == T512W.LGART`
HR-CH: Employee contribution to SI ? ? Client HR-CH: Employee contribution to SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AN == T512W.LGART`
HR-CH: Employee's Contribution to SI (C2) ? ? Client HR-CH: Employee's Contribution to SI (C2)	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AN2 == T512W.LGART`
HR-CH: Employee contribution to SI ? ? Client HR-CH: Employee contribution to SI	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.PR_AN_KUM == T512W.LGART`
HR-CH: Effective Pensioner Exemption ? ? Client HR-CH: Effective Pensioner Exemption	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.R_FB_EFF_J == T512W.LGART`
HR-CH: Effective Monthly Pensioner Exemption ? ? Client HR-CH: Effective Monthly Pensioner Exemption	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.R_FB_EFF_P == T512W.LGART`
HR-CH: SI days ? ? Client HR-CH: SI days	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.SVTG == T512W.LGART`
HR-CH: Outgoing wage type ? ? Client HR-CH: Outgoing wage type	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.ZUAB_AB == T512W.LGART`
HR-CH: Basis for calculation of inflows and outflows ? ? Client HR-CH: Basis for calculation of inflows and outflows	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.ZUAB_BAS == T512W.LGART`
HR-CH: wage type for influx ? ? Client HR-CH: wage type for influx	`T5CS1.[column in domain "MOLGA"] == T512W.MOLGA` `T5CS1.[column in domain "ENDDA"] == T512W.ENDDA` `T5CS1.MANDT == T512W.MANDT` `T5CS1.ZUAB_ZU == T512W.LGART`