Table/Structure Field list used by SAP ABAP Program AQZZ==/SAPQUERY/HR_ASR (AQZZ==/SAPQUERY/HR_ASR)
SAP ABAP Program
AQZZ==/SAPQUERY/HR_ASR (AQZZ==/SAPQUERY/HR_ASR) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ALV_S_QINF - TEXT | Text (80 Characters) | ||
| 2 | ALV_S_QINF - TYPE | Character Field Length 1 | ||
| 3 | ALV_S_QINF - VALUE | Text (80 Characters) | ||
| 4 | DD07D - DDTEXT | Short Text for Fixed Values | ||
| 5 | FAGL_SEGMT - NAME | Text Field | ||
| 6 | GMGRTEXTS - DESCRIPTION | Descriptive Text | ||
| 7 | HRCA_COMPANY - COMP_NAME | Name of Company Code or Company | ||
| 8 | HRCA_COSTC - NAME | General Name | ||
| 9 | LVC_S_QINF - TEXT | Text (80 Characters) | ||
| 10 | LVC_S_QINF - TYPE | Character Field Length 1 | ||
| 11 | LVC_S_QINF - VALUE | Text (80 Characters) | ||
| 12 | P0000 - MASSG | Reason for Action | ||
| 13 | P0000 - MASSN | Action Type | ||
| 14 | P0000 - PERNR | Personnel Number | ||
| 15 | P0000 - STAT1 | Customer-Specific Status | ||
| 16 | P0000 - STAT2 | Employment Status | ||
| 17 | P0000 - STAT3 | Special Payment Status | ||
| 18 | P0000_AF - FIREDATE | Leaving date | ||
| 19 | P0000_AF - HIREDATE | Entry Date | ||
| 20 | P0000_AF - NODYS | Length of Service (Number of Days) | ||
| 21 | P0000_AF - NOMNS | Employment Period (Number of Months) | ||
| 22 | P0000_AF - NOYRS | Length of Employment Period (Number of Years) | ||
| 23 | P0000_AF - RECRUIT | Recruited - (Equity) | ||
| 24 | P0000_AF - TECAT | Termination Reason | ||
| 25 | P0000_AF - TERMINATION | Terminated - (Equity) | ||
| 26 | P0001 - ABKRS | Payroll Area | ||
| 27 | P0001 - ANSVH | Work Contract | ||
| 28 | P0001 - BTRTL | Personnel Subarea | ||
| 29 | P0001 - BUKRS | Company Code | ||
| 30 | P0001 - ENAME | Formatted Name of Employee or Applicant | ||
| 31 | P0001 - FISTL | Funds Center | ||
| 32 | P0001 - FKBER | Functional Area | ||
| 33 | P0001 - GEBER | Fund | ||
| 34 | P0001 - GRANT_NBR | Grant | ||
| 35 | P0001 - GSBER | Business Area | ||
| 36 | P0001 - JUPER | Legal Person | ||
| 37 | P0001 - KOKRS | Controlling Area | ||
| 38 | P0001 - KOSTL | Cost Center | ||
| 39 | P0001 - MSTBR | Supervisor Area | ||
| 40 | P0001 - ORGEH | Organizational Unit | ||
| 41 | P0001 - OTYPE | Object Type | ||
| 42 | P0001 - PERSG | Employee Group | ||
| 43 | P0001 - PERSK | Employee Subgroup | ||
| 44 | P0001 - PLANS | Position | ||
| 45 | P0001 - SACHA | Payroll Administrator | ||
| 46 | P0001 - SACHP | Administrator for HR Master Data | ||
| 47 | P0001 - SACHZ | Administrator for Time Recording | ||
| 48 | P0001 - SBMOD | Administrator Group | ||
| 49 | P0001 - SGMNT | Segment for Segmental Reporting | ||
| 50 | P0001 - SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
| 51 | P0001 - STELL | Job | ||
| 52 | P0001 - VDSK1 | Organizational Key | ||
| 53 | P0001 - WERKS | Personnel Area | ||
| 54 | P0001_AF - BMARK | Benchmark job | ||
| 55 | P0001_AF - CC_RESPN | Person Responsible | ||
| 56 | P0001_AF - DTYSN | Duty Station | ||
| 57 | P0001_AF - EVGRD | Evaluation Group | ||
| 58 | P0001_AF - EVPTS | Evaluation points | ||
| 59 | P0001_AF - EVSUB | Evaluation method | ||
| 60 | P0001_AF - JCODE | Job from survey | ||
| 61 | P0001_AF - MABAS | Average Survey Salary | ||
| 62 | P0001_AF - MAB_FR | Unit of Time for Compensation | ||
| 63 | P0001_AF - MAB_WS | Currency Key | ||
| 64 | P0001_AF - MANAGERN | Name of Supervisor (Organizational Assignment) | ||
| 65 | P0001_AF - OCCAT | Occupational Category Employment Equity | ||
| 66 | P0001_AF - OCCTM | Staffing duration for current position (years) | ||
| 67 | P0001_AF - OCCTM_YM | Staffing duration for current position (years/months) | ||
| 68 | P0001_AF - OMNGR_NA | Name of Manager (Using Org. Structure) | ||
| 69 | P0001_AF - OMNGR_NR | Personnel number of superior (Org. Management) | ||
| 70 | P0001_AF - OPERNR | Personnel number | ||
| 71 | P0001_AF - PL_BUILD | Building | ||
| 72 | P0001_AF - PL_CITY | City | ||
| 73 | P0001_AF - PL_CTRY | Country | ||
| 74 | P0001_AF - PL_PSTLZ | Postal Code | ||
| 75 | P0001_AF - SOCCD | Reserved field/unused field of length 4 | ||
| 76 | P0001_AF - SOCCL | Standard Occupational Category Code (South Africa) | ||
| 77 | P0001_AF - SVSUB | Salary Survey | ||
| 78 | P0002 - ANRED | Form-of-Address Key | ||
| 79 | P0002 - ANZKD | Number of Children | ||
| 80 | P0002 - CNAME | Complete Name | ||
| 81 | P0002 - FAMDT | Valid From Date of Current Marital Status | ||
| 82 | P0002 - FAMST | Marital Status Key | ||
| 83 | P0002 - FNAMK | First name (Katakana) | ||
| 84 | P0002 - FNAMR | First Name (Romaji) | ||
| 85 | P0002 - GBDAT | Date of Birth | ||
| 86 | P0002 - GBDEP | State | ||
| 87 | P0002 - GBJHR | Year of Birth | ||
| 88 | P0002 - GBLND | Country of Birth | ||
| 89 | P0002 - GBMON | Month of Birth | ||
| 90 | P0002 - GBORT | Birthplace | ||
| 91 | P0002 - GBPAS | Date of Birth According to Passport | ||
| 92 | P0002 - GBTAG | Birth Date (to Month/Year) | ||
| 93 | P0002 - GESCH | Gender Key | ||
| 94 | P0002 - INITS | Initials | ||
| 95 | P0002 - KNZNM | Name Format Indicator for Employee in a List | ||
| 96 | P0002 - KONFE | Religious Denomination Key | ||
| 97 | P0002 - LNAMK | Last name (Katakana) | ||
| 98 | P0002 - LNAMR | Last Name (Romaji) | ||
| 99 | P0002 - MIDNM | Middle Name | ||
| 100 | P0002 - NABIK | Name of Birth (Katakana) | ||
| 101 | P0002 - NABIR | Name of Birth (Romaji) | ||
| 102 | P0002 - NACH2 | Second Name | ||
| 103 | P0002 - NACHN | Last Name | ||
| 104 | P0002 - NACON | Name Connection | ||
| 105 | P0002 - NAME2 | Name at Birth | ||
| 106 | P0002 - NAMZ2 | Name Affix for Name at Birth | ||
| 107 | P0002 - NAMZU | Other Title | ||
| 108 | P0002 - NATI2 | Second Nationality | ||
| 109 | P0002 - NATI3 | Third Nationality | ||
| 110 | P0002 - NATIO | Nationality | ||
| 111 | P0002 - NCHMC | Last Name (Field for Search Help) | ||
| 112 | P0002 - NICKK | Koseki (Katakana) | ||
| 113 | P0002 - NICKR | Koseki (Romaji) | ||
| 114 | P0002 - PERID | Personnel ID Number | ||
| 115 | P0002 - PERMO | Modifier for Personnel Identifier | ||
| 116 | P0002 - RUFNM | Nickname | ||
| 117 | P0002 - SPRSL | Communication Language | ||
| 118 | P0002 - TITEL | Title | ||
| 119 | P0002 - TITL2 | Second Title | ||
| 120 | P0002 - VNAMC | First Name (Field for Search Help) | ||
| 121 | P0002 - VORNA | First Name | ||
| 122 | P0002 - VORS2 | Second Name Prefix | ||
| 123 | P0002 - VORSW | Name Prefix | ||
| 124 | P0002_AF - EMPL_AGE | Age of Employee | ||
| 125 | P0002_AF - LEBALTER | Age of Employee (Not Numerical) | ||
| 126 | P0002_AF - MTGEBDAT | Day and Month of Date of Birth | ||
| 127 | P0006 - ADR03 | Street 2 | ||
| 128 | P0006 - ADR04 | Street 3 | ||
| 129 | P0006 - ANSSA | Address Record Type | ||
| 130 | P0006 - BLDNG | Building (number or code) | ||
| 131 | P0006 - BUSRT | Bus Route | ||
| 132 | P0006 - COM01 | Communication Type | ||
| 133 | P0006 - CONKK | Contact Person (Katakana) (Japan) | ||
| 134 | P0006 - COUNC | County Code | ||
| 135 | P0006 - ENTK2 | Distance in Kilometers | ||
| 136 | P0006 - ENTKM | Distance in Kilometers | ||
| 137 | P0006 - FLOOR | Floor in building | ||
| 138 | P0006 - HSNMR | House Number | ||
| 139 | P0006 - INDRL | Indicator for relationship (specification code) | ||
| 140 | P0006 - LAND1 | Country Key | ||
| 141 | P0006 - LOCAT | 2nd address line | ||
| 142 | P0006 - NAME2 | Contact Name | ||
| 143 | P0006 - NUM01 | Communication Number | ||
| 144 | P0006 - OR1KK | First address line (Katakana) | ||
| 145 | P0006 - OR2KK | Second address line (Katakana) | ||
| 146 | P0006 - ORT01 | City | ||
| 147 | P0006 - ORT02 | District | ||
| 148 | P0006 - POSTA | Identification of an apartment in a building | ||
| 149 | P0006 - PSTLZ | Postal Code | ||
| 150 | P0006 - RAILW | Social Subscription Railway | ||
| 151 | P0006 - RCTVC | Municipal city code | ||
| 152 | P0006 - STATE | Region (State, Province, County) | ||
| 153 | P0006 - STRAS | Street and House Number | ||
| 154 | P0006 - STRDS | Street Abbreviation | ||
| 155 | P0006 - TELNR | Telephone Number | ||
| 156 | P0006 - WKWNG | Company Housing | ||
| 157 | P0709 - PERSONID_EXT | External Person ID | ||
| 158 | P1000 - STEXT | Object Name | ||
| 159 | PA0001 - ENAME | Formatted Name of Employee or Applicant | ||
| 160 | PS0000 - MASSG | Reason for Action | ||
| 161 | PS0000 - MASSN | Action Type | ||
| 162 | PS0000 - STAT1 | Customer-Specific Status | ||
| 163 | PS0000 - STAT2 | Employment Status | ||
| 164 | PS0000 - STAT3 | Special Payment Status | ||
| 165 | PS0001 - ABKRS | Payroll Area | ||
| 166 | PS0001 - ANSVH | Work Contract | ||
| 167 | PS0001 - BTRTL | Personnel Subarea | ||
| 168 | PS0001 - BUKRS | Company Code | ||
| 169 | PS0001 - ENAME | Formatted Name of Employee or Applicant | ||
| 170 | PS0001 - FISTL | Funds Center | ||
| 171 | PS0001 - FKBER | Functional Area | ||
| 172 | PS0001 - GEBER | Fund | ||
| 173 | PS0001 - GRANT_NBR | Grant | ||
| 174 | PS0001 - GSBER | Business Area | ||
| 175 | PS0001 - JUPER | Legal Person | ||
| 176 | PS0001 - KOKRS | Controlling Area | ||
| 177 | PS0001 - KOSTL | Cost Center | ||
| 178 | PS0001 - MSTBR | Supervisor Area | ||
| 179 | PS0001 - ORGEH | Organizational Unit | ||
| 180 | PS0001 - OTYPE | Object Type | ||
| 181 | PS0001 - PERSG | Employee Group | ||
| 182 | PS0001 - PERSK | Employee Subgroup | ||
| 183 | PS0001 - PLANS | Position | ||
| 184 | PS0001 - SACHA | Payroll Administrator | ||
| 185 | PS0001 - SACHP | Administrator for HR Master Data | ||
| 186 | PS0001 - SACHZ | Administrator for Time Recording | ||
| 187 | PS0001 - SBMOD | Administrator Group | ||
| 188 | PS0001 - SGMNT | Segment for Segmental Reporting | ||
| 189 | PS0001 - SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
| 190 | PS0001 - STELL | Job | ||
| 191 | PS0001 - VDSK1 | Organizational Key | ||
| 192 | PS0001 - WERKS | Personnel Area | ||
| 193 | PS0001_SAP - ABKRS | Payroll Area | ||
| 194 | PS0001_SAP - ANSVH | Work Contract | ||
| 195 | PS0001_SAP - BTRTL | Personnel Subarea | ||
| 196 | PS0001_SAP - BUKRS | Company Code | ||
| 197 | PS0001_SAP - ENAME | Formatted Name of Employee or Applicant | ||
| 198 | PS0001_SAP - FISTL | Funds Center | ||
| 199 | PS0001_SAP - FKBER | Functional Area | ||
| 200 | PS0001_SAP - GEBER | Fund | ||
| 201 | PS0001_SAP - GRANT_NBR | Grant | ||
| 202 | PS0001_SAP - GSBER | Business Area | ||
| 203 | PS0001_SAP - JUPER | Legal Person | ||
| 204 | PS0001_SAP - KOKRS | Controlling Area | ||
| 205 | PS0001_SAP - KOSTL | Cost Center | ||
| 206 | PS0001_SAP - MSTBR | Supervisor Area | ||
| 207 | PS0001_SAP - ORGEH | Organizational Unit | ||
| 208 | PS0001_SAP - OTYPE | Object Type | ||
| 209 | PS0001_SAP - PERSG | Employee Group | ||
| 210 | PS0001_SAP - PERSK | Employee Subgroup | ||
| 211 | PS0001_SAP - PLANS | Position | ||
| 212 | PS0001_SAP - SACHA | Payroll Administrator | ||
| 213 | PS0001_SAP - SACHP | Administrator for HR Master Data | ||
| 214 | PS0001_SAP - SACHZ | Administrator for Time Recording | ||
| 215 | PS0001_SAP - SBMOD | Administrator Group | ||
| 216 | PS0001_SAP - SGMNT | Segment for Segmental Reporting | ||
| 217 | PS0001_SAP - SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
| 218 | PS0001_SAP - STELL | Job | ||
| 219 | PS0001_SAP - VDSK1 | Organizational Key | ||
| 220 | PS0001_SAP - WERKS | Personnel Area | ||
| 221 | PS0002 - ANRED | Form-of-Address Key | ||
| 222 | PS0002 - ANZKD | Number of Children | ||
| 223 | PS0002 - CNAME | Complete Name | ||
| 224 | PS0002 - FAMDT | Valid From Date of Current Marital Status | ||
| 225 | PS0002 - FAMST | Marital Status Key | ||
| 226 | PS0002 - FNAMK | First name (Katakana) | ||
| 227 | PS0002 - FNAMR | First Name (Romaji) | ||
| 228 | PS0002 - GBDAT | Date of Birth | ||
| 229 | PS0002 - GBDEP | State | ||
| 230 | PS0002 - GBJHR | Year of Birth | ||
| 231 | PS0002 - GBLND | Country of Birth | ||
| 232 | PS0002 - GBMON | Month of Birth | ||
| 233 | PS0002 - GBORT | Birthplace | ||
| 234 | PS0002 - GBPAS | Date of Birth According to Passport | ||
| 235 | PS0002 - GBTAG | Birth Date (to Month/Year) | ||
| 236 | PS0002 - GESCH | Gender Key | ||
| 237 | PS0002 - INITS | Initials | ||
| 238 | PS0002 - KNZNM | Name Format Indicator for Employee in a List | ||
| 239 | PS0002 - KONFE | Religious Denomination Key | ||
| 240 | PS0002 - LNAMK | Last name (Katakana) | ||
| 241 | PS0002 - LNAMR | Last Name (Romaji) | ||
| 242 | PS0002 - MIDNM | Middle Name | ||
| 243 | PS0002 - NABIK | Name of Birth (Katakana) | ||
| 244 | PS0002 - NABIR | Name of Birth (Romaji) | ||
| 245 | PS0002 - NACH2 | Second Name | ||
| 246 | PS0002 - NACHN | Last Name | ||
| 247 | PS0002 - NACON | Name Connection | ||
| 248 | PS0002 - NAME2 | Name at Birth | ||
| 249 | PS0002 - NAMZ2 | Name Affix for Name at Birth | ||
| 250 | PS0002 - NAMZU | Other Title | ||
| 251 | PS0002 - NATI2 | Second Nationality | ||
| 252 | PS0002 - NATI3 | Third Nationality | ||
| 253 | PS0002 - NATIO | Nationality | ||
| 254 | PS0002 - NCHMC | Last Name (Field for Search Help) | ||
| 255 | PS0002 - NICKK | Koseki (Katakana) | ||
| 256 | PS0002 - NICKR | Koseki (Romaji) | ||
| 257 | PS0002 - PERID | Personnel ID Number | ||
| 258 | PS0002 - PERMO | Modifier for Personnel Identifier | ||
| 259 | PS0002 - RUFNM | Nickname | ||
| 260 | PS0002 - SPRSL | Communication Language | ||
| 261 | PS0002 - TITEL | Title | ||
| 262 | PS0002 - TITL2 | Second Title | ||
| 263 | PS0002 - VNAMC | First Name (Field for Search Help) | ||
| 264 | PS0002 - VORNA | First Name | ||
| 265 | PS0002 - VORS2 | Second Name Prefix | ||
| 266 | PS0002 - VORSW | Name Prefix | ||
| 267 | PS0006 - ADR03 | Street 2 | ||
| 268 | PS0006 - ADR04 | Street 3 | ||
| 269 | PS0006 - ANSSA | Address Record Type | ||
| 270 | PS0006 - BLDNG | Building (number or code) | ||
| 271 | PS0006 - BUSRT | Bus Route | ||
| 272 | PS0006 - COM01 | Communication Type | ||
| 273 | PS0006 - CONKK | Contact Person (Katakana) (Japan) | ||
| 274 | PS0006 - COUNC | County Code | ||
| 275 | PS0006 - ENTK2 | Distance in Kilometers | ||
| 276 | PS0006 - ENTKM | Distance in Kilometers | ||
| 277 | PS0006 - FLOOR | Floor in building | ||
| 278 | PS0006 - HSNMR | House Number | ||
| 279 | PS0006 - INDRL | Indicator for relationship (specification code) | ||
| 280 | PS0006 - LAND1 | Country Key | ||
| 281 | PS0006 - LOCAT | 2nd address line | ||
| 282 | PS0006 - NAME2 | Contact Name | ||
| 283 | PS0006 - NUM01 | Communication Number | ||
| 284 | PS0006 - OR1KK | First address line (Katakana) | ||
| 285 | PS0006 - OR2KK | Second address line (Katakana) | ||
| 286 | PS0006 - ORT01 | City | ||
| 287 | PS0006 - ORT02 | District | ||
| 288 | PS0006 - POSTA | Identification of an apartment in a building | ||
| 289 | PS0006 - PSTLZ | Postal Code | ||
| 290 | PS0006 - RAILW | Social Subscription Railway | ||
| 291 | PS0006 - RCTVC | Municipal city code | ||
| 292 | PS0006 - STATE | Region (State, Province, County) | ||
| 293 | PS0006 - STRAS | Street and House Number | ||
| 294 | PS0006 - STRDS | Street Abbreviation | ||
| 295 | PS0006 - TELNR | Telephone Number | ||
| 296 | PS0006 - WKWNG | Company Housing | ||
| 297 | PS0709 - PERSONID_EXT | External Person ID | ||
| 298 | PSHDR - PERNR | Personnel Number | ||
| 299 | PSKEY - PERNR | Personnel Number | ||
| 300 | T001P - BTEXT | Personnel Subarea Text | ||
| 301 | T002T - SPTXT | Name of Language | ||
| 302 | T005F - BEZEI | Description | ||
| 303 | T005T - LANDX50 | Country Name (Max. 50 Characters) | ||
| 304 | T005T - NATIO | Nationality | ||
| 305 | T005U - BEZEI | Description | ||
| 306 | T500P - NAME1 | Personnel Area Text | ||
| 307 | T501T - PTEXT | Name of Employee Group | ||
| 308 | T502T - FTEXT | Marital Status | ||
| 309 | T503T - PTEXT | Name of Employee Subgroup | ||
| 310 | T516T - KTEXT | Religious Denomination Long Text | ||
| 311 | T522T - ANRLT | Long Text: Form of Address | ||
| 312 | T526 - SACHN | Name of administrator | ||
| 313 | T527O - TEXT2 | Name of organizational element | ||
| 314 | T529T - MNTXT | Name of Action Type | ||
| 315 | T529U - TEXT1 | Text, 40 Characters Long | ||
| 316 | T530T - MGTXT | Name of reason for action | ||
| 317 | T535N - TTOUT | Output text for name affix | ||
| 318 | T542T - ATX | Work Contract Text | ||
| 319 | T549T - ATEXT | Payroll Area Text | ||
| 320 | T577S - ATEXT | Text (20 Characters) | ||
| 321 | T591S - STEXT | Name of Subtype | ||
| 322 | T5EVP - VIAPT | Meaning of street abbreviation | ||
| 323 | T5J63 - CTXKJ | Municipal City Code Text (Kanji) | ||
| 324 | T5W17T - SOCTX | Standard Occupational Category Code Text | ||
| 325 | T710FT - FQTXT | Text (20 Characters) | ||
| 326 | T710GT - LTEXT | Text (30 Characters) | ||
| 327 | T710ST - LTEXT | Title of Job from Survey | ||
| 328 | T777A - ORT01 | City | ||
| 329 | T777O - OTEXT | Object Type Text | ||
| 330 | T777U - SUTXT | Subtype Text | ||
| 331 | TCURT - LTEXT | Long Text | ||
| 332 | TFKBT - FKBTX | Name of the functional area | ||
| 333 | TGSBT - GTEXT | Business area description | ||
| 334 | TKA01 - BEZEI | Name of the controlling area |