T74FC

Benefits Insurance Coverage Rule | #other | Component: Benefits

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

Column Name	Description
MANDT FK	Client
BAREA FK	Benefit area
BPLAN FK	Benefit plan
BCOVE FK	Benefits Coverage Rule Variant
SALGR FK	Benefit salary group
AGEGR FK	Benefit age group
LOSGR FK	Benefit seniority group
COVGR FK	Benefit insurance coverage grouping
ENDDA	End Date

Column Name	Description
💲 Benefit Currency Key (T5UD3.CURRE):
COVAM	Benefit insurance coverage amount
COVRN	Benefit rounding divisor
MINAM	Benefit minimum insurance coverage amount
MINRN	Benefit rounding divisor
MAXAM	Benefit maximum insurance coverage amount
MAXRN	Benefit rounding divisor
ADDUN	Benefit Unit of Additional Insurance Coverage

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
COVRL	Benefit rounding rule	Show values
MINRL	Benefit rounding rule	Show values
MINGT	Benefit indicator larger amount for minimum	Show values
MAXRL	Benefit rounding rule	Show values
MAXGT	Benefit indicator larger amount for maximum	Show values

Column Name	Description	Domain name
COVFA	Benefit salary factor for insurance coverage	P_DEC3_5
MINFA	Benefit minimum salary factor for insurance coverage	P_DEC3_5
MAXFA	Benefit maximum salary factor for insurance coverage	P_DEC3_5
ADDMI	Benefit Minimum units for additional insurance coverage	DEC9
ADDMA	Benefit Maximum units for additional insurance coverage	DEC9

Master Data Relations	Join Conditions
Benefit age group Benefit area ? Benefit age group	`T74FC.MANDT == T5UBL.MANDT` `T74FC.BAREA == T5UBL.BAREA` `T74FC.[column in domain "BEN_CRGRP"] == T5UBL.CRGRP` `T74FC.AGEGR == T5UBL.AGEGR`
Benefit area Benefit area Client	`T74FC.BAREA == T5UB3.BAREA` `T74FC.MANDT == T5UB3.MANDT`
Benefits Coverage Rule Variant Benefits Coverage Rule Variant Client Benefit area Benefit plan	`T74FC.BCOVE == T74FB.BCOVE` `T74FC.MANDT == T74FB.MANDT` `T74FC.BAREA == T74FB.BAREA` `T74FC.BPLAN == T74FB.BPLAN`
Benefit plan Benefit plan Benefit area Client ?	`T74FC.BPLAN == T5UBA.BPLAN` `T74FC.BAREA == T5UBA.BAREA` `T74FC.MANDT == T5UBA.MANDT` `T74FC.[column in domain "ENDDA"] == T5UBA.ENDDA`
Benefit insurance coverage grouping Benefit insurance coverage grouping Benefit area	`T74FC.MANDT == T74F2.MANDT` `T74FC.COVGR == T74F2.COVGR` `T74FC.BAREA == T74F2.BAREA`
Benefit seniority group Benefit area ? Benefit seniority group	`T74FC.MANDT == T5UBM.MANDT` `T74FC.BAREA == T5UBM.BAREA` `T74FC.[column in domain "BEN_CRGRP"] == T5UBM.CRGRP` `T74FC.LOSGR == T5UBM.LOSGR`
Client	`T74FC.MANDT == T000.MANDT`
Benefit salary group Benefit area ? Benefit salary group Client	`T74FC.BAREA == T5UBK.BAREA` `T74FC.[column in domain "BEN_CRGRP"] == T5UBK.CRGRP` `T74FC.SALGR == T5UBK.SALGR` `T74FC.MANDT == T5UBK.MANDT`