T5DCM

Calculation Method for Calculated/Actual Contributions | #other | Component: Company Pension Scheme Germany

🔑 Keys (5)
💰 Amounts (2)
∑ Quantities
📅 Dates (2)
☰ Categorical (20)
Other (8)
🔗 Relations (30)

Column Name	Description
MANDT FK	Client
ANTYP	Entitlement Type (Entitlement/Benefit Type)	Show values
ANSPR FK	Entitlement to Company Retirement Pension Plan
MODBV FK	Calculation Variant for Entitlement
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
BEIMI	Minimum Contribution
BEIMA	Maximum Contribution

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
ANTYP	Entitlement Type (Entitlement/Benefit Type)	Show values
KZVFK	Constant Period-Specific Annuitization Factor	Show values
VRFKZ	Indicator for Annuitization Factor	Show values
SPBAS	Split Income for Contribution Calculation	Show values
RDBAS	Rounding Rule for Basis	Show values
RDBEI	Rounding Rule for Contribution	Show values
LEANA	Contribution Retention	Show values
LFANA	Contribution Retention	Show values
BEGMM	Starting Month of Interval for Consideration of Basis	Show values
BBZRM	Period for Calculation of Contributions	Show values
KZATM	Indicator for Number of Days per Month	Show values
KZJIN	Annual Interval ID	Show values
BEGMO	Starting Month for Time Interval	Show values
DIRAB	Indicator for Direct Deduction of Input Wage Type	Show values
KNZST	Flag: Split Annuitization of ER and EE Contributions	Show values
BEKAN	Taxation of Employee Contribution	Show values
BEGAG	Taxation of Employer Contribution	Show values
PLART	Employer Percentage Rate of Benefit Type	Show values
NVAEG	New Contract under German Pension Tax Law	Show values
FP100	Entitlement Eligible for Subsidies Sec. EStG	Show values

Column Name	Description	Domain name
AGKON	Constant Employer Percentage Rate	P01C_KONST
ANKON	Constant Employee Percentage Rate	P01C_KONST
RDVBA	Rounding divisor	RUDIV
BASHK	Symbolic Upper Income Threshold	P01C_KONSY
RDVBE	Rounding divisor	RUDIV
ANZMM	Number of Interval Months for Consideration of Basis	NUM03
IDBAZ	Indentification for Basic Increase Calculation	P01C_IDBAS
ANZJA	Number of Years for Time Interval	NUM2

