SAP ABAP Table PS0167 (HR Master Record: Infotype 0167 (Health Plans))
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 | PS0167 | Table Relationship Diagram |
Short Description | HR Master Record: Infotype 0167 (Health Plans) |
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 | BAREA | BEN_AREA | BEN_AREA | CHAR | 2 | 0 | Benefit area | T5UB3 | |
2 | PLTYP | BEN_TYPE | BEN_TYPE | CHAR | 4 | 0 | Benefit plan type | T5UB1 | |
3 | BPLAN | BEN_PLAN | BEN_PLAN | CHAR | 4 | 0 | Benefit plan | T5UBA | |
4 | BENGR | BEN_GROUP | BEN_GROUP | CHAR | 4 | 0 | Benefit First Program Grouping | T5UBT | |
5 | BSTAT | BEN_EESTAT | BEN_EESTAT | CHAR | 4 | 0 | Benefit Second Program Grouping | T5UB9 | |
6 | ELIDT | BEN_ELIDT | DATUM | DATS | 8 | 0 | Benefit calculated eligibility date | ||
7 | ELDTO | BEN_ELIDTO | DATUM | DATS | 8 | 0 | Benefit override eligibility date | ||
8 | PARDT | BEN_PARTDT | DATUM | DATS | 8 | 0 | Benefit date of first participation in plan | ||
9 | BOPTI | BEN_OPTION | BEN_OPTION | CHAR | 4 | 0 | Benefit Health Plan Option | T5UBE | |
10 | DEPCV | BEN_DEPCOV | BEN_DEPCOV | CHAR | 4 | 0 | Benefit Dependent Coverage | T5UBF | |
11 | COORD | BEN_COORD | XFELD | CHAR | 1 | 0 | Benefit Indicator Coordination of Benefits | ||
12 | PROVI | BEN_PROVI | TEXT30 | CHAR | 30 | 0 | Benefit additional benefit provider | ||
13 | POLNR | BEN_POLNR | CHAR20 | CHAR | 20 | 0 | Benefit policy number | ||
14 | ENRTY | BEN_ENRTYP | BEN_ENRTYP | CHAR | 1 | 0 | Benefit Type of Plan Enrollment | ||
15 | EVENT | BEN_EVENT | BEN_EVENT | CHAR | 4 | 0 | Benefit adjustment reason | T74HA | |
16 | EOGRP | BEN_EOGRP | DATUM | DATS | 8 | 0 | Benefits End of Grace Period | ||
17 | EOIRQ | BEN_EOIRQ | XFELD | CHAR | 1 | 0 | Benefit Statement of Insurability Required | ||
18 | EOIPR | BEN_EOIPR | XFELD | CHAR | 1 | 0 | Benefit Insurability Proven | ||
19 | PRETX | BEN_PRETX | XFELD | CHAR | 1 | 0 | Benefit Indicator Deductions Based on Pre-Tax | ||
20 | CSTOV | BEN_CSTOV | P_AMT07 | CURR | 13 | 2 | Benefit Alternative Amount for Costs | ||
21 | BNCST | BEN_BNCST | P_AMT07 | CURR | 13 | 2 | Benefit Costs for Bonus Payment | ||
22 | PERIO | BEN_PERIOD | PFREQ | NUMC | 2 | 0 | Benefit Period for Calculations | ||
23 | CURRE | BEN_CURR | WAERS | CUKY | 5 | 0 | Benefit Currency Key | TCURC | |
24 | .INCLUDE | 0 | 0 | Benefit repeat structure for dependent | |||||
25 | DTY01 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
26 | DID01 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
27 | DTY02 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
28 | DID02 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
29 | DTY03 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
30 | DID03 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
31 | DTY04 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
32 | DID04 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
33 | DTY05 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
34 | DID05 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
35 | DTY06 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
36 | DID06 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
37 | DTY07 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
38 | DID07 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
39 | DTY08 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
40 | DID08 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
41 | DTY09 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
42 | DID09 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
43 | DTY10 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
44 | DID10 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
45 | DTY11 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
46 | DID11 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
47 | DTY12 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
48 | DID12 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
49 | DTY13 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
50 | DID13 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
51 | DTY14 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
52 | DID14 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
53 | DTY15 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
54 | DID15 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
55 | DTY16 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
56 | DID16 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
57 | DTY17 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
58 | DID17 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
59 | DTY18 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
60 | DID18 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
61 | DTY19 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
62 | DID19 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
63 | DTY20 | BEN_DEPTYP | SUBTY | CHAR | 4 | 0 | Benefit dependent type | ||
64 | DID20 | BEN_DEPID | OBJPS | CHAR | 2 | 0 | Benefit dependent object ID | ||
65 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PS0167 | BAREA | T5UB3 | BAREA | |||
2 | PS0167 | BENGR | T5UBT | BENGR | |||
3 | PS0167 | BOPTI | T5UBE | BOPTI | |||
4 | PS0167 | BPLAN | T5UBA | BPLAN | |||
5 | PS0167 | BSTAT | T5UB9 | BSTAT | KEY | 1 | CN |
6 | PS0167 | CURRE | TCURC | WAERS | |||
7 | PS0167 | DEPCV | T5UBF | DEPCV | |||
8 | PS0167 | EVENT | T74HA | EVENT | REF | C | CN |
9 | PS0167 | PLTYP | T5UB1 | PLTYP |
History
Last changed by/on | SAP | 20020219 |
SAP Release Created in |