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