T5DCI

Administration of Reduction for Surviving Dependents | #other | Component: Company Pension Scheme Germany

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

Column Name	Description
MANDT FK	Client
HBKRZ FK	Groups for Reduction of Surviving Dependent's Pension
HBTYP FK	Surviving Dependent Type for Company Pension Scheme
HBLOW	Lower Threshold for Surviving Dependent of Same Type
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
MINDR	Minimum Pension
MAXIR	Maximum Pension

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
KZBFO	Start Indicator for Pension Payment	Show values
BPVRT	Testor Draws Pension	Show values
BPVKR	Testator Does Not Draw Pension	Show values
RDRBB	Rounding Rule for Basic Pension Payment for Dependent	Show values
XCERT	Statement for Specific Surviving Dependent Types	Show values

Column Name	Description	Domain name
PRFIX	Fixed Percentage Rate	PRZ32
PRVAR	Variable Percentage Rate	PRZ32
PRMIN	Minimum Percentage Rate	PRZ32
GNAAB	Continuation Periods of Active Payments for Testator	NUMC02
GNADE	Continuation Periods for Testator Pension Payments	NUMC02
FRBIT	Indicator for One-Time/Recurring Payment	INFOTYP
BPVMM	Postponement of Pension Payment	NUM02
RUDIV	Rounding divisor	RUDIV
HGASF_SVFR	Pension with Yield Portion Taxation, Contribution-Free	LGART
HGASP_SVFR	Pension Full Liable to Tax, Contribution-Free	LGART

Master Data Relations \| to Other Relations ↓	Join Conditions
Date Type "Different Start of Surviving Dependent's Pension"	`T5DCI.MANDT == T548Y.MANDT` `T5DCI.DATAR == T548Y.DATAR`
Groups for Reduction of Surviving Dependent's Pension Groups for Reduction of Surviving Dependent's Pension Client ?	`T5DCI.HBKRZ == T5DC7.GRPID` `T5DCI.MANDT == T5DC7.MANDT` `T5DCI.[column in domain "P01C_GRTYP"] == T5DC7.GRTYP`
Surviving Dependent Type for Company Pension Scheme ? Surviving Dependent Type for Company Pension Scheme	`T5DCI.MANDT == T5DCG.MANDT` `T5DCI.[column in domain "P01C_KZTYP"] == T5DCG.KZTYP` `T5DCI.HBTYP == T5DCG.KNZID`
Client	`T5DCI.MANDT == T000.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Wage Type, Difference Amount for Testator Pension Payment ? ? Client Indicator for One-Time/Recurring Payment Wage Type, Difference Amount for Testator Pension Payment	`T5DCI.[column in domain "MOLGA"] == T512Z.MOLGA` `T5DCI.[column in domain "ENDDA"] == T512Z.ENDDA` `T5DCI.MANDT == T512Z.MANDT` `T5DCI.FRBIT == T512Z.INFTY` `T5DCI.FRBLG == T512Z.LGART`
Function - Determine Percentage Rate for Surv. Dep. Reduct. Function - Determine Percentage Rate for Surv. Dep. Reduct. ? Client	`T5DCI.FUHBP == T5DWY.NUMID` `T5DCI.[column in domain "P01C_FKTID"] == T5DWY.FKTID` `T5DCI.MANDT == T5DWY.MANDT`
Pension with Yield Portion Taxable, Liable to Contributions ? ? Client ? Pension with Yield Portion Taxable, Liable to Contributions	`T5DCI.[column in domain "MOLGA"] == T512Z.MOLGA` `T5DCI.[column in domain "ENDDA"] == T512Z.ENDDA` `T5DCI.MANDT == T512Z.MANDT` `T5DCI.[column in domain "INFTY"] == T512Z.INFTY` `T5DCI.HGASF == T512Z.LGART`
Pension Fully Taxable, Liable to Contributions ? ? Client ? Pension Fully Taxable, Liable to Contributions	`T5DCI.[column in domain "MOLGA"] == T512Z.MOLGA` `T5DCI.[column in domain "ENDDA"] == T512Z.ENDDA` `T5DCI.MANDT == T512Z.MANDT` `T5DCI.[column in domain "INFTY"] == T512Z.INFTY` `T5DCI.HGASP == T512Z.LGART`
Resulting Wage Type ? ? Client ? Resulting Wage Type	`T5DCI.[column in domain "MOLGA"] == T512Z.MOLGA` `T5DCI.[column in domain "ENDDA"] == T512Z.ENDDA` `T5DCI.MANDT == T512Z.MANDT` `T5DCI.[column in domain "INFTY"] == T512Z.INFTY` `T5DCI.RLGAR == T512Z.LGART`
Pension Category Pension Category Client	`T5DCI.RNTYP == T5DCE.RNTYP` `T5DCI.MANDT == T5DCE.MANDT`