SAP ABAP Table Q5UB0 (Benefit screen rields for view maintenance)
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PA-BN (Application Component) Benefits
⤷ PBEN (Package) Benefits
⤷ PA-BN (Application Component) Benefits
⤷ PBEN (Package) Benefits
Basic Data
Table Category | INTTAB | Structure |
Structure | Q5UB0 | Table Relationship Diagram |
Short Description | Benefit screen rields for view maintenance |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CURR1 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
2 | CURR2 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
3 | CURR3 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
4 | CURR4 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
5 | CURR5 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
6 | CURR6 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
7 | CURR7 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
8 | CURR8 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
9 | CURR9 | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
10 | CURRA | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
11 | CURRB | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
12 | CURRC | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
13 | WAIYR | BEN_ENYEAR | CHAR1 | CHAR | 1 | 0 | Benefit waiting period year | ||
14 | WAIQU | BEN_ENQUAR | CHAR1 | CHAR | 1 | 0 | Benefit waiting period quarter | ||
15 | WAIMO | BEN_ENMON | CHAR1 | CHAR | 1 | 0 | Benefit waiting period month | ||
16 | WAIPD | BEN_ENPAYP | CHAR1 | CHAR | 1 | 0 | Benefit waiting period pay period | ||
17 | WAINW | BEN_ENNOW | CHAR1 | CHAR | 1 | 0 | Benefit waiting period immediately | ||
18 | TRMYR | BEN_TERMYR | CHAR1 | CHAR | 1 | 0 | Benefit termination rule - year | ||
19 | TRMQU | BEN_TERMQU | CHAR1 | CHAR | 1 | 0 | Benefit termination rule - quarter | ||
20 | TRMMO | BEN_TERMMO | CHAR1 | CHAR | 1 | 0 | Benefit termination rule - month | ||
21 | TRMPD | BEN_TERMPD | CHAR1 | CHAR | 1 | 0 | Benefit termination rule - pay period | ||
22 | TRMNW | BEN_TERMNW | CHAR1 | CHAR | 1 | 0 | Benefit termination rule - immediately | ||
23 | PLYRD | BEN_CPLYRD | BEN_CDAY | CHAR | 2 | 0 | Benefit day of plan year begin flexible spending account | ||
24 | PLYRM | BEN_CPLYRM | BEN_CMONTH | CHAR | 2 | 0 | Benefit month of plan year begin flexible spending account | ||
25 | GRCDA | BEN_CGRCDA | BEN_CDAY | CHAR | 2 | 0 | Benefit end of grace period: day | ||
26 | GRCMO | BEN_CGRCMO | BEN_CMONTH | CHAR | 2 | 0 | Benefit end of grace period: Month | ||
27 | SALDY | BEN_CSALDY | BEN_CDAY | CHAR | 2 | 0 | Benefit cutoff day for salary group determination | ||
28 | SALMO | BEN_CSALMO | BEN_CMONTH | CHAR | 2 | 0 | Benefit cutoff month for salary group determination | ||
29 | AGEDY | BEN_CAGEDY | BEN_CDAY | CHAR | 2 | 0 | Benefit cutoff day for age group determination | ||
30 | AGEMO | BEN_CAGEMO | BEN_CMONTH | CHAR | 2 | 0 | Benefit cutoff month for age group determination | ||
31 | SRVDY | BEN_CSRVDY | BEN_CDAY | CHAR | 2 | 0 | Benefit cutoff day for seniority group determination | ||
32 | SRVMO | BEN_CSRVMO | BEN_CMONTH | CHAR | 2 | 0 | Benefit cutoff month for seniority group determination | ||
33 | BSALD | BEN_CBSALD | BEN_CDAY | CHAR | 2 | 0 | Benefit cutoff day for salary calculation | ||
34 | BSALM | BEN_CBSALM | BEN_CMONTH | CHAR | 2 | 0 | Benefit cutoff month for salary calculation | ||
35 | PAYDA | COB_CPAYDA | BEN_CDAY | CHAR | 2 | 0 | COBRA due date for monthly payments | ||
36 | CNPCI | BEN_CNPCI | XFELD | CHAR | 1 | 0 | Benefit indicator employer contribution percentage | ||
37 | LMPCI | BEN_LMPCI | XFELD | CHAR | 1 | 0 | Benefit contribution limit percentage indicator | ||
38 | CNECA | BEN_CNECA | XFELD | CHAR | 1 | 0 | Benefit indicator ER contribtion is a factor of EE contr. | ||
39 | LMECA | BEN_LMECA | XFELD | CHAR | 1 | 0 | Benefit indicator limit is factor of EE contribution | ||
40 | GESC1 | GESC1 | CHAR1 | CHAR | 1 | 0 | Gender key | ||
41 | GESC2 | GESC2 | CHAR1 | CHAR | 1 | 0 | Gender key | ||
42 | NOREL | BEN_NOTREL | XFELD | CHAR | 1 | 0 | Benefit indicator gender not relevant for cost rule variant | ||
43 | MINLS | BEN_MINLS | XFELD | CHAR | 1 | 0 | Benefit indicator smaller amount for minimum | ||
44 | MAXLS | BEN_MAXLS | XFELD | CHAR | 1 | 0 | Benefit indicator smaller amount for maximum | ||
45 | ANYPL | BEN_ANYPL | XFELD | CHAR | 1 | 0 | Benefit Indicator prerequisite any plan | ||
46 | ALLPL | BEN_ALLPL | XFELD | CHAR | 1 | 0 | Benefit Indicator prerequisite every plan | ||
47 | GPENR | BEN_GPENR | XFELD | CHAR | 1 | 0 | Benefit indicator grace period starts on enrollment date | ||
48 | GPPRT | BEN_GPPRT | XFELD | CHAR | 1 | 0 | Benefit indicator grace period starts on participation date | ||
49 | AUTOM | BEN_AUTOM | XFELD | CHAR | 1 | 0 | Benefit indicator for automatic plan | ||
50 | INTRM | BEN_INTRM | XFELD | CHAR | 1 | 0 | Benefit indicator for default plan | ||
51 | REIND | BEN_REIND | XFELD | CHAR | 1 | 0 | Benefit reimbursement indicator | ||
52 | CONTR | BEN_CONTR | XFELD | CHAR | 1 | 0 | Benefit indicator for plan attribute contributions | ||
53 | BNAME | COB_BNAME | TEXT50 | CHAR | 50 | 0 | COBRA beneficiary's full name | ||
54 | GBDAT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
55 | PERID | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
56 | PERSN | COB_PER20 | TEXT20 | CHAR | 20 | 0 | COBRA type of person for COBRA beneficiary | ||
57 | DEPPI | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
58 | BEEVD | BEN_BEEVD | XFELD | CHAR | 1 | 0 | Benefit indicator records start on adjustment reason date | ||
59 | BESYS | BEN_BESYS | XFELD | CHAR | 1 | 0 | Benefit indicator records begin at date of offer | ||
60 | BEFXD | BEN_BEFXD | XFELD | CHAR | 1 | 0 | Benefit indicator records start on another date | ||
61 | ENPRO | BEN_ENPRO | XFELD | CHAR | 1 | 0 | Benefit indicator records end on default date | ||
62 | ENEOT | BEN_ENEOT | XFELD | CHAR | 1 | 0 | Benefit indicator records end at the end of time | ||
63 | ENFXD | BEN_ENFXD | XFELD | CHAR | 1 | 0 | Benefit indicator records end on another date | ||
64 | NOOPN | BEN_NOOPN | XFELD | CHAR | 1 | 0 | Benefit indicator open enrollment is not performed | ||
65 | PDEEP | BEN_PDEEP | XFELD | CHAR | 1 | 0 | Benefit indicator reference period is payroll period | ||
66 | CKFFL | BEN_CKFFL | XFELD | CHAR | 1 | 0 | Benefit indicator check conditions if not yet fulfilled | ||
67 | CUMPD | BEN_CUMPD | XFELD | CHAR | 1 | 0 | Benefit indicator cumulation in fixed period | ||
68 | PDREG | BEN_PDREG | XFELD | CHAR | 1 | 0 | Benefit Indicator Reference Period Is a Regular Period | ||
69 | SAPSC | BEN_SAPSC | XFELD | CHAR | 1 | 0 | Benefit indicator SAPScript is used for forms | ||
70 | DOCTX | SDOK_DESCR | TEXT64 | CHAR | 64 | 0 | Short Description | ||
71 | FOTTX | BEN_FOTTX | DDTEXT | CHAR | 60 | 0 | Benefit form type text | ||
72 | PERTX | BEN_PERTX | DDTEXT | CHAR | 60 | 0 | Benefit calculation period text | ||
73 | EOIAT | BEN_EOIAT | DDTEXT | CHAR | 60 | 0 | Benefit text for action when EOI statement not provided | ||
74 | EVTTX | COB_EVTTX | DDTEXT | CHAR | 60 | 0 | COBRA event type text | ||
75 | EECPP | BEN_EECPP | XFELD | CHAR | 1 | 0 | Benefit Pre- and Post Tax as Basis Indicator | ||
76 | EECPR | BEN_EECPR | XFELD | CHAR | 1 | 0 | Benefit Indicator Based on Pre-Tax Contribution Only | ||
77 | EECPS | BEN_EECPS | XFELD | CHAR | 1 | 0 | Benefit Indicator Based on Post-Tax Contribution Only | ||
78 | ACHRS | BEN_ACHRS | XFELD | CHAR | 1 | 0 | Benefit Display Dynamic Eligibility by Actual Hours Worked | ||
79 | SVEVA | BEN_SVEVA | XFELD | CHAR | 1 | 0 | Benefit Indicator Dynamic Eligibility by Length of Service | ||
80 | EQCAL | BEN_EQCAL | XFELD | CHAR | 1 | 0 | Benefit Indicator Credited Hours as Calculated in Model | ||
81 | EQVAL | BEN_EQVAL | XFELD | CHAR | 1 | 0 | Benefit Indicator Benefit Accrual Hours by Value to Replace | ||
82 | URLL1 | BEN_URLLN | BEN_URLLN | CHAR | 93 | 0 | Benefit URL Line in Maintenance Screen | ||
83 | URLL2 | BEN_URLLN | BEN_URLLN | CHAR | 93 | 0 | Benefit URL Line in Maintenance Screen | ||
84 | URLL3 | BEN_URLLN | BEN_URLLN | CHAR | 93 | 0 | Benefit URL Line in Maintenance Screen | ||
85 | ADOBE | BEN_ADOBE | XFELD | CHAR | 1 | 0 | ADOBE Used to Display Benefit Forms | ||
86 | GRCRD | BEN_CGRCRD | BEN_CDAY | CHAR | 2 | 0 | Benefit End of Current Year Grace Period: Day | ||
87 | GRCRM | BEN_CGRCRM | BEN_CMONTH | CHAR | 2 | 0 | Benefit End of Current Year Grace Period: Month |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | Q5UB0 | CURR1 | TCURC | WAERS | |||
2 | Q5UB0 | CURR2 | TCURC | WAERS | |||
3 | Q5UB0 | CURR3 | TCURC | WAERS | |||
4 | Q5UB0 | CURR4 | TCURC | WAERS | |||
5 | Q5UB0 | CURR5 | TCURC | WAERS | |||
6 | Q5UB0 | CURR6 | TCURC | WAERS | |||
7 | Q5UB0 | CURR7 | TCURC | WAERS | |||
8 | Q5UB0 | CURR8 | TCURC | WAERS | |||
9 | Q5UB0 | CURR9 | TCURC | WAERS | |||
10 | Q5UB0 | CURRA | TCURC | WAERS | |||
11 | Q5UB0 | CURRB | TCURC | WAERS | |||
12 | Q5UB0 | CURRC | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |