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