SAP PIQDB_DE_STPERSONAL table - Student Personal Details details in SAP

SAP PIQDB_DE_STPERSONAL table summary

Object Name: PIQDB_DE_STPERSONAL
Dictionary Type: Structure
Description: Student Personal Details

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

Details

PIQDB_DE_STPERSONAL-OTYPE table field - Object Type ▼

Description: Object Type
Field Name: OTYPE
Data Element: OTYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: OTYPE
MemoryID: POT
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OTYPE

PIQDB_DE_STPERSONAL-PLVAR table field - Plan Version ▼

Description: Plan Version
Field Name: PLVAR
Data Element: PLVAR
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: PLVAR
MemoryID: POP
AppClass: PP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLVAR

PIQDB_DE_STPERSONAL-OBJID table field - Object ID ▼

Description: Object ID
Field Name: OBJID
Data Element: HROBJID
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID: PON
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJID

PIQDB_DE_STPERSONAL-GESCH table field - Gender key ▼

Description: Gender key
Field Name: GESCH
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 GESCH

PIQDB_DE_STPERSONAL-GBDAT table field - Date of Birth ▼

Description: Date of Birth
Field Name: GBDAT
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 GBDAT

PIQDB_DE_STPERSONAL-NATIO table field - Nationality (Citizenship) ▼

Description: Nationality (Citizenship)
Field Name: NATIO
Data Element: PIQNATSL
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 NATIO

PIQDB_DE_STPERSONAL-NATIONALITY table field - DUEVO: Nationality ▼

Description: DUEVO: Nationality
Field Name: NATIONALITY
Data Element: DUSTA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DUSTA
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATIONALITY

PIQDB_DE_STPERSONAL-LANDD table field - DUEVO: Nationality ▼

Description: DUEVO: Nationality
Field Name: LANDD
Data Element: DUSTA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DUSTA
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LANDD

PIQDB_DE_STPERSONAL-VORNA table field - First Name ▼

Description: First Name
Field Name: VORNA
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 VORNA

PIQDB_DE_STPERSONAL-STUDENT_NAME table field - First Name of Student ▼

Description: First Name of Student
Field Name: STUDENT_NAME
Data Element: PIQ_DE_ST_NAME
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: TEXT4
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STUDENT_NAME

PIQDB_DE_STPERSONAL-NATI2 table field - Second Nationality (Citizenship) ▼

Description: Second Nationality (Citizenship)
Field Name: NATI2
Data Element: PIQNATS2
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 NATI2

PIQDB_DE_STPERSONAL-NATIONALITY_SECOND table field - DUEVO: Nationality ▼

Description: DUEVO: Nationality
Field Name: NATIONALITY_SECOND
Data Element: DUSTA
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DUSTA
MemoryID:
AppClass: PND
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATIONALITY_SECOND

PIQDB_DE_STPERSONAL-NACHN table field - Last Name ▼

Description: Last Name
Field Name: NACHN
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 NACHN

View list of all SAP tables(S4H/ECC)

Select data from SAP table