SAP table T5UB1 (Benefit plan type)

SAP table T5UB1 has 3 primary key fields being MANDT,BAREA,PLTYP.

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 T5UB3 BEN_AREA
PLTYP Benefit plan type CHAR 4 0 BEN_TYPE
BPCAT Benefit Plan Category CHAR 1 0 BEN_CATEG
1 Credit plan
A Health plan
B Insurance plan
C Savings plan
D Flexible spending acct
E Miscellaneous plan
F Stock purchase plan
URLPT Benefit URL ID for Information on Plan Type CHAR 4 0 T74HP BEN_URLPT

T5UB1 foreign key relationships

Table Field Check Table Check Field
0 T5UB1 BAREA T5UB3 Benefit area MANDT
0 T5UB1 BAREA T5UB3 Benefit area BAREA