SAP table T74FD (Benefit Savings Plan)
SAP table T74FD has 4 primary key fields being MANDT,BAREA,BPLAN,ENDDA.
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 | |
ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
INVGR | Benefit Savings Plan Investment Group | CHAR | 4 | 0 | T5UBO | BEN_INVGR | |
VESTI | Benefit vesting rules for employee contrib. to savings plans | CHAR | 4 | 0 | T5UBR | BEN_VESTI | |
ERCON | Employer's Benefits Contribution Variant | CHAR | 4 | 0 | T74FE | BEN_ERCON | |
EECON | Benefit Employee Contribution Rule Variant | CHAR | 4 | 0 | T74FG | BEN_EECON | |
WDRAW | Benefit withdrawals allowed | CHAR | 1 | 0 | BEN_WDRAW | ||
CUNIT | Benefit contribution unit (employee contribution) | CURR | 13 | 2 | BEN_CUNIT | ||
PAPRO | Benefit Calculation Process for Participation Service | CHAR | 4 | 0 | T525P | BEN_PAPRO | |
CRPRO | Benefit Calculation Process for Benefit Accrual Service | CHAR | 4 | 0 | T525P | BEN_CRPRO | |
VEPRO | Benefit Calculation Process for Vesting Service | CHAR | 4 | 0 | T525P | BEN_VEPRO |
T74FD foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T74FD | BAREA | T5UB3 | Benefit area | MANDT |
0 T74FD | BAREA | T5UB3 | Benefit area | BAREA |
1 T74FD | BPLAN | T5UBA | Benefit plan | MANDT |
1 T74FD | BPLAN | T5UBA | Benefit plan | ENDDA |
0 T74FD | CRPRO | T525P | Calculation Process for Employment Period Calculation | MANDT |
0 T74FD | CRPRO | T525P | Calculation Process for Employment Period Calculation | MOLGA |
0 T74FD | CRPRO | T525P | Calculation Process for Employment Period Calculation | PROCE |
0 T74FD | CRPRO | T525P | Calculation Process for Employment Period Calculation | ENDDA |
1 T74FD | EECON | T74FG | Benefit employee contribution rule variant | BPLAN |
0 T74FD | ERCON | T74FE | Benefit employer contribution rule variant | BPLAN |
1 T74FD | PAPRO | T525P | Calculation Process for Employment Period Calculation | MANDT |
1 T74FD | PAPRO | T525P | Calculation Process for Employment Period Calculation | MOLGA |
1 T74FD | PAPRO | T525P | Calculation Process for Employment Period Calculation | PROCE |
1 T74FD | PAPRO | T525P | Calculation Process for Employment Period Calculation | ENDDA |
0 T74FD | VEPRO | T525P | Calculation Process for Employment Period Calculation | MANDT |
0 T74FD | VEPRO | T525P | Calculation Process for Employment Period Calculation | MOLGA |
0 T74FD | VEPRO | T525P | Calculation Process for Employment Period Calculation | PROCE |
0 T74FD | VEPRO | T525P | Calculation Process for Employment Period Calculation | ENDDA |