SAP ABAP Table P3743 (HR Master Record for Infotype 3743)
Hierarchy
☛
EA-HRCIN (Software Component) Sub component EA-HRCIN of EA-HR
⤷ PY-IN-PS (Application Component) INDIA PUBLIC SECTOR
⤷ PAOC_PAD_IN_PS (Package) HR IN: India Public Sector
⤷ PY-IN-PS (Application Component) INDIA PUBLIC SECTOR
⤷ PAOC_PAD_IN_PS (Package) HR IN: India Public Sector
Basic Data
Table Category | INTTAB | Structure |
Structure | P3743 | Table Relationship Diagram |
Short Description | HR Master Record for Infotype 3743 |
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 | India Public Sector Disciplinary Actions | |||||
28 | OFFDT | PIN_OFFDT | DATS | DATS | 8 | 0 | Date of offence | ||
29 | OFFSR | PIN_OFFSR | PIN_OFFSR | CHAR | 2 | 0 | HR IN PS: Offence Details Source | * | |
30 | INVDT | PIN_INVDT | DATS | DATS | 8 | 0 | Begin date of investigation | ||
31 | DIACD | PIN_DIACD | PIN_DIACD | CHAR | 3 | 0 | Type of Disciplinary Action | * | |
32 | DAKCR | PIN_DAKCR | DATS | DATS | 8 | 0 | Date of acknowledgement of charge | ||
33 | OFFC1 | PIN_OFFCD | PIN_OFFCD | CHAR | 4 | 0 | Offence code | * | |
34 | OFFC2 | PIN_OFFCD | PIN_OFFCD | CHAR | 4 | 0 | Offence code | * | |
35 | OFFC3 | PIN_OFFCD | PIN_OFFCD | CHAR | 4 | 0 | Offence code | * | |
36 | OFFC4 | PIN_OFFCD | PIN_OFFCD | CHAR | 4 | 0 | Offence code | * | |
37 | OFFC5 | PIN_OFFCD | PIN_OFFCD | CHAR | 4 | 0 | Offence code | * | |
38 | INBD1 | PIN_INTBD | DATS | DATS | 8 | 0 | Begin date of Suspension | ||
39 | INED1 | PIN_INTED | DATS | DATS | 8 | 0 | End date of Suspension | ||
40 | INRE1 | PIN_INTRE | DATS | DATS | 8 | 0 | Effective date of restoration | ||
41 | SUBSA1 | PIN_SUBSA | PIN_SUBSA | CHAR | 1 | 0 | HR IN PS: Subsistence Allowance. | ||
42 | INBD2 | PIN_INTBD | DATS | DATS | 8 | 0 | Begin date of Suspension | ||
43 | INED2 | PIN_INTED | DATS | DATS | 8 | 0 | End date of Suspension | ||
44 | INRE2 | PIN_INTRE | DATS | DATS | 8 | 0 | Effective date of restoration | ||
45 | SUBSA2 | PIN_SUBSA | PIN_SUBSA | CHAR | 1 | 0 | HR IN PS: Subsistence Allowance. | ||
46 | INBD3 | PIN_INTBD | DATS | DATS | 8 | 0 | Begin date of Suspension | ||
47 | INED3 | PIN_INTED | DATS | DATS | 8 | 0 | End date of Suspension | ||
48 | INRE3 | PIN_INTRE | DATS | DATS | 8 | 0 | Effective date of restoration | ||
49 | SUBSA3 | PIN_SUBSA | PIN_SUBSA | CHAR | 1 | 0 | HR IN PS: Subsistence Allowance. | ||
50 | INVPR | PIN_INVPR | PERSNO | NUMC | 8 | 0 | Investigating officer's per no. | * | |
51 | CORES1 | PIN_CORES | PIN_CORES | CHAR | 1 | 0 | HR IN PS: Correspondence | * | |
52 | ISSDT1 | PIN_ISDT | DATUM | DATS | 8 | 0 | HR IN PS: Notification Issue date | ||
53 | RESDT1 | PIN_RSDT | DATUM | DATS | 8 | 0 | HR IN PS: Response Date | ||
54 | CORES2 | PIN_CORES | PIN_CORES | CHAR | 1 | 0 | HR IN PS: Correspondence | * | |
55 | ISSDT2 | PIN_ISDT | DATUM | DATS | 8 | 0 | HR IN PS: Notification Issue date | ||
56 | RESDT2 | PIN_RSDT | DATUM | DATS | 8 | 0 | HR IN PS: Response Date | ||
57 | CORES3 | PIN_CORES | PIN_CORES | CHAR | 1 | 0 | HR IN PS: Correspondence | * | |
58 | ISSDT3 | PIN_ISDT | DATUM | DATS | 8 | 0 | HR IN PS: Notification Issue date | ||
59 | RESDT3 | PIN_RSDT | DATUM | DATS | 8 | 0 | HR IN PS: Response Date | ||
60 | CORES4 | PIN_CORES | PIN_CORES | CHAR | 1 | 0 | HR IN PS: Correspondence | * | |
61 | ISSDT4 | PIN_ISDT | DATUM | DATS | 8 | 0 | HR IN PS: Notification Issue date | ||
62 | RESDT4 | PIN_RSDT | DATUM | DATS | 8 | 0 | HR IN PS: Response Date | ||
63 | DPREQ | PIN_DPREQ | XFELD | CHAR | 1 | 0 | HR IN PS: Disciplinary Proceeding Required | ||
64 | AREPTY1 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
65 | AOBJTY1 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
66 | APERNR1 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
67 | AREPTY2 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
68 | AOBJTY2 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
69 | APERNR2 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
70 | AREPTY3 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
71 | AOBJTY3 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
72 | APERNR3 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
73 | AREPTY4 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
74 | AOBJTY4 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
75 | APERNR4 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
76 | AREPTY5 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
77 | AOBJTY5 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
78 | APERNR5 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
79 | AREPTY6 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
80 | AOBJTY6 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
81 | APERNR6 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
82 | AREPTY7 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
83 | AOBJTY7 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
84 | APERNR7 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
85 | A_HEABD | PIN_HEABD | DATS | DATS | 8 | 0 | Start date of Inquiry Period | ||
86 | A_HEAED | PIN_HEAED | DATS | DATS | 8 | 0 | End date of Inquiry Period | ||
87 | A_STATUS | PIN_STAT | PIN_STAT | NUMC | 3 | 0 | Status of the Disciplinary Action | * | |
88 | A_NHEDB | PIN_NHEBD | DATUM | DATS | 8 | 0 | HR IN PS: Next Hearing Begin Date | ||
89 | AOUCD1 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
90 | AOUCD2 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
91 | AOUCD3 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
92 | AOUCD4 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
93 | AOUDE1 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
94 | AOUDF1 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
95 | AOUDR1 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
96 | AOUMT1 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
97 | AOUAT1 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
98 | AOUDE2 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
99 | AOUDF2 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
100 | AOUDR2 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
101 | AOUMT2 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
102 | AOUAT2 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
103 | AOUDE3 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
104 | AOUDF3 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
105 | AOUDR3 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
106 | AOUMT3 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
107 | AOUAT3 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
108 | AOUDE4 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
109 | AOUDF4 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
110 | AOUDR4 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
111 | AOUMT4 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
112 | AOUAT4 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
113 | FOUCD1 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
114 | FOUCD2 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
115 | FOUCD3 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
116 | FOUCD4 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
117 | FOUDE1 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
118 | FOUDF1 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
119 | FOUDR1 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
120 | FOUMT1 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
121 | FOUAT1 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
122 | FOUDE2 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
123 | FOUDF2 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
124 | FOUDR2 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
125 | FOUMT2 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
126 | FOUAT2 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
127 | FOUDE3 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
128 | FOUDF3 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
129 | FOUDR3 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
130 | FOUMT3 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
131 | FOUAT3 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
132 | FOUDE4 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
133 | FOUDF4 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
134 | FOUDR4 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
135 | FOUMT4 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
136 | FOUAT4 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
137 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
138 | BREPTY1 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
139 | BOBJTY1 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
140 | BPERNR1 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
141 | BREPTY2 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
142 | BOBJTY2 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
143 | BPERNR2 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
144 | BREPTY3 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
145 | BOBJTY3 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
146 | BPERNR3 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
147 | BREPTY4 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
148 | BOBJTY4 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
149 | BPERNR4 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
150 | BREPTY5 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
151 | BOBJTY5 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
152 | BPERNR5 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
153 | BREPTY6 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
154 | BOBJTY6 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
155 | BPERNR6 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
156 | BREPTY7 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
157 | BOBJTY7 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
158 | BPERNR7 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
159 | B_HEABD | PIN_HEABD | DATS | DATS | 8 | 0 | Start date of Inquiry Period | ||
160 | B_HEAED | PIN_HEAED | DATS | DATS | 8 | 0 | End date of Inquiry Period | ||
161 | B_STATUS | PIN_STAT | PIN_STAT | NUMC | 3 | 0 | Status of the Disciplinary Action | * | |
162 | B_NHEDB | PIN_NHEBD | DATUM | DATS | 8 | 0 | HR IN PS: Next Hearing Begin Date | ||
163 | BOUCD1 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
164 | BOUCD2 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
165 | BOUCD3 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
166 | BOUCD4 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
167 | BOUDE1 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
168 | BOUDF1 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
169 | BOUDR1 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
170 | BOUMT1 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
171 | BOUAT1 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
172 | BOUDE2 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
173 | BOUDF2 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
174 | BOUDR2 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
175 | BOUMT2 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
176 | BOUAT2 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
177 | BOUDE3 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
178 | BOUDF3 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
179 | BOUDR3 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
180 | BOUMT3 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
181 | BOUAT3 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
182 | BOUDE4 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
183 | BOUDF4 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
184 | BOUDR4 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
185 | BOUMT4 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
186 | BOUAT4 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
187 | CREPTY1 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
188 | COBJTY1 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
189 | CPERNR1 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
190 | CREPTY2 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
191 | COBJTY2 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
192 | CPERNR2 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
193 | CREPTY3 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
194 | COBJTY3 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
195 | CPERNR3 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
196 | CREPTY4 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
197 | COBJTY4 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
198 | CPERNR4 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
199 | CREPTY5 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
200 | COBJTY5 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
201 | CPERNR5 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
202 | CREPTY6 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
203 | COBJTY6 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
204 | CPERNR6 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
205 | CREPTY7 | PIN_TYPER | PIN_TYPER | CHAR | 3 | 0 | Type of representation for officer | * | |
206 | COBJTY7 | PIN_OBJTY | PIN_OBJTY | CHAR | 1 | 0 | HR IN PS: Internal / External | ||
207 | CPERNR7 | P_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
208 | C_HEABD | PIN_HEABD | DATS | DATS | 8 | 0 | Start date of Inquiry Period | ||
209 | C_HEAED | PIN_HEAED | DATS | DATS | 8 | 0 | End date of Inquiry Period | ||
210 | C_STATUS | PIN_STAT | PIN_STAT | NUMC | 3 | 0 | Status of the Disciplinary Action | * | |
211 | C_NHEDB | PIN_NHEBD | DATUM | DATS | 8 | 0 | HR IN PS: Next Hearing Begin Date | ||
212 | COUCD1 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
213 | COUCD2 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
214 | COUCD3 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
215 | COUCD4 | PIN_OUTCD | PIN_OUTCD | CHAR | 3 | 0 | Outcome code | * | |
216 | COUDE1 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
217 | COUDF1 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
218 | COUDR1 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
219 | COUMT1 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
220 | COUAT1 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
221 | COUDE2 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
222 | COUDF2 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
223 | COUDR2 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
224 | COUMT2 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
225 | COUAT2 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
226 | COUDE3 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
227 | COUDF3 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
228 | COUDR3 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
229 | COUMT3 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
230 | COUAT3 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
231 | COUDE4 | PIN_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
232 | COUDF4 | PIN_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
233 | COUDR4 | PIN_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
234 | COUMT4 | PIN_OUTMT | PIN_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
235 | COUAT4 | PIN_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
236 | CASNR | PIN_CASNR | TEXT20 | CHAR | 20 | 0 | Case Number for DA proceeding | ||
237 | AWAERS1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
238 | AWAERS2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
239 | AWAERS3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
240 | AWAERS4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
241 | BWAERS1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
242 | BWAERS2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
243 | BWAERS3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
244 | BWAERS4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
245 | CWAERS1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
246 | CWAERS2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
247 | CWAERS3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
248 | CWAERS4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
249 | FWAERS1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
250 | FWAERS2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
251 | FWAERS3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
252 | FWAERS4 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
253 | INVPR2 | PIN_INVPR | PERSNO | NUMC | 8 | 0 | Investigating officer's per no. | * | |
254 | INVPR3 | PIN_INVPR | PERSNO | NUMC | 8 | 0 | Investigating officer's per no. | * | |
255 | INVPR4 | PIN_INVPR | PERSNO | NUMC | 8 | 0 | Investigating officer's per no. | * | |
256 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P3743 | AWAERS1 | TCURC | WAERS | |||
2 | P3743 | AWAERS2 | TCURC | WAERS | |||
3 | P3743 | AWAERS3 | TCURC | WAERS | |||
4 | P3743 | AWAERS4 | TCURC | WAERS | |||
5 | P3743 | BWAERS1 | TCURC | WAERS | |||
6 | P3743 | BWAERS2 | TCURC | WAERS | |||
7 | P3743 | BWAERS3 | TCURC | WAERS | |||
8 | P3743 | BWAERS4 | TCURC | WAERS | |||
9 | P3743 | CWAERS1 | TCURC | WAERS | |||
10 | P3743 | CWAERS2 | TCURC | WAERS | |||
11 | P3743 | CWAERS3 | TCURC | WAERS | |||
12 | P3743 | CWAERS4 | TCURC | WAERS | |||
13 | P3743 | FWAERS1 | TCURC | WAERS | |||
14 | P3743 | FWAERS2 | TCURC | WAERS | |||
15 | P3743 | FWAERS3 | TCURC | WAERS | |||
16 | P3743 | FWAERS4 | TCURC | WAERS | |||
17 | P3743 | INFTY | T582A | INFTY | |||
18 | P3743 | PREAS | T530E | PREAS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 600 |