PIQSTREG SAP (Student: Registrations) Structure details

Dictionary Type: Structure
Description: Student: Registrations




ABAP Code to SELECT data from PIQSTREG
Related tables to PIQSTREG
Access table PIQSTREG




Structure field list including key, data, relationships and ABAP select examples

PIQSTREG is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Student: Registrations" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PIQSTREG TYPE PIQSTREG.

The PIQSTREG table consists of various fields, each holding specific information or linking keys about Student: Registrations data available in SAP. These include ST_OBJID (Object ID of Student), CS_OBJID (Object ID of Study Object (CS)), SC_OBJID (Program ID), CS_PRIOX (Program Priority (In Period)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP PIQSTREG structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ST_OBJIDObject ID of Student PIQSTUDENTNUMC8Assigned to domainHROBJIDSTUDENT
CS_OBJIDObject ID of Study Object (CS) PIQCSOBJIDNUMC8Assigned to domainHROBJID
SC_OBJIDProgram ID PIQSCOBJIDNUMC8Assigned to domainHROBJIDPON
CS_PRIOXProgram Priority (In Period) PIQCSPRIOXCHAR2CHAR2
APPTYPEReserved field/unused field of length 4 NUSED4CHAR4CHAR4
BEGDAValid-From Date PIQ_BEGDADATS8DATUM
ENDDAValid-To Date PIQ_ENDDADATS8DATUM
PERYRAcademic Year PIQPERYRNUMC4T7PIQYEARPRDPIQPERYR
PERIDAcademic Session PIQPERIDNUMC3T7PIQYEARPRDPIQPERID
ACLEVELStage PIQLEVELNUMC2T7PIQLEVPERVARPIQLEVEL
REGDATEActivity Key Date for Sessional Registration PIQREGPERDATEDATS8DATUM
PARTTIndicator: Part-Time Study PIQPARTTCHAR1XFELD
REG_APPTYPEReserved field/unused field of length 4 NUSED4CHAR4CHAR4
LEAVE_REASONLeave of Absence Reason PIQLEAREASONNUMC4Assigned to domainPIQAPPREASON
FEEFLReserved Field/Unused Field NUSEDCHAR1NUSED
PERCTCompleted Length of Study PIQPERCTNUMC3PIQPERCT
APPREASONUnused Field (NUMC4) PIQNUSED_NUMC4NUMC4NUMC4
PROGCLASSReserved field/unused field of length 4 NUSED4CHAR4Assigned to domainCHAR4
ENRCATEGRegistration Type PIQENRCATEGCHAR2T7PIQENRCATEGPIQENRCATEG
PR_STATUSSessional Registration Status PIQREG_PERIODSTATUSCHAR1PIQREG_PERIODSTATUS
PRS_STATESessional Registration Status Specification PIQREG_PRS_STATECHAR1PIQHS_STATE
REGCLASSRegistration Classification PIQREGCLASSCHAR2T7PIQREGCLASSPIQREGCLASS
CANCPROCESSCancellation Activity (for Registration) PIQREGCANCPROCESSCHAR4Assigned to domainPIQPROCESS
CANCREASONCancellation Reason (For Registration) PIQREGCANCREASONNUMC4Assigned to domainPIQAPPREASON
CANCDATECancellation Date (Registration) PIQREGCANCDATEDATS8DATUM
STUDENT12Student Number PIQSTUDENT12CHAR12PIQSTPIQSTUDENT12
ST_STEXTStudent's Name (Sortable) PIQSTDTXCHAR40TEXT40
SC_SHORTProgram of Study PIQSCSRKCHAR12CHAR12
SC_STEXTProgram Description PIQSCTXTCHAR40TEXT40
O_OTYPEObject Type OTYPECHAR2Assigned to domainOTYPEPOT
O_OBJIDObject ID of Organizational Unit PIQOOBJIDNUMC8Assigned to domainHROBJIDPON
O_SEARKSearch Term for Organizational Unit PIQO_SRKCHAR12CHAR12
O_SHORTObject Abbreviation SHORT_DCHAR12TEXT12
O_STEXTObject Name STEXTCHAR40TEXT40
PERYTAcademic Year (Description) PIQPERYTCHAR20TEXT20
PERITAcademic Session (Description) PIQPERITCHAR20TEXT20
ACLEVELTStage (Description) PIQLEVELTCHAR30TEXT30
REGSTATUSQFIcon for Status or Specification (Sessional Registration) PIQREGSTATUSQFCHAR37PIQICON_QF
REGSTATUSIcon for Status or Specification (Sessional Registration) PIQREGSTATUSCHAR4Assigned to domainICON
ACLEVELVARProgram Plan PIQLEVELVARCHAR2Assigned to domainPIQLEVELVAR
VARIDSession Variant PIQVARIDCHAR2Assigned to domainPIQVARID
VARIDUNITPrimary Unit for Session Variant PIQVARIDUNITNUMC2PIQVARIDUNIT
LEAVE_REASONTReason Description PIQREASONTCHAR25TEXT25
LEAVEIndicator: Student on Leave of Absence PIQLEAVECHAR1XFELD
ACTSTIndicator: Student is Registered PIQREREGCHAR1XFELD
RESTRICTEDIndicator: Admission Restricted PIQRESTRICTEDCHAR1PIQRESTRICTED
PROGCLASSTProgress Classification (Description) PIQPROGCLASSTCHAR30TEXT30
PROGCVARProgram Type PIQPROGC_VARCHAR4Assigned to domainPIQPROGC_VAR
ENRCATEGTRegistration Type (Description) PIQENRCATEGTCHAR30TEXT30
DEGREE_SEEKDegree Seeking (Indicator) PIQDEGREE_SEEKCHAR1XFELD
CSFIRSTIndicator: Main Program PIQCSFIRSTCHAR1XFELD
CSOTHERIndicator: Additional program PIQCSOTHERCHAR1XFELD
REGCLASSTRegistration Classification Description PIQREGCLASSTCHAR30TEXT30
CANCEL_PROCESSTActivity (Description) PIQPROCESS2TCHAR40TEXT40
CANCEL_REASONTReason Description PIQREASONTCHAR25TEXT25

Key field Non-key field



How do I retrieve data from SAP structure PIQSTREG using ABAP code?

As PIQSTREG is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PIQSTREG as there is no data to select.

How to access SAP table PIQSTREG

Within an ECC or HANA version of SAP you can also view further information about PIQSTREG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!