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