SAP ABAP Table P0167 (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
Basic Data
Table Category INTTAB    Structure 
Structure P0167   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 .INCLUDE       0   0   Headers for Infotype Records  
2 .INCLUDE       0   0   Keys for HR Master Data  
3 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
4 INFTY INFTY INFOTYP CHAR 4   0   Infotype T582A
5 SUBTY SUBTY SUBTY CHAR 4   0   Subtype  
6 OBJPS OBJPS OBJPS CHAR 2   0   Object Identification  
7 SPRPS SPRPS SPRPS CHAR 1   0   Lock Indicator for HR Master Data Record  
8 ENDDA ENDDA DATUM DATS 8   0   End Date  
9 BEGDA BEGDA DATUM DATS 8   0   Start Date  
10 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
11 .INCLUDE       0   0   HR Master Record: Control Field  
12 AEDTM AEDAT DATUM DATS 8   0   Last Changed On  
13 UNAME AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
14 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
15 ITXEX ITXEX XFELD CHAR 1   0   Text Exists for Infotype  
16 REFEX PRFEX XFELD CHAR 1   0   Reference Fields Exist (Primary/Secondary Costs)  
17 ORDEX ORDEX XFELD CHAR 1   0   Confirmation Fields Exist  
18 ITBLD ITBLD CHAR2 CHAR 2   0   Infotype Screen Control  
19 PREAS PREAS PREAS CHAR 2   0   Reason for Changing Master Data T530E
20 FLAG1 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
21 FLAG2 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
22 FLAG3 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
23 FLAG4 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
24 RESE1 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
25 RESE2 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
26 GRPVL PCCE_GPVAL PCCE_GPVAL CHAR 4   0   Grouping Value for Personnel Assignments  
27 .INCLUDE       0   0   HR Master Record: Infotype 0167 (Health Plans)  
28 BAREA BEN_AREA BEN_AREA CHAR 2   0   Benefit area T5UB3
29 PLTYP BEN_TYPE BEN_TYPE CHAR 4   0   Benefit plan type T5UB1
30 BPLAN BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan T5UBA
31 BENGR BEN_GROUP BEN_GROUP CHAR 4   0   Benefit First Program Grouping T5UBT
32 BSTAT BEN_EESTAT BEN_EESTAT CHAR 4   0   Benefit Second Program Grouping T5UB9
33 ELIDT BEN_ELIDT DATUM DATS 8   0   Benefit calculated eligibility date  
34 ELDTO BEN_ELIDTO DATUM DATS 8   0   Benefit override eligibility date  
35 PARDT BEN_PARTDT DATUM DATS 8   0   Benefit date of first participation in plan  
36 BOPTI BEN_OPTION BEN_OPTION CHAR 4   0   Benefit Health Plan Option T5UBE
37 DEPCV BEN_DEPCOV BEN_DEPCOV CHAR 4   0   Benefit Dependent Coverage T5UBF
38 COORD BEN_COORD XFELD CHAR 1   0   Benefit Indicator Coordination of Benefits  
39 PROVI BEN_PROVI TEXT30 CHAR 30   0   Benefit additional benefit provider  
40 POLNR BEN_POLNR CHAR20 CHAR 20   0   Benefit policy number  
41 ENRTY BEN_ENRTYP BEN_ENRTYP CHAR 1   0   Benefit Type of Plan Enrollment  
42 EVENT BEN_EVENT BEN_EVENT CHAR 4   0   Benefit adjustment reason T74HA
43 EOGRP BEN_EOGRP DATUM DATS 8   0   Benefits End of Grace Period  
44 EOIRQ BEN_EOIRQ XFELD CHAR 1   0   Benefit Statement of Insurability Required  
45 EOIPR BEN_EOIPR XFELD CHAR 1   0   Benefit Insurability Proven  
46 PRETX BEN_PRETX XFELD CHAR 1   0   Benefit Indicator Deductions Based on Pre-Tax  
47 CSTOV BEN_CSTOV P_AMT07 CURR 13   2   Benefit Alternative Amount for Costs  
48 BNCST BEN_BNCST P_AMT07 CURR 13   2   Benefit Costs for Bonus Payment  
49 PERIO BEN_PERIOD PFREQ NUMC 2   0   Benefit Period for Calculations  
50 CURRE BEN_CURR WAERS CUKY 5   0   Benefit Currency Key TCURC
51 .INCLUDE       0   0   Benefit repeat structure for dependent  
52 DTY01 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
53 DID01 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
54 DTY02 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
55 DID02 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
56 DTY03 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
57 DID03 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
58 DTY04 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
59 DID04 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
60 DTY05 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
61 DID05 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
62 DTY06 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
63 DID06 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
64 DTY07 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
65 DID07 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
66 DTY08 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
67 DID08 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
68 DTY09 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
69 DID09 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
70 DTY10 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
71 DID10 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
72 DTY11 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
73 DID11 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
74 DTY12 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
75 DID12 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
76 DTY13 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
77 DID13 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
78 DTY14 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
79 DID14 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
80 DTY15 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
81 DID15 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
82 DTY16 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
83 DID16 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
84 DTY17 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
85 DID17 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
86 DTY18 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
87 DID18 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
88 DTY19 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
89 DID19 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
90 DTY20 BEN_DEPTYP SUBTY CHAR 4   0   Benefit dependent type  
91 DID20 BEN_DEPID OBJPS CHAR 2   0   Benefit dependent object ID  
92 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 P0167 BAREA T5UB3 BAREA KEY 1 CN
2 P0167 BENGR T5UBT BENGR KEY 1 CN
3 P0167 BOPTI T5UBE BOPTI KEY 1 CN
4 P0167 BPLAN T5UBA BPLAN KEY 1 CN
5 P0167 BSTAT T5UB9 BSTAT KEY 1 CN
6 P0167 CURRE TCURC WAERS    
7 P0167 DEPCV T5UBF DEPCV KEY 1 CN
8 P0167 EVENT T74HA EVENT REF C CN
9 P0167 INFTY T582A INFTY    
10 P0167 PLTYP T5UB1 PLTYP KEY 1 CN
11 P0167 PREAS T530E PREAS    
History
Last changed by/on SAP  20020219 
SAP Release Created in