PIQSI2S_MB SAP (Average Grades: Module Booking Data) Structure details
Description: Average Grades: Module Booking Data
Structure field list including key, data, relationships and ABAP select examples
PIQSI2S_MB 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 "Average Grades: Module Booking Data" 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_PIQSI2S_MB TYPE PIQSI2S_MB.
The PIQSI2S_MB table consists of various fields, each holding specific information or linking keys about Average Grades: Module Booking Data data available in SAP. These include ID (Module Booking Identification), PACKNUMBER (Event Package), TRANSFERFLAG (External Academic Work or Qualification Transferred), ANNULMENT (Exclusion Indicator for Module Bookings).. 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: Cannot Be Enhanced
SAP PIQSI2S_MB 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 |
ID | Module Booking Identification | PIQMODREG_ID | CHAR | 32 | SYSUUID_C | ||||
PACKNUMBER | Event Package | PIQSLNUM | NUMC | 8 | Assigned to domain | HROBJID | |||
TRANSFERFLAG | External Academic Work or Qualification Transferred | PIQTRANSFER | CHAR | 1 | PIQTRANSFER | ||||
ANNULMENT | Exclusion Indicator for Module Bookings | PIQMODREG_ANNULMENT | CHAR | 1 | T7PIQ_MR_ANNUL | PIQMODREG_ANNULMENT | |||
BEGDA | Start Date | BEGDATUM | DATS | 8 | DATUM | BEG | |||
ENDDA | End Date | ENDDATUM | DATS | 8 | DATUM | END | |||
PERID | Academic Session | PIQPERID | NUMC | 3 | T7PIQPERIOD | PIQPERID | |||
PERYR | Academic Year | PIQPERYR | NUMC | 4 | T7PIQYEAR | PIQPERYR | |||
BOOKDATE | Booking Date | PIQDATE | DATS | 8 | DATUM | ||||
SMRATING | Alternative Assessment Method for Module | PIQSMRATING | CHAR | 3 | T7PIQSMRATING | PIQSMRATING | |||
STORREASON | Cancellation Reason | PIQSTORREASON | CHAR | 4 | T7PIQWITHDRAWN | PIQSTORREASON | HRPIQ00WITHDRAWN | ||
STORDATE | Cancellation Date | PIQSTORDATE | DATS | 8 | PIQSTORDATE | ||||
COBOK | Conditional Booking | PIQPEPE_COBOK | CHAR | 1 | PIQPEPE_COBOK | ||||
SMSTATUS | Module Booking Status | PIQSMSTATUS | NUMC | 2 | Assigned to domain | PIQSMSTATUS | |||
BOOKREASON | Module Booking Reason | PIQBOOKREASON | CHAR | 4 | Assigned to domain | PIQBOOKREASON | |||
AGRID | Appraisal ID | PIQAGRID | CHAR | 32 | SYSUUID_C | ||||
AGRTYPE | Appraisal Type | PIQAGRTYPE | NUMC | 4 | Assigned to domain | PIQAGRTYPE | |||
AGRSTAT | Appraisal Status | PIQAGRSTAT | CHAR | 5 | Assigned to domain | PIQAGRSTAT | |||
AGRNOTRATED | Appraisal Grade Not Relevant | PIQAGRNOTRATED | CHAR | 1 | PIQAGRNOTRATED | ||||
AGRDATE | Appraisal Date | PIQAGRDATE | DATS | 8 | PIQDATE | ||||
NOTEID | GUID - Unique Note Identifier | PIQNOTE_GUID | CHAR | 32 | SYSUUID_C | ||||
AGRREMARK | Appraisal Remark | PIQAGRREMARK | CHAR | 2 | Assigned to domain | PIQAGRREMARK | |||
AGRBEGDA | Start of Appraisal Validity | PIQAGRBEGDA | DATS | 8 | PIQDATE | ||||
AGRENDDA | End of Appraisal Validity | PIQAGRENDDA | DATS | 8 | PIQDATE | ||||
PLVAR | Plan Version | PLVAR | CHAR | 2 | T778P | PLVAR | POP | ||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
OBJID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
IS_ACST_USED | Relevant for Academic Standing | PIQPROGIS_ACST_USED | CHAR | 1 | FLAG | ||||
IS_ACSTFA_USED | Relevant for Academic Standing Based On Financial Aid Rules | PIQPROGIS_ACSTFA_USED | CHAR | 1 | FLAG | ||||
IS_PRCL_USED | Relevant for Progress Classification | PIQPROGIS_PRCL_USED | CHAR | 1 | FLAG | ||||
IS_PRCLFA_USED | Relevant for Progress Classification Based On FA Regulations | PIQPROGIS_PRCLFA_USED | CHAR | 1 | FLAG | ||||
IS_AWARD_USED | Relevant for Academic Honors | PIQPROGIS_AWARD_USED | CHAR | 1 | FLAG | ||||
PROG_KEY_DATE | Valid From Date for Progression | PIQPROG_GR_KEY_DATE | DATS | 8 | |||||
AGRCOMPLETED | Appraisal Completed | PIQAGRCOMPLETED | CHAR | 1 | PIQAGRCOMPLETED | ||||
CPATTEMP | Attempted Credits | PIQCPATTEMP | QUAN | 10(5) | PIQCP | ||||
CPEARNED | Earned Credits | PIQCPEARNED | QUAN | 10(5) | PIQCP | ||||
CPGRADED | Graded Credits | PIQCPGRADED | QUAN | 10(5) | PIQCP | ||||
CPUNIT | Unit of Measurement for Credits | PIQCPUNIT | UNIT | 3 | T7PIQCP | CUNIT | MEINS | ||
GRADESYM | Grade Symbol | PIQGRADESYM | CHAR | 10 | PIQGRADESYM | ||||
GRADE | Std Value for Scale Value | PIQSCALE_NORM_VAL | DEC | 8(2) | PIQSCALE_NORM_VAL | ||||
GRADESCALE | Academic Scale Identification (ID) | PIQSCALE_ID | CHAR | 4 | T7PIQSCALE | PIQSCALE_ID | PIQSCALE_ID | ||
WEIGHTING | Weighting Determined from Hierarchy | PIQAGGM_WEIGHTING | DEC | 5(2) | PIQAGRWEIGHT |
Key field | Non-key field |
How do I retrieve data from SAP structure PIQSI2S_MB using ABAP code?
As PIQSI2S_MB 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 PIQSI2S_MB as there is no data to select.How to access SAP table PIQSI2S_MB
Within an ECC or HANA version of SAP you can also view further information about PIQSI2S_MB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects