T5UBA SAP (Benefit plan) Table details
Dictionary Type: Table
Description: Benefit plan
Description: Benefit plan
Table field list including key, data, relationships and ABAP select examples
T5UBA is a standard SAP Table which is used to store Benefit plan data and is available within R/3 SAP systems depending on the version and release level.
The T5UBA table consists of various fields, each holding specific information or linking keys about Benefit plan data available in SAP. These include BAREA (Benefit area), BPLAN (Benefit plan), ENDDA (End Date), BEGDA (Start Date).. 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 = T5UCA
SAP T5UBA 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 | T5UB3 | BEN_AREA | BEN | ||
BPLAN | Benefit plan | BEN_PLAN | CHAR | 4 | BEN_PLAN | ||||
ENDDA | End Date | ENDDA | DATS | 8 | DATUM | ||||
BEGDA | Start Date | BEGDA | DATS | 8 | DATUM | ||||
PLTYP | Benefit plan type | BEN_TYPE | CHAR | 4 | T5UB1 | BEN_TYPE | |||
CRENR | Benefit provider | BEN_PROV | NUMC | 8 | T51RH | CRENR | |||
PLNNO | Benefit plan number | BEN_PLANNO | CHAR | 20 | CHAR20 | ||||
PLSTA | Benefit plan status | BEN_PLSTAT | CHAR | 2 | T5UB2 | BEN_PLSTAT | |||
RLPVR | Benefit Dependent/Beneficiary Eligibility Rule Variant | BEN_RLPVR | CHAR | 4 | T74HS | BEN_RLPVR | |||
COBOK | Benefit indicator COBRA relevance | BEN_COBRA | CHAR | 1 | XFELD | ||||
IMPUT | Benefit indicator imputed income relevant | BEN_IMPUT | CHAR | 1 | XFELD | ||||
DEFER | Benefits Indicator Qualified Plan | BEN_DEFERR | CHAR | 1 | XFELD | ||||
FLXCR | Benefits Indicator: Credits Can Be Used | BEN_FLXCR | CHAR | 1 | XFELD | ||||
GTLIF | Benefits Determination of Imputed Income (Group Term Life) | BEN_GTLIF | NUMC | 1 | BEN_GTLIF | ||||
CSTCR | Benefit indicator for plan attribute costs/credits | BEN_CSTCR | CHAR | 1 | XFELD | ||||
ERNOC | Benefit employer costs are not credited to the employee | BEN_ERNOC | CHAR | 1 | XFELD | ||||
L457S | Benefit Indicator Plan is Savings Plan According to ยง457 | BEN_L457S | CHAR | 1 | XFELD | ||||
L403B | Benefit indicator plan is relevant for 403(b) limit | BEN_L403B | CHAR | 1 | XFELD | ||||
EEOWN | Benefit indicator 403(b) plan belongs to employee | BEN_EEOWN | CHAR | 1 | XFELD | ||||
TPASV | Benefit scope of third party administrator (TPA) service | BEN_TPASV | CHAR | 1 | BEN_TPASV | ||||
CMTSV | Benefit Calendar Type for Length of Service Calculation | BEN_CMTSV | CHAR | 1 | T54C2 | PBAS_CUMTY | |||
CPMOD | Benefit Compensation Model for Calculating Earnings | BEN_CPMOE | CHAR | 4 | T74HM | BEN_CPMOD | |||
CPMOH | Benefit Compensation Model for Calculating Working Hours | BEN_CPMOH | CHAR | 4 | T74HM | BEN_CPMOD | |||
EQSCH | Benefit Indic. Ben. Accrual Hours according to Plnd W. Time | BEN_EQSCH | CHAR | 1 | XFELD | ||||
EQHRS | Benefit Number of Benefit Accrual Hours | BEN_EQHRS | DEC | 15(2) | PRANZHL | ||||
EQPER | Benefit Reference Period for Benefit Accrual Hours | BEN_EQPER | NUMC | 2 | PFREQ | ||||
LNCOD | Benefit insurance line code for IDOC transmission | BEN_LNCOD | CHAR | 3 | BEN_LNCOD | ||||
SPARQ | Benefit indicator spouse's approval required | BEN_SPARQ | CHAR | 1 | XFELD | ||||
PRDED | Benefit indicator prededuction from employee leaving | BEN_PRDED | CHAR | 1 | XFELD | ||||
DEPYN | Benefit indicator for relevancy of dependents | BEN_DEPYN | CHAR | 1 | XFELD | ||||
BENYN | Benefit Indicator for Relevancy of Beneficiaries | BEN_BENYN | CHAR | 1 | XFELD | ||||
EEBYN | Benefit indicator employee's beneficiary status | BEN_EEBYN | CHAR | 1 | XFELD | ||||
CTGYN | Benefit indicator relevancy of contingency beneficiary | BEN_CTGYN | CHAR | 1 | XFELD | ||||
INVYN | Benefit indicator for relevancy of investments | BEN_INVYN | CHAR | 1 | XFELD | ||||
PREYN | Benefit indicator pre-tax deductions allowed | BEN_PREYN | CHAR | 1 | XFELD | ||||
PSTYN | Benefit indicator post-tax deductions allowed | BEN_PSTYN | CHAR | 1 | XFELD | ||||
CSTYN | Benefit indicator for cost rule variant relevancy | BEN_CSTYN | CHAR | 1 | XFELD | ||||
CRDYN | Benefit indicator for credit rule variant relevancy | BEN_CRDYN | CHAR | 1 | XFELD | ||||
COVYN | Benefit indicator for coverage rule variant relevancy | BEN_COVYN | CHAR | 1 | XFELD | ||||
EECYN | Benefit indicator for relevancy of EE contribution | BEN_EECYN | CHAR | 1 | XFELD | ||||
ERCYN | Benefit indicator for relevancy of ER contribution | BEN_ERCYN | CHAR | 1 | XFELD | ||||
VESYN | Benefit indicator for relevancy of vesting rule | BEN_VESYN | CHAR | 1 | XFELD | ||||
BONYN | Benefit indicator plan relevant for bonus payments | BEN_BONYN | CHAR | 1 | XFELD | ||||
EEWTY | Benefit Wage Type for Pre-Tax Employee Contributions | BEN_EEWTYP | CHAR | 4 | Assigned to domain | LGART | |||
PTWTY | Benefit Wage Type for Post-Tax Employee Contributions | BEN_PTWTYP | CHAR | 4 | Assigned to domain | LGART | |||
ERWTY | Benefit Wage Type for Employer Contribution | BEN_ERWTYP | CHAR | 4 | Assigned to domain | LGART | |||
TBWTY | Benefit wage type for technical calculation base | BEN_TBWTYP | CHAR | 4 | Assigned to domain | LGART | |||
BEWTY | Benefit wage type for bonus employee pre-tax amount | BEN_BEWTYP | CHAR | 4 | Assigned to domain | LGART | |||
BPWTY | Benefit wage type for employee post-tax bonus contribution | BEN_BPWTYP | CHAR | 4 | Assigned to domain | LGART | |||
BRWTY | Benefit wage type for employer bonus contribution | BEN_BRWTYP | CHAR | 4 | Assigned to domain | LGART | |||
BTWTY | Benefit Technical Wage Type for Bonus Payment | BEN_BTWTYP | CHAR | 4 | Assigned to domain | LGART | |||
PRWTY | Benefit wage type for payments to provider | BEN_PRWTYP | CHAR | 4 | Assigned to domain | LGART | |||
BSWTY | Benefit wage type for calculation base | BEN_BSWTYP | CHAR | 4 | Assigned to domain | LGART | |||
INWTY | Benefit wage type for investment | BEN_INWTYP | CHAR | 4 | Assigned to domain | LGART | |||
CPWTY | Benefit Wage Type for Storage of Compensation from Model | BEN_CPWTYP | CHAR | 4 | Assigned to domain | LGART | |||
IIWTY | Benefits Wage Type for Imputed Income | BEN_IIWTY | CHAR | 4 | Assigned to domain | LGART | |||
URLPL | Benefit URL ID for Information on Benefits Plan | BEN_URLPL | CHAR | 4 | T74HP | BEN_URLID | |||
PPLAN | To be deleted - no longer used! | BEN_PPLAN | CHAR | 4 | T5UBA | BEN_PLAN | |||
ROTHP | Benefits Indicator Roth Plan | BEN_ROTHP | CHAR | 1 | XFELD | ||||
HSAPL | Benefits Indicator HSA Plan | BEN_HSAPL | CHAR | 1 | XFELD | ||||
COBSR | Relevant for COBRA subsidy | BEN_COBSR | CHAR | 1 | CHAR1 | ||||
COBCM | COBRA indicator for calendar month plans | BEN_COBCM | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table T5UBA using ABAP code
The following ABAP code Example will allow you to do a basic selection on T5UBA to SELECT all data from the tableDATA: WA_T5UBA TYPE T5UBA.
SELECT SINGLE *
FROM T5UBA
INTO CORRESPONDING FIELDS OF WA_T5UBA
WHERE...
How to access SAP table T5UBA
Within an ECC or HANA version of SAP you can also view further information about T5UBA 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