T5UBA

Benefit plan | #masterdata | Component: Benefits

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (32)
Other (17)
🔗 Relations (11)

Column Name	Description
MANDT FK	Client
BAREA FK	Benefit area
BPLAN	Benefit plan
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
COBOK	Benefit indicator COBRA relevance	Show values
IMPUT	Benefit indicator imputed income relevant	Show values
DEFER	Benefits Indicator Qualified Plan	Show values
FLXCR	Benefits Indicator: Credits Can Be Used	Show values
GTLIF	Benefits Determination of Imputed Income (Group Term Life)	Show values
CSTCR	Benefit indicator for plan attribute costs/credits	Show values
ERNOC	Benefit employer costs are not credited to the employee	Show values
L457S	Benefit Indicator Plan is Savings Plan According to §457	Show values
L403B	Benefit indicator plan is relevant for 403(b) limit	Show values
EEOWN	Benefit indicator 403(b) plan belongs to employee	Show values
TPASV	Benefit scope of third party administrator (TPA) service	Show values
EQSCH	Benefit Indic. Ben. Accrual Hours according to Plnd W. Time	Show values
EQPER	Benefit Reference Period for Benefit Accrual Hours	Show values
LNCOD	Benefit insurance line code for IDOC transmission	Show values
SPARQ	Benefit indicator spouse's approval required	Show values
PRDED	Benefit indicator prededuction from employee leaving	Show values
DEPYN	Benefit indicator for relevancy of dependents	Show values
BENYN	Benefit Indicator for Relevancy of Beneficiaries	Show values
EEBYN	Benefit indicator employee's beneficiary status	Show values
CTGYN	Benefit indicator relevancy of contingency beneficiary	Show values
INVYN	Benefit indicator for relevancy of investments	Show values
PREYN	Benefit indicator pre-tax deductions allowed	Show values
PSTYN	Benefit indicator post-tax deductions allowed	Show values
CSTYN	Benefit indicator for cost rule variant relevancy	Show values
CRDYN	Benefit indicator for credit rule variant relevancy	Show values
COVYN	Benefit indicator for coverage rule variant relevancy	Show values
EECYN	Benefit indicator for relevancy of EE contribution	Show values
ERCYN	Benefit indicator for relevancy of ER contribution	Show values
VESYN	Benefit indicator for relevancy of vesting rule	Show values
BONYN	Benefit indicator plan relevant for bonus payments	Show values
ROTHP	Benefits Indicator Roth Plan	Show values
HSAPL	Benefits Indicator HSA Plan	Show values

Column Name	Description	Domain name
PLNNO	Benefit plan number	CHAR20
EQHRS	Benefit Number of Benefit Accrual Hours	PRANZHL
EEWTY	Benefit Wage Type for Pre-Tax Employee Contributions	LGART
PTWTY	Benefit Wage Type for Post-Tax Employee Contributions	LGART
ERWTY	Benefit Wage Type for Employer Contribution	LGART
TBWTY	Benefit wage type for technical calculation base	LGART
BEWTY	Benefit wage type for bonus employee pre-tax amount	LGART
BPWTY	Benefit wage type for employee post-tax bonus contribution	LGART
BRWTY	Benefit wage type for employer bonus contribution	LGART
BTWTY	Benefit Technical Wage Type for Bonus Payment	LGART
PRWTY	Benefit wage type for payments to provider	LGART
BSWTY	Benefit wage type for calculation base	LGART
INWTY	Benefit wage type for investment	LGART
CPWTY	Benefit Wage Type for Storage of Compensation from Model	LGART
IIWTY	Benefits Wage Type for Imputed Income	LGART
COBSR	Relevant for COBRA subsidy	CHAR1
COBCM	COBRA indicator for calendar month plans	CHAR1

Master Data Relations	Join Conditions
Benefit area Benefit area Client	`T5UBA.BAREA == T5UB3.BAREA` `T5UBA.MANDT == T5UB3.MANDT`
Benefit Calendar Type for Length of Service Calculation	`T5UBA.MANDT == T54C2.MANDT` `T5UBA.CMTSV == T54C2.CUMTY`
Benefit Compensation Model for Calculating Earnings Benefit area Benefit Compensation Model for Calculating Earnings Client	`T5UBA.BAREA == T74HM.BAREA` `T5UBA.CPMOD == T74HM.CPMOD` `T5UBA.MANDT == T74HM.MANDT`
Benefit Compensation Model for Calculating Working Hours Benefit area Benefit Compensation Model for Calculating Working Hours Client	`T5UBA.BAREA == T74HM.BAREA` `T5UBA.CPMOH == T74HM.CPMOD` `T5UBA.MANDT == T74HM.MANDT`
Benefit provider Benefit provider ?	`T5UBA.MANDT == T51RH.MANDT` `T5UBA.CRENR == T51RH.CRENR` `T5UBA.[column in domain "CRETY"] == T51RH.CRETY`
Client	`T5UBA.MANDT == T000.MANDT`
Benefit plan status Benefit plan status Client Benefit area	`T5UBA.PLSTA == T5UB2.PLSTA` `T5UBA.MANDT == T5UB2.MANDT` `T5UBA.BAREA == T5UB2.BAREA`
Benefit plan type Benefit area Benefit plan type	`T5UBA.MANDT == T5UB1.MANDT` `T5UBA.BAREA == T5UB1.BAREA` `T5UBA.PLTYP == T5UB1.PLTYP`
To be deleted - no longer used! To be deleted - no longer used! Benefit area Client End Date	`T5UBA.PPLAN == T5UBA.BPLAN` `T5UBA.BAREA == T5UBA.BAREA` `T5UBA.MANDT == T5UBA.MANDT` `T5UBA.ENDDA == T5UBA.ENDDA`
Benefit Dependent/Beneficiary Eligibility Rule Variant Benefit area Benefit Dependent/Beneficiary Eligibility Rule Variant Client	`T5UBA.BAREA == T74HS.BAREA` `T5UBA.RLPVR == T74HS.RLPVR` `T5UBA.MANDT == T74HS.MANDT`
Benefit URL ID for Information on Benefits Plan Benefit URL ID for Information on Benefits Plan Client Benefit area	`T5UBA.URLPL == T74HP.URLID` `T5UBA.MANDT == T74HP.MANDT` `T5UBA.BAREA == T74HP.BAREA`