Master Data Relations \| to Other Relations ↓	Join Conditions
Entitlement to Company Retirement Pension Plan Entitlement Type (Entitlement/Benefit Type) Entitlement to Company Retirement Pension Plan Client	`T5DCM.ANTYP == T5DCA.ANTYP` `T5DCM.ANSPR == T5DCA.ANSPR` `T5DCM.MANDT == T5DCA.MANDT`
Contribution Rule for Payroll ? Contribution Rule for Payroll	`T5DCM.MANDT == T5DCS.MANDT` `T5DCM.[column in domain "SEQNO"] == T5DCS.SEQNO` `T5DCM.IDBEA == T5DCS.IDBEI`
Rules for Calculating Contributions ? Rules for Calculating Contributions	`T5DCM.MANDT == T5DCS.MANDT` `T5DCM.[column in domain "SEQNO"] == T5DCS.SEQNO` `T5DCM.IDBEI == T5DCS.IDBEI`
Annuitization Rules Annuitization Rules ? ? Client ? ?	`T5DCM.IDVER == T5DWOG.IDVER` `T5DCM.[column in domain "P01C_VRGSL"] == T5DWOG.VRGSL` `T5DCM.[column in domain "ENDDA"] == T5DWOG.ENDDA` `T5DCM.MANDT == T5DWOG.MANDT` `T5DCM.[column in domain "P01C_GBJHR"] == T5DWOG.GBJHR` `T5DCM.[column in domain "P01C_VRALT"] == T5DWOG.VRALT`
Profit Sharing ? Client Profit Sharing ?	`T5DCM.[column in domain "P01C_KOTYP"] == T5DC1.KOTYP` `T5DCM.MANDT == T5DC1.MANDT` `T5DCM.KGPRZ == T5DC1.KONST` `T5DCM.[column in domain "ENDDA"] == T5DC1.ENDDA`
Employer Contribution Wage Type ? ? Client Employer Contribution Wage Type	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGAAG == T512W.LGART`
Employee Contribution Wage Type ? ? Client Employee Contribution Wage Type	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGAAN == T512W.LGART`
Deduction Wage Type for Tax-Exempt Conversion ? ? Client Deduction Wage Type for Tax-Exempt Conversion	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGABP == T512W.LGART`
Deduction Wage Type for Tax-Exempt Conversion ? ? Client Deduction Wage Type for Tax-Exempt Conversion	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGABS == T512W.LGART`
Wage Type for Entitlement Days ? ? Client Wage Type for Entitlement Days	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGATG == T512W.LGART`
Contribution Deduction Wage Type ? ? Client Contribution Deduction Wage Type	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGBAB == T512W.LGART`
Wage Type for Cumulated Employer Share ? ? Client Wage Type for Cumulated Employer Share	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGCAG == T512W.LGART`
Wage Type for Cumulated Employee Share ? ? Client Wage Type for Cumulated Employee Share	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGCAN == T512W.LGART`
Wage Type for Cumulated Entitlement Days ? ? Client Wage Type for Cumulated Entitlement Days	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGCAT == T512W.LGART`
Wage Type for Upper Limit for Deferred Compensation ? ? Client Wage Type for Upper Limit for Deferred Compensation	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGDEK == T512W.LGART`
Wage Type for Contribution Deduction for One-Time Payment ? ? Client Wage Type for Contribution Deduction for One-Time Payment	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGEIN == T512W.LGART`
Wage Type for Notional Employer Share ? ? Client Wage Type for Notional Employer Share	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGFAG == T512W.LGART`
Wage Type for Notional Employee Share ? ? Client Wage Type for Notional Employee Share	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGFAN == T512W.LGART`
Wage Type: Contract Total for Salary Waiver ? ? Client Wage Type: Contract Total for Salary Waiver	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGGEV == T512W.LGART`
Correction Wage Type for Employee Contribution ? ? Client Correction Wage Type for Employee Contribution	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGKAN == T512W.LGART`
Wage Type for Contribution Deduction for Regular Pay ? ? Client Wage Type for Contribution Deduction for Regular Pay	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LGLFD == T512W.LGART`
Correction Wage Type Notional Contribution Employee ? ? Client Correction Wage Type Notional Contribution Employee	`T5DCM.[column in domain "MOLGA"] == T512W.MOLGA` `T5DCM.[column in domain "ENDDA"] == T512W.ENDDA` `T5DCM.MANDT == T512W.MANDT` `T5DCM.LKFAN == T512W.LGART`
Client	`T5DCM.MANDT == T000.MANDT`
Calculation Variant for Entitlement Entitlement to Company Retirement Pension Plan Calculation Variant for Entitlement Entitlement Type (Entitlement/Benefit Type)	`T5DCM.MANDT == T5DWE.MANDT` `T5DCM.ANSPR == T5DWE.ANSPR` `T5DCM.MODBV == T5DWE.MODBV` `T5DCM.ANTYP == T5DWE.ANTYP`
Employer Annuitization Factor ? Client Employer Annuitization Factor ?	`T5DCM.[column in domain "P01C_KOTYP"] == T5DC1.KOTYP` `T5DCM.MANDT == T5DC1.MANDT` `T5DCM.VRFAG == T5DC1.KONST` `T5DCM.[column in domain "ENDDA"] == T5DC1.ENDDA`
Employee Annuitization Factor ? Client Employee Annuitization Factor ?	`T5DCM.[column in domain "P01C_KOTYP"] == T5DC1.KOTYP` `T5DCM.MANDT == T5DC1.MANDT` `T5DCM.VRFAN == T5DC1.KONST` `T5DCM.[column in domain "ENDDA"] == T5DC1.ENDDA`
Annuitization Factor Constant ? Client Annuitization Factor Constant ?	`T5DCM.[column in domain "P01C_KOTYP"] == T5DC1.KOTYP` `T5DCM.MANDT == T5DC1.MANDT` `T5DCM.VRFKO == T5DC1.KONST` `T5DCM.[column in domain "ENDDA"] == T5DC1.ENDDA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Determination of Age Factor Determination of Age Factor ? Client	`T5DCM.FKFAK == T5DWY.NUMID` `T5DCM.[column in domain "P01C_FKTID"] == T5DWY.FKTID` `T5DCM.MANDT == T5DWY.MANDT`
Annuitization Factor Function Annuitization Factor Function ? Client	`T5DCM.FUVRT == T5DWY.NUMID` `T5DCM.[column in domain "P01C_FKTID"] == T5DWY.FKTID` `T5DCM.MANDT == T5DWY.MANDT`
Indicator for Pensionable Income for Payroll Accounting Indicator for Pensionable Income for Payroll Accounting ? Client	`T5DCM.IDBAA == T5DWM.IDBAA` `T5DCM.[column in domain "ENDDA"] == T5DWM.ENDDA` `T5DCM.MANDT == T5DWM.MANDT`