T74FL (Benefit miscellaneous plan) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T74FL to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
BAREA
Benefit area
|
BEN_AREA | T5UB3 |
CHAR
|
2 | 0 | |
|
BPLAN
Benefit plan
|
BEN_PLAN | T5UBA |
CHAR
|
4 | 0 | |
|
LEVL1
Benefit miscellaneous plan option
|
BEN_LEVEL1 |
CHAR
|
4 | 0 | ||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||
|
BEGDA
Start Date
|
BEGDA |
DATS
|
8 | 0 | ||
|
BCOST
Benefit Cost Rule Variant
|
BEN_CSTFM | T5UBH |
CHAR
|
4 | 0 | |
|
BCRED
Benefit Credit Rule Variant
|
BEN_CREDIT | T74FJ |
CHAR
|
4 | 0 | |
|
BCOVE
Benefits Coverage Rule Variant
|
BEN_COVFM | T74FB |
CHAR
|
4 | 0 | |
|
INVGR
Benefit Savings Plan Investment Group
|
BEN_INVGR | T5UBO |
CHAR
|
4 | 0 | |
|
EECON
Benefit Employee Contribution Rule Variant
|
BEN_EECON | T74FG |
CHAR
|
4 | 0 | |
|
ERCON
Employer's Benefits Contribution Variant
|
BEN_ERCON | T74FE |
CHAR
|
4 | 0 | |
|
VESTI
Benefit vesting rules for employee contrib. to savings plans
|
BEN_VESTI | T5UBR |
CHAR
|
4 | 0 | |
|
CUNIT
Benefit contribution unit (employee contribution)
|
BEN_CUNIT |
CURR
|
13 | 2 |
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T74FL | BAREA | T74FL | MANDT |
T5UB3
Benefit area
|
MANDT |
| T74FL | BAREA | T74FL | BAREA |
T5UB3
Benefit area
|
BAREA |
| T74FL | BCOST | T74FL | MANDT |
T5UBH
Benefit cost rule variant
|
MANDT |
| T74FL | BCOST | T74FL | BAREA |
T5UBH
Benefit cost rule variant
|
BAREA |
| T74FL | BCOST | T74FL | BPLAN |
T5UBH
Benefit cost rule variant
|
BPLAN |
| T74FL | BCOST | T74FL | BCOST |
T5UBH
Benefit cost rule variant
|
BCOST |
| T74FL | BCOVE | T74FL | MANDT |
T74FB
Benefits Coverage Rule Variant
|
MANDT |
| T74FL | BCOVE | T74FL | BAREA |
T74FB
Benefits Coverage Rule Variant
|
BAREA |
| T74FL | BCOVE | T74FL | BPLAN |
T74FB
Benefits Coverage Rule Variant
|
BPLAN |
| T74FL | BCOVE | T74FL | BCOVE |
T74FB
Benefits Coverage Rule Variant
|
BCOVE |
| T74FL | BCRED | T74FL | BCRED |
T74FJ
Benefit credit rule variant
|
BCRED |
| T74FL | BCRED | T74FL | MANDT |
T74FJ
Benefit credit rule variant
|
MANDT |
| T74FL | BCRED | T74FL | BAREA |
T74FJ
Benefit credit rule variant
|
BAREA |
| T74FL | BCRED | T74FL | BPLAN |
T74FJ
Benefit credit rule variant
|
BPLAN |
| T74FL | BPLAN | * |
T5UBA
Benefit plan
|
ENDDA | |
| T74FL | BPLAN | T74FL | MANDT |
T5UBA
Benefit plan
|
MANDT |
| T74FL | BPLAN | T74FL | BAREA |
T5UBA
Benefit plan
|
BAREA |
| T74FL | BPLAN | T74FL | BPLAN |
T5UBA
Benefit plan
|
BPLAN |
| T74FL | EECON | T74FL | BPLAN |
T74FG
Benefit employee contribution rule variant
|
BPLAN |
| T74FL | EECON | T74FL | EECON |
T74FG
Benefit employee contribution rule variant
|
EECON |
| T74FL | EECON | T74FL | MANDT |
T74FG
Benefit employee contribution rule variant
|
MANDT |
| T74FL | EECON | T74FL | BAREA |
T74FG
Benefit employee contribution rule variant
|
BAREA |
| T74FL | ERCON | T74FL | BAREA |
T74FE
Benefit employer contribution rule variant
|
BAREA |
| T74FL | ERCON | T74FL | BPLAN |
T74FE
Benefit employer contribution rule variant
|
BPLAN |
| T74FL | ERCON | T74FL | ERCON |
T74FE
Benefit employer contribution rule variant
|
ERCON |
| T74FL | ERCON | T74FL | MANDT |
T74FE
Benefit employer contribution rule variant
|
MANDT |
| T74FL | INVGR | T74FL | MANDT |
T5UBO
Benefit investment group
|
MANDT |
| T74FL | INVGR | T74FL | BAREA |
T5UBO
Benefit investment group
|
BAREA |
| T74FL | INVGR | T74FL | INVGR |
T5UBO
Benefit investment group
|
INVGR |
| T74FL | MANDT | T74FL | MANDT |
T000
Clients
|
MANDT |
| T74FL | VESTI | T74FL | VESTI |
T5UBR
Benefit vesting rule
|
VESTI |
| T74FL | VESTI | T74FL | MANDT |
T5UBR
Benefit vesting rule
|
MANDT |
| T74FL | VESTI | T74FL | BAREA |
T5UBR
Benefit vesting rule
|
BAREA |