SAP Table T74FB (Benefits Coverage Rule Variant)

SAP table T74FB has 4 primary key fields being MANDT,BAREA,BPLAN,BCOVE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BAREA Benefit area CHAR 2 0 T5UB3 BEN_AREA
BPLAN Benefit plan CHAR 4 0 T5UBA BEN_PLAN
BCOVE Benefits Coverage Rule Variant CHAR 4 0 BEN_COVFM
AGECI Benefit Indicator Showing Whose Data is Relevant CHAR 1 0 BEN_PSDAT
Employee
D Domestic Partner
X Spouse
COVIN Benefit indicator for insurance coverage grouping CHAR 1 0 BEN_COVIN
SALIN Benefit indicator salary is relevant CHAR 1 0 BEN_SALIN
AGEIN Benefit Age group relevance indicator CHAR 1 0 BEN_AGEIN
LOSIN Benefit indicator seniority is relevant CHAR 1 0 BEN_LOSIN
CRGRP Benefit Parameter Group for Grouping CHAR 4 0 T5UBY BEN_CRGRP
SALMO Benefit cut-off month for salary calculation NUMC 2 0 BEN_SALMO
SALDY Benefit cut-off day for salary calculation NUMC 2 0 BEN_SALDAY
AGEMO Benefit Cutoff month for age group determination NUMC 2 0 BEN_AGEMO
AGEDY Benefit Cut-off day for age group determination NUMC 2 0 BEN_AGEDAY
SRVMO Benefit seniority calculation cut-off month for cost variant NUMC 2 0 BEN_SRVMO
SRVDY Benefit seniority calculation cut-off day for cost variant NUMC 2 0 BEN_SRVDAY
DATTY Date type CHAR 2 0 T548Y DATAR
ENDTY Date type CHAR 2 0 T548Y DATAR
BSALM Benefit cutoff month for salary calculation NUMC 2 0 BEN_BSALM
BSALD Benefit cutoff day for salary calculation NUMC 2 0 BEN_BSALD
PERUL Calculation process for time specifications CHAR 4 0 T525P PERUL

T74FB foreign key relationships

Table Field Check Table Check Field
0 T74FB BAREA T5UB3 Benefit area MANDT
0 T74FB BAREA T5UB3 Benefit area BAREA
1 T74FB BPLAN T5UBA Benefit plan MANDT
1 T74FB BPLAN T5UBA Benefit plan ENDDA
0 T74FB DATTY T548Y Date Types MANDT
0 T74FB DATTY T548Y Date Types DATAR
1 T74FB ENDTY T548Y Date Types MANDT
1 T74FB ENDTY T548Y Date Types DATAR
0 T74FB PERUL T525P Calculation Process for Employment Period Calculation MANDT
0 T74FB PERUL T525P Calculation Process for Employment Period Calculation MOLGA
0 T74FB PERUL T525P Calculation Process for Employment Period Calculation PROCE
0 T74FB PERUL T525P Calculation Process for Employment Period Calculation ENDDA