SAP PRELQ table - HR Query: Additional Fields details in SAP


SAP PRELQ table summary

Object Name: PRELQ
Dictionary Type: Structure
Description: HR Query: Additional Fields


Field list for PRELQ table on an S/4 SAP system

Details
PRELQ-ANSSATXT table field - Address Type

Description: Address Type
Field Name: ANSSATXT
Data Element: ANSSATXT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSSATXT

PRELQ-BANKINFO table field - Bank Information

Description: Bank Information
Field Name: BANKINFO
Data Element: BANKINFO
Data Type: CHAR
length (Dec): 79(0)
Check table:
Conversion Routine:
Domain Name: CHAR79
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BANKINFO

PRELQ-BKNAME09 table field - Bank Name Infotype 0009

Description: Bank Name Infotype 0009
Field Name: BKNAME09
Data Element: BKNAME09
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BKNAME09

PRELQ-BKNAME10 table field - Bank Name Infotype 0010

Description: Bank Name Infotype 0010
Field Name: BKNAME10
Data Element: BKNAME10
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BKNAME10

PRELQ-COUNTFLD table field - Counter Field

Description: Counter Field
Field Name: COUNTFLD
Data Element: COUNTFLD
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DEC5
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTFLD

PRELQ-EMBNK010 table field - Recipient Bank Data Infotype P0010

Description: Recipient Bank Data Infotype P0010
Field Name: EMBNK010
Data Element: EMBNK010
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMBNK010

PRELQ-EMFNA010 table field - Recipient Address Infotype P0010

Description: Recipient Address Infotype P0010
Field Name: EMFNA010
Data Element: EMFNA010
Data Type: CHAR
length (Dec): 66(0)
Check table:
Conversion Routine:
Domain Name: CHAR66
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMFNA010

PRELQ-FULLNAME table field - Title, First Name, Name Prefix, Last Name

Description: Title, First Name, Name Prefix, Last Name
Field Name: FULLNAME
Data Element: FULLNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLNAME

PRELQ-FULLNAM1 table field - Title, First Name, Last Name

Description: Title, First Name, Last Name
Field Name: FULLNAM1
Data Element: FULLNAM1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLNAM1

PRELQ-LEBALTER table field - Age of Employee (Not Numerical)

Description: Age of Employee (Not Numerical)
Field Name: LEBALTER
Data Element: LEBALTER
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEBALTER

PRELQ-MTGEBDAT table field - Day and Month of Date of Birth

Description: Day and Month of Date of Birth
Field Name: MTGEBDAT
Data Element: MTGEBDAT
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CHAR4
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTGEBDAT

PRELQ-TRFART08 table field - Pay Scale Type Text Infotype 0008

Description: Pay Scale Type Text Infotype 0008
Field Name: TRFART08
Data Element: TRFART08
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRFART08

PRELQ-TRFGEB08 table field - Pay Scale Area Text Infotype 0008

Description: Pay Scale Area Text Infotype 0008
Field Name: TRFGEB08
Data Element: TRFGEB08
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRFGEB08

PRELQ-URLBTEXT table field - Leave Name

Description: Leave Name
Field Name: URLBTEXT
Data Element: URLBTEXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field URLBTEXT

PRELQ-VTRAGSNR table field - Contract Number Designation

Description: Contract Number Designation
Field Name: VTRAGSNR
Data Element: VTRAGSNR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VTRAGSNR

PRELQ-ZLSTXT09 table field - Payment Key Text Infotype 0009

Description: Payment Key Text Infotype 0009
Field Name: ZLSTXT09
Data Element: DZLSTXT09
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZLSTXT09

PRELQ-ZAHLGWEG table field - Method of Payment Text

Description: Method of Payment Text
Field Name: ZAHLGWEG
Data Element: DZAHLGWEG
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZAHLGWEG

PRELQ-ANREDE02 table field - Form of Address Text Infotype 0002

Description: Form of Address Text Infotype 0002
Field Name: ANREDE02
Data Element: ANREDE02
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: ANREX
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANREDE02

PRELQ-LGTEXT08 table field - Wage Type Long Text Infotype 0008

Description: Wage Type Long Text Infotype 0008
Field Name: LGTEXT08
Data Element: LGTEXT08
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGTEXT08

PRELQ-LGTEXT10 table field - Wage Type Long Text Infotype 0010

Description: Wage Type Long Text Infotype 0010
Field Name: LGTEXT10
Data Element: LGTEXT10
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LGTEXT10

PRELQ-MANAGERN table field - Name of Supervisor (Organizational Assignment)

Description: Name of Supervisor (Organizational Assignment)
Field Name: MANAGERN
Data Element: MANAGER
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANAGERN

PRELQ-HIREDATE table field - Entry Date

Description: Entry Date
Field Name: HIREDATE
Data Element: HIREDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HIREDATE

PRELQ-FIREDATE table field - Leaving date

Description: Leaving date
Field Name: FIREDATE
Data Element: FIREDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIREDATE

PRELQ-GESAMT08 table field - Total of all wage type amounts

Description: Total of all wage type amounts
Field Name: GESAMT08
Data Element: SUMBB
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: P_AMT08V
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GESAMT08

PRELQ-WAERS08 table field - Currency Key

Description: Currency Key
Field Name: WAERS08
Data Element: WAERS
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAERS08

PRELQ-BEGD2001 table field - Start Date

Description: Start Date
Field Name: BEGD2001
Data Element: BEGDA
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BEGD2001

PRELQ-ENDD2001 table field - End Date

Description: End Date
Field Name: ENDD2001
Data Element: ENDDA
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENDD2001

PRELQ-NAMP0009 table field - Formatted Name of Employee or Applicant

Description: Formatted Name of Employee or Applicant
Field Name: NAMP0009
Data Element: EMNAM
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAMP0009

PRELQ-SNAM0009 table field - Employee's Name (Sortable by LAST NAME FIRST NAME)

Description: Employee's Name (Sortable by LAST NAME FIRST NAME)
Field Name: SNAM0009
Data Element: SMNAM
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAM0009

PRELQ-RFPERNAM table field - Name of reference employee

Description: Name of reference employee
Field Name: RFPERNAM
Data Element: RFPERNAM
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RFPERNAM

PRELQ-ORGEHTXT table field - Short Text of Organizational Unit

Description: Short Text of Organizational Unit
Field Name: ORGEHTXT
Data Element: ORGTX
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORGEHTXT

PRELQ-COMPNAME table field - Name of Company Code or Company

Description: Name of Company Code or Company
Field Name: COMPNAME
Data Element: BUTXT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: TEXT25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table