PIQDB_STBOOK - Module Booking Details of Student
Module Booking Details of Student information is stored in SAP table PIQDB_STBOOK.
It is part of development package PMIQ_STACAD_SIMP in software component IS-HER-CM. This development package consists of objects that can be grouped under "Student Academics Process Simplified".
It is part of development package PMIQ_STACAD_SIMP in software component IS-HER-CM. This development package consists of objects that can be grouped under "Student Academics Process Simplified".
Fields for table PIQDB_STBOOK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| PLVAR | Plan Version | X | PLVAR | CHAR | 4 | |
| ST_OBJID | Object ID | X | HROBJID | NUMC | 16 | |
| AW_OTYPE | Object Type | X | OTYPE | CHAR | 4 | |
| AW_OBJID | Object ID | X | HROBJID | NUMC | 16 | |
| ISTAT | Planning Status | X | ISTAT_D | CHAR | 2 | |
| ACAD_PROCESS | Student Academic Academic Process | X | PIQACAD_PROCESS | CHAR | 6 | |
| ACAD_RELN | Academic Relation | X | PIQDB_ACAD_RELATION | CHAR | 8 | |
| BEGDA | Start Date | X | BEGDATUM | DATS | 16 | |
| ENDDA | End Date | X | ENDDATUM | DATS | 16 | |
| PRIOX | Priority | X | PRIOX | CHAR | 4 | |
| ID | Module Booking Identification | X | PIQMODREG_ID | CHAR | 64 | |
| PACKNUMBER | Event Package | PIQSLNUM | NUMC | 16 | ||
| AEDTM | Changed on | AEDTM | DATS | 16 | ||
| UNAME | User Name | USRNAME | CHAR | 24 | ||
| SMSTATUS | Module Booking Status | PIQSMSTATUS | NUMC | 4 | ||
| STORREASON | Cancellation Reason | PIQSTORREASON | CHAR | 8 | ||
| STORDATE | Cancellation Date | PIQSTORDATE | DATS | 16 | ||
| CPATTEMP | Attempted Credits | PIQCPATTEMP | QUAN | 6 | ||
| CPGAINED | Earned Credits | PIQCPGAINED | QUAN | 6 | ||
| CPUNIT | Unit of Measurement for Credits | PIQCPUNIT | UNIT | 6 | ||
| NORM_VAL | Std Value for Scale Value | PIQSCALE_NORM_VAL | DEC | 5 | ||
| BOOKDATE | Booking Date | PIQDATE | DATS | 16 | ||
| BOOKTIME | Booking Time | PIQWAITL_TIME | TIMS | 12 | ||
| SMRATING | Alternative Assessment Method for Module | PIQSMRATING | CHAR | 6 | ||
| CHARGEFREE | Free of Charge | PIQCHARGE | CHAR | 2 | ||
| TRANSFERFLAG | External Academic Work or Qualification Transferred | PIQTRANSFER | CHAR | 2 | ||
| VARID | Session Variant | PIQVARID | CHAR | 4 | ||
| PERID | Academic Session | PIQPERID | NUMC | 6 | ||
| PERYR | Academic Year | PIQPERYR | NUMC | 8 | ||
| ALT_SCALEID | Academic Scale Identification (ID) | PIQSCALE_ID | CHAR | 8 | ||
| BOOKREASON | Module Booking Reason | PIQBOOKREASON | CHAR | 8 | ||
| ANNULMENT | Exclusion Indicator for Module Bookings | PIQMODREG_ANNULMENT | CHAR | 2 | ||
| LOCKFLAG | Change Lock | PIQAWLOCKFLAG | CHAR | 2 | ||
| COBOK | Conditional Booking | PIQPEPE_COBOK | CHAR | 2 | ||
| BOOKING_SUBGROUP_ID | Module and Event Package Subgroup Definition | PIQBOOKING_SUBGROUP_ID | CHAR | 40 | ||
| ATTNO_TW | Attempt Number for Transferred work | PIQATTNO_TW | NUMC | 6 | ||
| .INCLUDE | CI_PIQDB_STBOOK | 0 |