SAP Table PRELQ
HR Query: Additional Fields
PRELQ (HR Query: Additional Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PRELQ to other SAP tables.
PRELQ table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| ANSSATXT | Address Type | ANSSATXT | CHAR | 40 | 0 | |||
| BANKINFO | Bank Information | BANKINFO | CHAR | 79 | 0 | |||
| BKNAME09 | Bank Name Infotype 0009 | BKNAME09 | CHAR | 60 | 0 | |||
| BKNAME10 | Bank Name Infotype 0010 | BKNAME10 | CHAR | 60 | 0 | |||
| COUNTFLD | Counter Field | COUNTFLD | DEC | 5 | 0 | |||
| EMBNK010 | Recipient Bank Data Infotype P0010 | EMBNK010 | CHAR | 35 | 0 | |||
| EMFNA010 | Recipient Address Infotype P0010 | EMFNA010 | CHAR | 66 | 0 | |||
| FULLNAME | Title, First Name, Name Prefix, Last Name | FULLNAME | CHAR | 30 | 0 | |||
| FULLNAM1 | Title, First Name, Last Name | FULLNAM1 | CHAR | 30 | 0 | |||
| LEBALTER | Age of Employee (Not Numerical) | LEBALTER | CHAR | 3 | 0 | |||
| MTGEBDAT | Day and Month of Date of Birth | MTGEBDAT | CHAR | 4 | 0 | |||
| TRFART08 | Pay Scale Type Text Infotype 0008 | TRFART08 | CHAR | 20 | 0 | |||
| TRFGEB08 | Pay Scale Area Text Infotype 0008 | TRFGEB08 | CHAR | 20 | 0 | |||
| URLBTEXT | Leave Name | URLBTEXT | CHAR | 20 | 0 | |||
| VTRAGSNR | Contract Number Designation | VTRAGSNR | CHAR | 40 | 0 | |||
| ZLSTXT09 | Payment Key Text Infotype 0009 | DZLSTXT09 | CHAR | 50 | 0 | |||
| ZAHLGWEG | Method of Payment Text | DZAHLGWEG | CHAR | 40 | 0 | |||
| ANREDE02 | Form of Address Text Infotype 0002 | ANREDE02 | CHAR | 5 | 0 | |||
| LGTEXT08 | Wage Type Long Text Infotype 0008 | LGTEXT08 | CHAR | 25 | 0 | |||
| LGTEXT10 | Wage Type Long Text Infotype 0010 | LGTEXT10 | CHAR | 25 | 0 | |||
| MANAGERN | Name of Supervisor (Organizational Assignment) | MANAGER | CHAR | 40 | 0 | |||
| HIREDATE | Entry Date | HIREDATE | DATS | 8 | 0 | |||
| FIREDATE | Leaving date | FIREDATE | DATS | 8 | 0 | |||
| GESAMT08 | Total of all wage type amounts | SUMBB | CURR | 15 | 2 | |||
| WAERS08 | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| BEGD2001 | Start Date | BEGDA | DATS | 8 | 0 | |||
| ENDD2001 | End Date | ENDDA | DATS | 8 | 0 | |||
| NAMP0009 | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | 0 | |||
| SNAM0009 | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30 | 0 | |||
| RFPERNAM | Name of reference employee | RFPERNAM | CHAR | 40 | 0 | |||
| ORGEHTXT | Short Text of Organizational Unit | ORGTX | CHAR | 25 | 0 | |||
| COMPNAME | Name of Company Code or Company | BUTXT | CHAR | 25 | 0 | |||
