SAP PIQAPP_PERSONAL table - Application: Personal Data details in SAP

Description: First Name
Field Name: FIRST_NAME
Data Element: PAD_VORNA
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_VORNM
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRST_NAME

Description: Last Name
Field Name: LAST_NAME
Data Element: PAD_NACHN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_NACHN
MemoryID:
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_NAME

Description: Middle Name
Field Name: MIDDLE_NAME
Data Element: PAD_MIDNM
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_VORNM
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIDDLE_NAME

Description: Known As
Field Name: NICKNAME
Data Element: PIQ_RUFNM
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_VORNM
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NICKNAME

Description: Initials
Field Name: INITIALS
Data Element: INITS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INITIALS

Description: Name Prefix
Field Name: NAME_AFFIX
Data Element: VORSW
Data Type: CHAR
length (Dec): 15(0)
Check table: T535N
Conversion Routine:
Domain Name: TITEL
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_AFFIX

Description: Other Title
Field Name: ARISTOCRATIC_TITLE
Data Element: NAMZU
Data Type: CHAR
length (Dec): 15(0)
Check table: T535N
Conversion Routine:
Domain Name: TITEL
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARISTOCRATIC_TITLE

Description: Title
Field Name: TITEL
Data Element: TITEL
Data Type: CHAR
length (Dec): 15(0)
Check table: T535N
Conversion Routine:
Domain Name: TITEL
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TITEL

Description: Form-of-Address Key
Field Name: FORM_OF_ADDRESS_KEY
Data Element: ANRDE
Data Type: CHAR
length (Dec): 1(0)
Check table: T522G
Conversion Routine:
Domain Name: ANRDE
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORM_OF_ADDRESS_KEY

Description: Name at Birth
Field Name: NAME_AT_BIRTH
Data Element: PAD_NAME2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_NACHN
MemoryID:
AppClass: PINF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_AT_BIRTH

Description: Date of Birth
Field Name: DATE_BIRTH
Data Element: PIQ_GBDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine: PDATE
Domain Name: GBDAT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit: PDATE

See all SAP tables containing field DATE_BIRTH

Description: Country/Region of Birth
Field Name: COUNTRY_OF_BIRTH
Data Element: GBLND
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY_OF_BIRTH

Description: Region of Birth (State, Province, County)
Field Name: REGION_OF_BIRTH
Data Element: PIQ_GBDEP
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION_OF_BIRTH

Description: Birthplace
Field Name: BIRTHPLACE
Data Element: PAD_GBORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PAD_ORT01
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTHPLACE

Description: Nationality (Citizenship) at Birth
Field Name: NATIONALITY_AT_BIRTH
Data Element: PIQ_GBNAT
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATIONALITY_AT_BIRTH

Description: Nationality
Field Name: NATIONALITY
Data Element: NATSL
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID: NAT
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATIONALITY

Description: Second Nationality
Field Name: SECOND_NATIONALITY
Data Element: NATS2
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECOND_NATIONALITY

Description: Third Nationality
Field Name: THIRD_NATIONALITY
Data Element: NATS3
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field THIRD_NATIONALITY

Description: Language of Communication
Field Name: CORRESP_LANGUAGE
Data Element: PIQ_SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: T002
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field CORRESP_LANGUAGE

Description: Identification Number
Field Name: PERSIDNO
Data Element: PIQ_PRDNI
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSIDNO

Description: Gender key
Field Name: GENDER_KEY
Data Element: AD_SEX
Data Type: CHAR
length (Dec): 1(0)
Check table: TSAD15
Conversion Routine:
Domain Name: AD_SEX
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GENDER_KEY

Description: Marital Status Key
Field Name: MARITAL_STATUS
Data Element: FAMST
Data Type: CHAR
length (Dec): 1(0)
Check table: T502T
Conversion Routine:
Domain Name: FAMST
MemoryID:
AppClass: PSTA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MARITAL_STATUS