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