SAP PIQ_STUDENT_INFORMATION table - Student Information including Basic, Communication,Visa details in SAP

SAP PIQ_STUDENT_INFORMATION table summary

Object Name: PIQ_STUDENT_INFORMATION
Dictionary Type: Structure
Description: Student Information including Basic, Communication,Visa

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

Details

PIQ_STUDENT_INFORMATION-STUDENT_NUMBER table field - Student Number ▼

Description: Student Number
Field Name: STUDENT_NUMBER
Data Element: PIQSTUDENT12
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine: PIQST
Domain Name: PIQSTUDENT12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: PIQST

See all SAP tables containing field STUDENT_NUMBER

PIQ_STUDENT_INFORMATION-STUDENT_OBJID table field - Object ID of Student ▼

Description: Object ID of Student
Field Name: STUDENT_OBJID
Data Element: PIQST_OBJID
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID: STUDENT
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STUDENT_OBJID

PIQ_STUDENT_INFORMATION-FIRST_NAME table field - First Name ▼

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

PIQ_STUDENT_INFORMATION-MIDDLE_NAME table field - Middle 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

PIQ_STUDENT_INFORMATION-LAST_NAME table field - Last 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

PIQ_STUDENT_INFORMATION-PROGRAM_OF_STUDY table field - Program ID ▼

Description: Program ID
Field Name: PROGRAM_OF_STUDY
Data Element: PIQSCOBJID
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 PROGRAM_OF_STUDY

PIQ_STUDENT_INFORMATION-PROGRAM_OF_STUDY_DESC table field - Program Description ▼

Description: Program Description
Field Name: PROGRAM_OF_STUDY_DESC
Data Element: PIQSCTXT
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 PROGRAM_OF_STUDY_DESC

PIQ_STUDENT_INFORMATION-ACADEMIC_YEAR table field - Academic Year ▼

Description: Academic Year
Field Name: ACADEMIC_YEAR
Data Element: PIQPERYR
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: PIQPERYR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACADEMIC_YEAR

PIQ_STUDENT_INFORMATION-ACADEMIC_SESS table field - Academic Session ▼

Description: Academic Session
Field Name: ACADEMIC_SESS
Data Element: PIQPERID
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: PIQPERID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACADEMIC_SESS

PIQ_STUDENT_INFORMATION-ACADEMIC_YEAR_DESC table field - Academic Year (Description) ▼

Description: Academic Year (Description)
Field Name: ACADEMIC_YEAR_DESC
Data Element: PIQPERYT
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 ACADEMIC_YEAR_DESC

PIQ_STUDENT_INFORMATION-ACADEMIC_SESS_DESC table field - Academic Session (Description) ▼

Description: Academic Session (Description)
Field Name: ACADEMIC_SESS_DESC
Data Element: PIQPERIT
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 ACADEMIC_SESS_DESC

PIQ_STUDENT_INFORMATION-STAGE table field - Stage (Description) ▼

Description: Stage (Description)
Field Name: STAGE
Data Element: PIQLEVELT
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 STAGE

PIQ_STUDENT_INFORMATION-REGISTRATION_TYPE table field - Registration Type (Description) ▼

Description: Registration Type (Description)
Field Name: REGISTRATION_TYPE
Data Element: PIQENRCATEGT
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 REGISTRATION_TYPE

PIQ_STUDENT_INFORMATION-DEPARTMENT table field - Name of the Student's Organizational Unit ▼

Description: Name of the Student's Organizational Unit
Field Name: DEPARTMENT
Data Element: PIQSTORGTX
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 DEPARTMENT

PIQ_STUDENT_INFORMATION-PHOTO_URI table field - ▼

Description:
Field Name: PHOTO_URI
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHOTO_URI

PIQ_STUDENT_INFORMATION-DATE_OF_BIRTH table field - ▼

Description:
Field Name: DATE_OF_BIRTH
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_OF_BIRTH

PIQ_STUDENT_INFORMATION-NATIONALITY table field - Nationality ▼

Description: Nationality
Field Name: NATIONALITY
Data Element: NATIO
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TEXT15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATIONALITY

PIQ_STUDENT_INFORMATION-MOBILE table field - First Cell Phone Number: Dialing Code + Number ▼

Description: First Cell Phone Number: Dialing Code + Number
Field Name: MOBILE
Data Element: AD_MBNMBR1
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 MOBILE

PIQ_STUDENT_INFORMATION-EMAIL table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: EMAIL
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field EMAIL

PIQ_STUDENT_INFORMATION-STUDENT_NAME table field - ▼

Description:
Field Name: STUDENT_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STUDENT_NAME

PIQ_STUDENT_INFORMATION-STATUS1_TXT table field - Status Long Text ▼

Description: Status Long Text
Field Name: STATUS1_TXT
Data Element: PIQHS_STATUST
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 STATUS1_TXT

PIQ_STUDENT_INFORMATION-STATUS2_TXT table field - Status Long Text ▼

Description: Status Long Text
Field Name: STATUS2_TXT
Data Element: PIQHS_STATUST
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 STATUS2_TXT

PIQ_STUDENT_INFORMATION-RETURN_MESSAGE table field - Message Text ▼

Description: Message Text
Field Name: RETURN_MESSAGE
Data Element: BAPI_MSG
Data Type: CHAR
length (Dec): 220(0)
Check table:
Conversion Routine:
Domain Name: TEXT220
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RETURN_MESSAGE

View list of all SAP tables(S4H/ECC)

Select data from SAP table