SAP ABAP Table P0806 (Personnel Master Record for Infotype 0806)
Hierarchy
☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-OF-PER (Application Component) Personnel Categories
     ⤷ HRTRAINING (Package) HR Training
Basic Data
Table Category INTTAB    Structure 
Structure P0806   Table Relationship Diagram
Short Description Personnel Master Record for Infotype 0806    
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   Training Programs  
28 TPROG_ID TPROG_ID TPROG_ID CHAR 15   0   Training Program ID TRAIN_PROG
29 FUNCT_ID FUNCT_ID FUNCT_ID CHAR 15   0   Function ID TRAIN_FUNCT
30 AFUNCT_ID AFUNCT_ID AFUNCT_ID CHAR 15   0   Additional Function ID TRAIN_AFUNCT
31 STATUS_ID TSTAT_ID CHAR15 CHAR 15   0   Training Status ID TRAIN_STAT
32 ORDER_ID AUFNR AUFNR CHAR 12   0   Order Number *
33 TRAIN_01 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
34 ACT_VALUE01 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
35 UNIT_VALUE01 TUNIT_VALUE MEINS UNIT 3   0   Unit *
36 TPASS01 TPASS CHAR1 CHAR 1   0   Training Passed  
37 TRAIN_02 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
38 ACT_VALUE02 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
39 UNIT_VALUE02 TUNIT_VALUE MEINS UNIT 3   0   Unit *
40 TPASS02 TPASS CHAR1 CHAR 1   0   Training Passed  
41 TRAIN_03 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
42 ACT_VALUE03 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
43 UNIT_VALUE03 TUNIT_VALUE MEINS UNIT 3   0   Unit *
44 TPASS03 TPASS CHAR1 CHAR 1   0   Training Passed  
45 TRAIN_04 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
46 ACT_VALUE04 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
47 UNIT_VALUE04 TUNIT_VALUE MEINS UNIT 3   0   Unit *
48 TPASS04 TPASS CHAR1 CHAR 1   0   Training Passed  
49 TRAIN_05 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
50 ACT_VALUE05 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
51 UNIT_VALUE05 TUNIT_VALUE MEINS UNIT 3   0   Unit *
52 TPASS05 TPASS CHAR1 CHAR 1   0   Training Passed  
53 TRAIN_06 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
54 ACT_VALUE06 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
55 UNIT_VALUE06 TUNIT_VALUE MEINS UNIT 3   0   Unit *
56 TPASS06 TPASS CHAR1 CHAR 1   0   Training Passed  
57 TRAIN_07 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
58 ACT_VALUE07 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
59 UNIT_VALUE07 TUNIT_VALUE MEINS UNIT 3   0   Unit *
60 TPASS07 TPASS CHAR1 CHAR 1   0   Training Passed  
61 TRAIN_08 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
62 ACT_VALUE08 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
63 UNIT_VALUE08 TUNIT_VALUE MEINS UNIT 3   0   Unit *
64 TPASS08 TPASS CHAR1 CHAR 1   0   Training Passed  
65 TRAIN_09 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
66 ACT_VALUE09 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
67 UNIT_VALUE09 TUNIT_VALUE MEINS UNIT 3   0   Unit *
68 TPASS09 TPASS CHAR1 CHAR 1   0   Training Passed  
69 TRAIN_10 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
70 ACT_VALUE10 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
71 UNIT_VALUE10 TUNIT_VALUE MEINS UNIT 3   0   Unit *
72 TPASS10 TPASS CHAR1 CHAR 1   0   Training Passed  
73 TRAIN_11 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
74 ACT_VALUE11 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
75 UNIT_VALUE11 TUNIT_VALUE MEINS UNIT 3   0   Unit *
76 TPASS11 TPASS CHAR1 CHAR 1   0   Training Passed  
77 TRAIN_12 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
78 ACT_VALUE12 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
79 UNIT_VALUE12 TUNIT_VALUE MEINS UNIT 3   0   Unit *
80 TPASS12 TPASS CHAR1 CHAR 1   0   Training Passed  
81 TRAIN_13 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
82 ACT_VALUE13 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
83 UNIT_VALUE13 TUNIT_VALUE MEINS UNIT 3   0   Unit *
84 TPASS13 TPASS CHAR1 CHAR 1   0   Training Passed  
85 TRAIN_14 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
86 ACT_VALUE14 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
87 UNIT_VALUE14 TUNIT_VALUE MEINS UNIT 3   0   Unit *
88 TPASS14 TPASS CHAR1 CHAR 1   0   Training Passed  
89 TRAIN_15 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
90 ACT_VALUE15 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
91 UNIT_VALUE15 TUNIT_VALUE MEINS UNIT 3   0   Unit *
92 TPASS15 TPASS CHAR1 CHAR 1   0   Training Passed  
93 TRAIN_16 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
94 ACT_VALUE16 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
95 UNIT_VALUE16 TUNIT_VALUE MEINS UNIT 3   0   Unit *
96 TPASS16 TPASS CHAR1 CHAR 1   0   Training Passed  
97 TRAIN_17 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
98 ACT_VALUE17 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
99 UNIT_VALUE17 TUNIT_VALUE MEINS UNIT 3   0   Unit *
100 TPASS17 TPASS CHAR1 CHAR 1   0   Training Passed  
101 TRAIN_18 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
102 ACT_VALUE18 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
103 UNIT_VALUE18 TUNIT_VALUE MEINS UNIT 3   0   Unit *
104 TPASS18 TPASS CHAR1 CHAR 1   0   Training Passed  
105 TRAIN_19 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
106 ACT_VALUE19 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
107 UNIT_VALUE19 TUNIT_VALUE MEINS UNIT 3   0   Unit *
108 TPASS19 TPASS CHAR1 CHAR 1   0   Training Passed  
109 TRAIN_20 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
110 ACT_VALUE20 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
111 UNIT_VALUE20 TUNIT_VALUE MEINS UNIT 3   0   Unit *
112 TPASS20 TPASS CHAR1 CHAR 1   0   Training Passed  
113 TRAIN_21 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
114 ACT_VALUE21 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
115 UNIT_VALUE21 TUNIT_VALUE MEINS UNIT 3   0   Unit *
116 TPASS21 TPASS CHAR1 CHAR 1   0   Training Passed  
117 TRAIN_22 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
118 ACT_VALUE22 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
119 UNIT_VALUE22 TUNIT_VALUE MEINS UNIT 3   0   Unit *
120 TPASS22 TPASS CHAR1 CHAR 1   0   Training Passed  
121 TRAIN_23 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
122 ACT_VALUE23 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
123 UNIT_VALUE23 TUNIT_VALUE MEINS UNIT 3   0   Unit *
124 TPASS23 TPASS CHAR1 CHAR 1   0   Training Passed  
125 TRAIN_24 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
126 ACT_VALUE24 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
127 UNIT_VALUE24 TUNIT_VALUE MEINS UNIT 3   0   Unit *
128 TPASS24 TPASS CHAR1 CHAR 1   0   Training Passed  
129 TRAIN_25 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
130 ACT_VALUE25 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
131 UNIT_VALUE25 TUNIT_VALUE MEINS UNIT 3   0   Unit *
132 TPASS25 TPASS CHAR1 CHAR 1   0   Training Passed  
133 TRAIN_26 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
134 ACT_VALUE26 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
135 UNIT_VALUE26 TUNIT_VALUE MEINS UNIT 3   0   Unit *
136 TPASS26 TPASS CHAR1 CHAR 1   0   Training Passed  
137 TRAIN_27 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
138 ACT_VALUE27 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
139 UNIT_VALUE27 TUNIT_VALUE MEINS UNIT 3   0   Unit *
140 TPASS27 TPASS CHAR1 CHAR 1   0   Training Passed  
141 TRAIN_28 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
142 ACT_VALUE28 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
143 UNIT_VALUE28 TUNIT_VALUE MEINS UNIT 3   0   Unit *
144 TPASS28 TPASS CHAR1 CHAR 1   0   Training Passed  
145 TRAIN_29 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
146 ACT_VALUE29 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
147 UNIT_VALUE29 TUNIT_VALUE MEINS UNIT 3   0   Unit *
148 TPASS29 TPASS CHAR1 CHAR 1   0   Training Passed  
149 TRAIN_30 TRAIN_ID CHAR15 CHAR 15   0   Training ID  
150 ACT_VALUE30 TACT_VALUE DEC_8_2 DEC 8   2   Amount of Current Training Completed (Actual Data)  
151 UNIT_VALUE30 TUNIT_VALUE MEINS UNIT 3   0   Unit *
152 TPASS30 TPASS CHAR1 CHAR 1   0   Training Passed  
153 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 P0806 AFUNCT_ID TRAIN_AFUNCT AFUNCT_ID KEY 1 CN
2 P0806 FUNCT_ID TRAIN_FUNCT FUNCT_ID KEY 1 CN
3 P0806 INFTY T582A INFTY    
4 P0806 PREAS T530E PREAS    
5 P0806 STATUS_ID TRAIN_STAT STATUS_ID    
6 P0806 TPROG_ID TRAIN_PROG TPROG_ID KEY 1 CN
History
Last changed by/on SAP  20080626 
SAP Release Created in 600