SAP ABAP Table PRELQ (HR Query: Additional Fields)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-IS (Application Component) HR Information Systems
     ⤷ PQU (Package) ABAP Query: Human Resources

Basic Data

Table Category	INTTAB	Structure
Structure	PRELQ	Table Relationship Diagram
Short Description	HR Query: Additional Fields

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	ANSSATXT	☐	ANSSATXT	TEXT40	CHAR	40	0	Address Type
2	BANKINFO	☐	BANKINFO	CHAR79	CHAR	79	0	Bank Information
3	BKNAME09	☐	BKNAME09	TEXT60	CHAR	60	0	Bank Name Infotype 0009
4	BKNAME10	☐	BKNAME10	TEXT60	CHAR	60	0	Bank Name Infotype 0010
5	COUNTFLD	☐	COUNTFLD	DEC5	DEC	5	0	Counter Field
6	EMBNK010	☐	EMBNK010	CHAR35	CHAR	35	0	Recipient Bank Data Infotype P0010
7	EMFNA010	☐	EMFNA010	CHAR66	CHAR	66	0	Recipient Address Infotype P0010
8	FULLNAME	☐	FULLNAME	TEXT30	CHAR	30	0	Title, First Name, Name Prefix, Last Name
9	FULLNAM1	☐	FULLNAM1	TEXT30	CHAR	30	0	Title, First Name, Last Name
10	LEBALTER	☐	LEBALTER	CHAR3	CHAR	3	0	Age of Employee (Not Numerical)
11	MTGEBDAT	☐	MTGEBDAT	CHAR4	CHAR	4	0	Day and Month of Date of Birth
12	TRFART08	☐	TRFART08	TEXT20	CHAR	20	0	Pay Scale Type Text Infotype 0008
13	TRFGEB08	☐	TRFGEB08	TEXT20	CHAR	20	0	Pay Scale Area Text Infotype 0008
14	URLBTEXT	☐	URLBTEXT	TEXT20	CHAR	20	0	Leave Name
15	VTRAGSNR	☐	VTRAGSNR	TEXT40	CHAR	40	0	Contract Number Designation
16	ZLSTXT09	☐	DZLSTXT09	TEXT50	CHAR	50	0	Payment Key Text Infotype 0009
17	ZAHLGWEG	☐	DZAHLGWEG	TEXT40	CHAR	40	0	Method of Payment Text
18	ANREDE02	☐	ANREDE02	ANREX	CHAR	5	0	Form of Address Text Infotype 0002
19	LGTEXT08	☐	LGTEXT08	TEXT25	CHAR	25	0	Wage Type Long Text Infotype 0008
20	LGTEXT10	☐	LGTEXT10	TEXT25	CHAR	25	0	Wage Type Long Text Infotype 0010
21	MANAGERN	☐	MANAGER	TEXT40	CHAR	40	0	Name of Supervisor (Organizational Assignment)
22	HIREDATE	☐	HIREDATE	DATUM	DATS	8	0	Entry Date
23	FIREDATE	☐	FIREDATE	DATUM	DATS	8	0	Leaving date
24	GESAMT08	☐	SUMBB	P_AMT08V	CURR	15	2	Total of all wage type amounts
25	WAERS08	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	BEGD2001	☐	BEGDA	DATUM	DATS	8	0	Start Date
27	ENDD2001	☐	ENDDA	DATUM	DATS	8	0	End Date
28	NAMP0009	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
29	SNAM0009	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
30	RFPERNAM	☐	RFPERNAM	TEXT40	CHAR	40	0	Name of reference employee
31	ORGEHTXT	☐	ORGTX	TEXT25	CHAR	25	0	Short Text of Organizational Unit
32	COMPNAME	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRELQ	WAERS08	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in