SAP ABAP Table HRP1020 (Infotype 1020 DB table)
Hierarchy
☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ PE (Application Component) Training and Event Management
     ⤷ PP09 (Package) Training and Event Management
Basic Data
Table Category TRANSP    Transparent table 
Transparent table HRP1020   Table Relationship Diagram
Short Description Infotype 1020 DB table    
Delivery and Maintenance
Pool/cluster      
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
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   Extended Key Definition of PD Infotypes  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version T778P
4 OTYPE OTYPE OTYPE CHAR 2   0   Object Type T778O
5 OBJID HROBJID HROBJID NUMC 8   0   Object ID PLOGI
6 SUBTY SUBTYP SUBTYP CHAR 4   0   Subtype *
7 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
8 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
9 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
10 VARYF VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
11 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
12 INFTY INFOTYP INFOTYP CHAR 4   0   Infotype T778T
13 OTJID OTJID CHAR10 CHAR 10   0   Concatenation of Object Type and Object ID  
14 .INCLUDE       0   0   Infotype Administration Data  
15 AEDTM AEDTM DATUM DATS 8   0   Changed on  
16 UNAME USRNAME CHAR12 CHAR 12   0   User Name  
17 REASN REASN CHAR2 CHAR 2   0   Reason  
18 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
19 ITXNR ITXNR NUM08 NUMC 8   0   Text Module for Infotype  
20 .INCLUDE       0   0   Infotype 1020 fields  
21 .INCLUDE       0   0   Substructure Infotype 1020: Demand  
22 LANGU LANGU SPRAS LANG 1   0   Language Key T002
23 BED01 BED01 DEC03 DEC 3   0   Demand in first quarter  
24 BED02 BED02 DEC03 DEC 3   0   Demand in second quarter  
25 BED03 BED03 DEC03 DEC 3   0   Demand in third quarter  
26 BED04 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
27 .INCLU-001       0   0   Substructure Infotype 1020: Demand  
28 LANGU001 LANGU SPRAS LANG 1   0   Language Key T002
29 BED01001 BED01 DEC03 DEC 3   0   Demand in first quarter  
30 BED02001 BED02 DEC03 DEC 3   0   Demand in second quarter  
31 BED03001 BED03 DEC03 DEC 3   0   Demand in third quarter  
32 BED04001 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
33 .INCLU-002       0   0   Substructure Infotype 1020: Demand  
34 LANGU002 LANGU SPRAS LANG 1   0   Language Key T002
35 BED01002 BED01 DEC03 DEC 3   0   Demand in first quarter  
36 BED02002 BED02 DEC03 DEC 3   0   Demand in second quarter  
37 BED03002 BED03 DEC03 DEC 3   0   Demand in third quarter  
38 BED04002 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
39 .INCLU-003       0   0   Substructure Infotype 1020: Demand  
40 LANGU003 LANGU SPRAS LANG 1   0   Language Key T002
41 BED01003 BED01 DEC03 DEC 3   0   Demand in first quarter  
42 BED02003 BED02 DEC03 DEC 3   0   Demand in second quarter  
43 BED03003 BED03 DEC03 DEC 3   0   Demand in third quarter  
44 BED04003 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
45 .INCLU-004       0   0   Substructure Infotype 1020: Demand  
46 LANGU004 LANGU SPRAS LANG 1   0   Language Key T002
47 BED01004 BED01 DEC03 DEC 3   0   Demand in first quarter  
48 BED02004 BED02 DEC03 DEC 3   0   Demand in second quarter  
49 BED03004 BED03 DEC03 DEC 3   0   Demand in third quarter  
50 BED04004 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
51 .INCLU-005       0   0   Substructure Infotype 1020: Demand  
52 LANGU005 LANGU SPRAS LANG 1   0   Language Key T002
53 BED01005 BED01 DEC03 DEC 3   0   Demand in first quarter  
54 BED02005 BED02 DEC03 DEC 3   0   Demand in second quarter  
55 BED03005 BED03 DEC03 DEC 3   0   Demand in third quarter  
56 BED04005 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
57 .INCLU-006       0   0   Substructure Infotype 1020: Demand  
58 LANGU006 LANGU SPRAS LANG 1   0   Language Key T002
59 BED01006 BED01 DEC03 DEC 3   0   Demand in first quarter  
60 BED02006 BED02 DEC03 DEC 3   0   Demand in second quarter  
61 BED03006 BED03 DEC03 DEC 3   0   Demand in third quarter  
62 BED04006 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
63 .INCLU-007       0   0   Substructure Infotype 1020: Demand  
64 LANGU007 LANGU SPRAS LANG 1   0   Language Key T002
65 BED01007 BED01 DEC03 DEC 3   0   Demand in first quarter  
66 BED02007 BED02 DEC03 DEC 3   0   Demand in second quarter  
67 BED03007 BED03 DEC03 DEC 3   0   Demand in third quarter  
68 BED04007 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
69 .INCLU-008       0   0   Substructure Infotype 1020: Demand  
70 LANGU008 LANGU SPRAS LANG 1   0   Language Key T002
71 BED01008 BED01 DEC03 DEC 3   0   Demand in first quarter  
72 BED02008 BED02 DEC03 DEC 3   0   Demand in second quarter  
73 BED03008 BED03 DEC03 DEC 3   0   Demand in third quarter  
74 BED04008 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
75 .INCLU-009       0   0   Substructure Infotype 1020: Demand  
76 LANGU009 LANGU SPRAS LANG 1   0   Language Key T002
77 BED01009 BED01 DEC03 DEC 3   0   Demand in first quarter  
78 BED02009 BED02 DEC03 DEC 3   0   Demand in second quarter  
79 BED03009 BED03 DEC03 DEC 3   0   Demand in third quarter  
80 BED04009 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
81 .INCLU-010       0   0   Substructure Infotype 1020: Demand  
82 LANGU010 LANGU SPRAS LANG 1   0   Language Key T002
83 BED01010 BED01 DEC03 DEC 3   0   Demand in first quarter  
84 BED02010 BED02 DEC03 DEC 3   0   Demand in second quarter  
85 BED03010 BED03 DEC03 DEC 3   0   Demand in third quarter  
86 BED04010 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
87 .INCLU-011       0   0   Substructure Infotype 1020: Demand  
88 LANGU011 LANGU SPRAS LANG 1   0   Language Key T002
89 BED01011 BED01 DEC03 DEC 3   0   Demand in first quarter  
90 BED02011 BED02 DEC03 DEC 3   0   Demand in second quarter  
91 BED03011 BED03 DEC03 DEC 3   0   Demand in third quarter  
92 BED04011 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
93 .INCLU-012       0   0   Substructure Infotype 1020: Demand  
94 LANGU012 LANGU SPRAS LANG 1   0   Language Key T002
95 BED01012 BED01 DEC03 DEC 3   0   Demand in first quarter  
96 BED02012 BED02 DEC03 DEC 3   0   Demand in second quarter  
97 BED03012 BED03 DEC03 DEC 3   0   Demand in third quarter  
98 BED04012 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
99 .INCLU-013       0   0   Substructure Infotype 1020: Demand  
100 LANGU013 LANGU SPRAS LANG 1   0   Language Key T002
101 BED01013 BED01 DEC03 DEC 3   0   Demand in first quarter  
102 BED02013 BED02 DEC03 DEC 3   0   Demand in second quarter  
103 BED03013 BED03 DEC03 DEC 3   0   Demand in third quarter  
104 BED04013 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
105 .INCLU-014       0   0   Substructure Infotype 1020: Demand  
106 LANGU014 LANGU SPRAS LANG 1   0   Language Key T002
107 BED01014 BED01 DEC03 DEC 3   0   Demand in first quarter  
108 BED02014 BED02 DEC03 DEC 3   0   Demand in second quarter  
109 BED03014 BED03 DEC03 DEC 3   0   Demand in third quarter  
110 BED04014 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
111 .INCLU-015       0   0   Substructure Infotype 1020: Demand  
112 LANGU015 LANGU SPRAS LANG 1   0   Language Key T002
113 BED01015 BED01 DEC03 DEC 3   0   Demand in first quarter  
114 BED02015 BED02 DEC03 DEC 3   0   Demand in second quarter  
115 BED03015 BED03 DEC03 DEC 3   0   Demand in third quarter  
116 BED04015 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
117 .INCLU-016       0   0   Substructure Infotype 1020: Demand  
118 LANGU016 LANGU SPRAS LANG 1   0   Language Key T002
119 BED01016 BED01 DEC03 DEC 3   0   Demand in first quarter  
120 BED02016 BED02 DEC03 DEC 3   0   Demand in second quarter  
121 BED03016 BED03 DEC03 DEC 3   0   Demand in third quarter  
122 BED04016 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
123 .INCLU-017       0   0   Substructure Infotype 1020: Demand  
124 LANGU017 LANGU SPRAS LANG 1   0   Language Key T002
125 BED01017 BED01 DEC03 DEC 3   0   Demand in first quarter  
126 BED02017 BED02 DEC03 DEC 3   0   Demand in second quarter  
127 BED03017 BED03 DEC03 DEC 3   0   Demand in third quarter  
128 BED04017 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
129 .INCLU-018       0   0   Substructure Infotype 1020: Demand  
130 LANGU018 LANGU SPRAS LANG 1   0   Language Key T002
131 BED01018 BED01 DEC03 DEC 3   0   Demand in first quarter  
132 BED02018 BED02 DEC03 DEC 3   0   Demand in second quarter  
133 BED03018 BED03 DEC03 DEC 3   0   Demand in third quarter  
134 BED04018 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
135 .INCLU-019       0   0   Substructure Infotype 1020: Demand  
136 LANGU019 LANGU SPRAS LANG 1   0   Language Key T002
137 BED01019 BED01 DEC03 DEC 3   0   Demand in first quarter  
138 BED02019 BED02 DEC03 DEC 3   0   Demand in second quarter  
139 BED03019 BED03 DEC03 DEC 3   0   Demand in third quarter  
140 BED04019 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
141 .INCLU-020       0   0   Substructure Infotype 1020: Demand  
142 LANGU020 LANGU SPRAS LANG 1   0   Language Key T002
143 BED01020 BED01 DEC03 DEC 3   0   Demand in first quarter  
144 BED02020 BED02 DEC03 DEC 3   0   Demand in second quarter  
145 BED03020 BED03 DEC03 DEC 3   0   Demand in third quarter  
146 BED04020 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
147 .INCLU-021       0   0   Substructure Infotype 1020: Demand  
148 LANGU021 LANGU SPRAS LANG 1   0   Language Key T002
149 BED01021 BED01 DEC03 DEC 3   0   Demand in first quarter  
150 BED02021 BED02 DEC03 DEC 3   0   Demand in second quarter  
151 BED03021 BED03 DEC03 DEC 3   0   Demand in third quarter  
152 BED04021 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
153 .INCLU-022       0   0   Substructure Infotype 1020: Demand  
154 LANGU022 LANGU SPRAS LANG 1   0   Language Key T002
155 BED01022 BED01 DEC03 DEC 3   0   Demand in first quarter  
156 BED02022 BED02 DEC03 DEC 3   0   Demand in second quarter  
157 BED03022 BED03 DEC03 DEC 3   0   Demand in third quarter  
158 BED04022 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
159 .INCLU-023       0   0   Substructure Infotype 1020: Demand  
160 LANGU023 LANGU SPRAS LANG 1   0   Language Key T002
161 BED01023 BED01 DEC03 DEC 3   0   Demand in first quarter  
162 BED02023 BED02 DEC03 DEC 3   0   Demand in second quarter  
163 BED03023 BED03 DEC03 DEC 3   0   Demand in third quarter  
164 BED04023 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
165 .INCLU-024       0   0   Substructure Infotype 1020: Demand  
166 LANGU024 LANGU SPRAS LANG 1   0   Language Key T002
167 BED01024 BED01 DEC03 DEC 3   0   Demand in first quarter  
168 BED02024 BED02 DEC03 DEC 3   0   Demand in second quarter  
169 BED03024 BED03 DEC03 DEC 3   0   Demand in third quarter  
170 BED04024 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
171 .INCLU-025       0   0   Substructure Infotype 1020: Demand  
172 LANGU025 LANGU SPRAS LANG 1   0   Language Key T002
173 BED01025 BED01 DEC03 DEC 3   0   Demand in first quarter  
174 BED02025 BED02 DEC03 DEC 3   0   Demand in second quarter  
175 BED03025 BED03 DEC03 DEC 3   0   Demand in third quarter  
176 BED04025 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
177 .INCLU-026       0   0   Substructure Infotype 1020: Demand  
178 LANGU026 LANGU SPRAS LANG 1   0   Language Key T002
179 BED01026 BED01 DEC03 DEC 3   0   Demand in first quarter  
180 BED02026 BED02 DEC03 DEC 3   0   Demand in second quarter  
181 BED03026 BED03 DEC03 DEC 3   0   Demand in third quarter  
182 BED04026 BED04 DEC03 DEC 3   0   Demand in fourth quarter  
183 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 HRP1020 INFTY T778T INFTY KEY 1 CN
2 HRP1020 ISTAT T778S ISTAT KEY 1 CN
3 HRP1020 LANGU T002 SPRAS KEY 1 CN
4 HRP1020 LANGU001 T002 SPRAS KEY 1 CN
5 HRP1020 LANGU002 T002 SPRAS KEY 1 CN
6 HRP1020 LANGU003 T002 SPRAS KEY 1 CN
7 HRP1020 LANGU004 T002 SPRAS KEY 1 CN
8 HRP1020 LANGU005 T002 SPRAS KEY 1 CN
9 HRP1020 LANGU006 T002 SPRAS KEY 1 CN
10 HRP1020 LANGU007 T002 SPRAS KEY 1 CN
11 HRP1020 LANGU008 T002 SPRAS KEY 1 CN
12 HRP1020 LANGU009 T002 SPRAS KEY 1 CN
13 HRP1020 LANGU010 T002 SPRAS KEY 1 CN
14 HRP1020 LANGU011 T002 SPRAS KEY 1 CN
15 HRP1020 LANGU012 T002 SPRAS KEY 1 CN
16 HRP1020 LANGU013 T002 SPRAS KEY 1 CN
17 HRP1020 LANGU014 T002 SPRAS KEY 1 CN
18 HRP1020 LANGU015 T002 SPRAS KEY 1 CN
19 HRP1020 LANGU016 T002 SPRAS KEY 1 CN
20 HRP1020 LANGU017 T002 SPRAS KEY 1 CN
21 HRP1020 LANGU018 T002 SPRAS KEY 1 CN
22 HRP1020 LANGU019 T002 SPRAS KEY 1 CN
23 HRP1020 LANGU020 T002 SPRAS KEY 1 CN
24 HRP1020 LANGU021 T002 SPRAS KEY 1 CN
25 HRP1020 LANGU022 T002 SPRAS KEY 1 CN
26 HRP1020 LANGU023 T002 SPRAS KEY 1 CN
27 HRP1020 LANGU024 T002 SPRAS KEY 1 CN
28 HRP1020 LANGU025 T002 SPRAS KEY 1 CN
29 HRP1020 LANGU026 T002 SPRAS KEY 1 CN
30 HRP1020 MANDT T000 MANDT KEY 1 CN
31 HRP1020 OBJID PLOGI OBJID KEY 1 CN
32 HRP1020 OTYPE T778O OTYPE KEY 1 CN
33 HRP1020 PLVAR T778P PLVAR KEY 1 CN
History
Last changed by/on SAP  20070912 
SAP Release Created in