T5UB3 SAP (Benefit area) Table details
Dictionary Type: Table
Description: Benefit area
Description: Benefit area
Table field list including key, data, relationships and ABAP select examples
T5UB3 is a standard SAP Table which is used to store Benefit area data and is available within R/3 SAP systems depending on the version and release level.
The T5UB3 table consists of various fields, each holding specific information or linking keys about Benefit area data available in SAP. These include BAREA (Benefit area), CURRE (Benefit Currency Key), MOLGA (Country Grouping), OPIND (Benefit indicator open enrollment is performed).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = T5UC3
SAP T5UB3 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BAREA | Benefit area | BEN_AREA | CHAR | 2 | BEN_AREA | BEN | |||
CURRE | Benefit Currency Key | BEN_CURR | CUKY | 5 | TCURC | WAERS | FWS | ||
MOLGA | Country Grouping | MOLGA | CHAR | 2 | T500L | MOLGA | MOL | ||
OPIND | Benefit indicator open enrollment is performed | BEN_OPIND | CHAR | 1 | XFELD | ||||
OPBEG | Benefit start of open enrollment period | BEN_OPBEG | DATS | 8 | DATUM | ||||
OPEND | Benefit end of open enrollment period | BEN_OPEND | DATS | 8 | DATUM | ||||
ENBEG | Benefits start of infotype records for open enrollment | BEN_ENBEG | DATS | 8 | DATUM | ||||
ENEND | Benefit end of infotype records for open enrollment | BEN_ENEND | DATS | 8 | DATUM | ||||
EVEND | Benefit end of infotype records for adj.reas./standard plan | BEN_EVTEND | DATS | 8 | DATUM | ||||
FUTNU | Benefit number of years in the future enrollment is possible | BEN_FUTNU | DEC | 4 | DEC4 | ||||
INDAG | Benefit regular dependent age limit | BEN_INDAG | NUMC | 2 | NUMC2 | ||||
STDAG | Benefit Dependent Age Limit for Students | BEN_STDAG | NUMC | 2 | NUMC2 | ||||
NOMAX | Benefit No Maximum Age for Disability | BEN_NOMAX | CHAR | 1 | XFELD | ||||
TERMI | COBRA Indicator Termination of Employment is Relevant | COB_TERMI | CHAR | 1 | XFELD | ||||
REDUC | COBRA Indicator Reduction in Working Hours is Relevant | COB_REDUC | CHAR | 1 | XFELD | ||||
DEATH | COBRA Indicator Death of Employee is Relevant | COB_DEATH | CHAR | 1 | XFELD | ||||
MEDIC | COBRA Indicator Employee Entitlement to Medicare is Relevant | COB_MEDIC | CHAR | 1 | XFELD | ||||
DIVOR | COBRA Indicator Divorce is Relevant | COB_DIVOR | CHAR | 1 | XFELD | ||||
SEPAR | COBRA Indicator Legal Separation is Relevant | COB_SEPAR | CHAR | 1 | XFELD | ||||
LOSSD | COBRA Indicator Child's Loss of Dependent Status is Relevant | COB_LOSSD | CHAR | 1 | XFELD | ||||
BANKR | COBRA Indicator Employer's Bankruptcy Is Relevant | COB_BANKR | CHAR | 1 | XFELD | ||||
BKRDT | COBRA cutoff date for bankruptcy proceedings | COB_BKRDT | DATS | 8 | DATS | ||||
RESIS | COBRA residence status excluding person from COBRA | COB_RESIS | CHAR | 1 | T505U | RESIS | |||
LOCOV | COBRA indicator COBRA starts when coverage is lost | COB_LOCOV | CHAR | 1 | XFELD | ||||
CONCO | COBRA Indicator Restrict Offer to Participation Before Event | COB_CONCO | CHAR | 1 | XFELD | ||||
POSBA | Benefits Only Offer FSAs with Positive Account Balance | COB_POSBA | CHAR | 1 | XFELD | ||||
MOBDE | Grouping of Personnel Subareas for Time Recording | MOBDE | NUMC | 2 | MOBDE | ||||
CLCHG | Benefit flexible spending account claims can be changed | BEN_CLCHG | CHAR | 1 | XFELD | ||||
CLCNF | Benefit agreement can be given to rejection of claims | BEN_CLCNF | CHAR | 1 | XFELD | ||||
PSMOP | Benefit Indicator Payroll Sim. Permitted for Open Enrollment | BEN_PSMOP | CHAR | 1 | XFELD | ||||
PSMAD | Benefit Ind. Payroll Simulation Allowed for Adjustmt Reason | BEN_PSMAD | CHAR | 1 | XFELD | ||||
DRVVR | Benefit variant of payroll driver for payroll simulation | BEN_DRVVR | CHAR | 14 | RALDB_VARI | ||||
SLPVR | Benefit Variants for Remuneration Statement for Simulation | BEN_SLPVR | CHAR | 14 | RALDB_VARI | ||||
HERCS | Benefits: Flag to Hide Employer Costs | BEN_HERCS | CHAR | 1 | XFELD | ||||
DCNCC | Benefits: Flag to Display Contributions | BEN_DCNCC | CHAR | 1 | XFELD | ||||
ESTCN | Benefits: Flag to Estimate Contributions | BEN_ESTCN | CHAR | 1 | XFELD | ||||
PSMFO | Benefits: HR Form for Payroll Simulation | BEN_PSMFO | CHAR | 16 | Assigned to domain | HRF_NAME_DOM | |||
MILIT | Benefits Indicator Military Leave Is Relevant | COB_MILIT | CHAR | 1 | XFIELD |
Key field | Non-key field |
How do I retrieve data from SAP table T5UB3 using ABAP code
The following ABAP code Example will allow you to do a basic selection on T5UB3 to SELECT all data from the tableDATA: WA_T5UB3 TYPE T5UB3.
SELECT SINGLE *
FROM T5UB3
INTO CORRESPONDING FIELDS OF WA_T5UB3
WHERE...
How to access SAP table T5UB3
Within an ECC or HANA version of SAP you can also view further information about T5UB3 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects