SAP table T5UB3 (Benefit area)
SAP table T5UB3 has 2 primary key fields being MANDT,BAREA.
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 | BEN_AREA | ||
| CURRE | Benefit Currency Key | CUKY | 5 | 0 | TCURC | BEN_CURR | |
| MOLGA | HCM Localization | CHAR | 2 | 0 | T500L | MOLGA | |
| OPIND | Benefit indicator open enrollment is performed | CHAR | 1 | 0 | BEN_OPIND | ||
| OPBEG | Benefit start of open enrollment period | DATS | 8 | 0 | BEN_OPBEG | ||
| OPEND | Benefit end of open enrollment period | DATS | 8 | 0 | BEN_OPEND | ||
| ENBEG | Benefits start of infotype records for open enrollment | DATS | 8 | 0 | BEN_ENBEG | ||
| ENEND | Benefit end of infotype records for open enrollment | DATS | 8 | 0 | BEN_ENEND | ||
| EVEND | Benefit end of infotype records for adj.reas./standard plan | DATS | 8 | 0 | BEN_EVTEND | ||
| FUTNU | Benefit number of years in the future enrollment is possible | DEC | 4 | 0 | BEN_FUTNU | ||
| INDAG | Benefit regular dependent age limit | NUMC | 2 | 0 | BEN_INDAG | ||
| STDAG | Benefit Dependent Age Limit for Students | NUMC | 2 | 0 | BEN_STDAG | ||
| NOMAX | Benefit No Maximum Age for Disability | CHAR | 1 | 0 | BEN_NOMAX | ||
| TERMI | COBRA Indicator Termination of Employment is Relevant | CHAR | 1 | 0 | COB_TERMI | ||
| REDUC | COBRA Indicator Reduction in Working Hours is Relevant | CHAR | 1 | 0 | COB_REDUC | ||
| DEATH | COBRA Indicator Death of Employee is Relevant | CHAR | 1 | 0 | COB_DEATH | ||
| MEDIC | COBRA Indicator Employee Entitlement to Medicare is Relevant | CHAR | 1 | 0 | COB_MEDIC | ||
| DIVOR | COBRA Indicator Divorce is Relevant | CHAR | 1 | 0 | COB_DIVOR | ||
| SEPAR | COBRA Indicator Legal Separation is Relevant | CHAR | 1 | 0 | COB_SEPAR | ||
| LOSSD | COBRA Indicator Child's Loss of Dependent Status is Relevant | CHAR | 1 | 0 | COB_LOSSD | ||
| BANKR | COBRA Indicator Employer's Bankruptcy Is Relevant | CHAR | 1 | 0 | COB_BANKR | ||
| BKRDT | COBRA cutoff date for bankruptcy proceedings | DATS | 8 | 0 | COB_BKRDT | ||
| RESIS | COBRA residence status excluding person from COBRA | CHAR | 1 | 0 | T505U | COB_RESIS | |
| LOCOV | COBRA indicator COBRA starts when coverage is lost | CHAR | 1 | 0 | COB_LOCOV | ||
| CONCO | COBRA Indicator Restrict Offer to Participation Before Event | CHAR | 1 | 0 | COB_CONCO | ||
| POSBA | Benefits Only Offer FSAs with Positive Account Balance | CHAR | 1 | 0 | COB_POSBA | ||
| MOBDE | Grouping of Personnel Subareas for Time Recording | NUMC | 2 | 0 | MOBDE | ||
| CLCHG | Benefit flexible spending account claims can be changed | CHAR | 1 | 0 | BEN_CLCHG | ||
| CLCNF | Benefit agreement can be given to rejection of claims | CHAR | 1 | 0 | BEN_CLCNF | ||
| PSMOP | Benefit Indicator Payroll Sim. Permitted for Open Enrollment | CHAR | 1 | 0 | BEN_PSMOP | ||
| PSMAD | Benefit Ind. Payroll Simulation Allowed for Adjustmt Reason | CHAR | 1 | 0 | BEN_PSMAD | ||
| DRVVR | Benefit variant of payroll driver for payroll simulation | CHAR | 14 | 0 | BEN_DRVVR | ||
| SLPVR | Benefit Variants for Remuneration Statement for Simulation | CHAR | 14 | 0 | BEN_SLPVR | ||
| HERCS | Benefits: Flag to Hide Employer Costs | CHAR | 1 | 0 | BEN_HERCS | ||
| DCNCC | Benefits: Flag to Display Contributions | CHAR | 1 | 0 | BEN_DCNCC | ||
| ESTCN | Benefits: Flag to Estimate Contributions | CHAR | 1 | 0 | BEN_ESTCN | ||
| PSMFO | Benefits: HR Form for Payroll Simulation | CHAR | 16 | 0 | * | BEN_PSMFO | |
| MILIT | Benefits Indicator Military Leave Is Relevant | CHAR | 1 | 0 | COB_MILIT |
T5UB3 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5UB3 | CURRE | TCURC | Currency Codes | MANDT |
| 0 T5UB3 | CURRE | TCURC | Currency Codes | WAERS |
| 1 T5UB3 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| 0 T5UB3 | RESIS | T505U | Residence Status | MANDT |