T5UBI

Benefit cost rule | #other | Component: Benefits

🔑 Keys (12)
💰 Amounts (9)
∑ Quantities
📅 Dates (2)
☰ Categorical (7)
Other (3)
🔗 Relations (8)

Column Name	Description
MANDT FK	Client
BAREA FK	Benefit area
BPLAN FK	Benefit plan
BCOST FK	Benefit Cost Rule Variant
SALGR FK	Benefit salary group
AGEGR FK	Benefit age group
LOSGR FK	Benefit seniority group
CSTV1 FK	Benefit cost grouping
GENDR	Benefit gender data for insurance costs calculation	Show values
SMOKE	Benefit smoker indicator
LIMIT	Benefit insurance cost rule variant limit
ENDDA	End Date

Column Name	Description
💲 Benefit Currency Key (T5UD3.CURRE):
INCRE	Benefit base unit for insurance cost calculation
EECST	Benefit Employee Cost Amount
CSTRN	Benefit rounding divisor
ERCST	Benefit Employer Cost/Credit Amount
ERCRN	Benefit rounding divisor
ACCST	Benefit Provider Cost Amount
ACCRN	Benefit rounding divisor
PTCST	Benefits Additional Employee Post-Tax Costs
IMINC	Benefits Imputed Income

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
GENDR	Benefit gender data for insurance costs calculation	Show values
EEFAC	To be deleted - no longer used!	Show values
CSTRL	Benefit rounding rule	Show values
ERFAC	To be deleted - no longer used!	Show values
ERCRL	Benefit rounding rule	Show values
ACFAC	To be deleted - no longer used!	Show values
ACCRL	Benefit rounding rule	Show values

Column Name	Description	Domain name
CSTFA	Benefits Factor for Employee Costs	DEC3_4
ERCFA	Benefit Factor for Employer Credit/Costs	DEC3_4
ACCFA	Benefit Factor for Provider Cost	DEC3_4

Master Data Relations	Join Conditions
Benefit age group Benefit area ? Benefit age group	`T5UBI.MANDT == T5UBL.MANDT` `T5UBI.BAREA == T5UBL.BAREA` `T5UBI.[column in domain "BEN_CRGRP"] == T5UBL.CRGRP` `T5UBI.AGEGR == T5UBL.AGEGR`
Benefit area Benefit area Client	`T5UBI.BAREA == T5UB3.BAREA` `T5UBI.MANDT == T5UB3.MANDT`
Benefit Cost Rule Variant Benefit Cost Rule Variant Benefit plan Client Benefit area	`T5UBI.BCOST == T5UBH.BCOST` `T5UBI.BPLAN == T5UBH.BPLAN` `T5UBI.MANDT == T5UBH.MANDT` `T5UBI.BAREA == T5UBH.BAREA`
Benefit plan Benefit plan Benefit area Client ?	`T5UBI.BPLAN == T5UBA.BPLAN` `T5UBI.BAREA == T5UBA.BAREA` `T5UBI.MANDT == T5UBA.MANDT` `T5UBI.[column in domain "ENDDA"] == T5UBA.ENDDA`
Benefit cost grouping Benefit area Benefit cost grouping Client	`T5UBI.BAREA == T5UB5.BAREA` `T5UBI.CSTV1 == T5UB5.CSTV1` `T5UBI.MANDT == T5UB5.MANDT`
Benefit seniority group Benefit area ? Benefit seniority group	`T5UBI.MANDT == T5UBM.MANDT` `T5UBI.BAREA == T5UBM.BAREA` `T5UBI.[column in domain "BEN_CRGRP"] == T5UBM.CRGRP` `T5UBI.LOSGR == T5UBM.LOSGR`
Client	`T5UBI.MANDT == T000.MANDT`
Benefit salary group Benefit area ? Benefit salary group Client	`T5UBI.BAREA == T5UBK.BAREA` `T5UBI.[column in domain "BEN_CRGRP"] == T5UBK.CRGRP` `T5UBI.SALGR == T5UBK.SALGR` `T5UBI.MANDT == T5UBK.MANDT`