PIQSI2S_MB_TEXT SAP (Acad. Performance Indices: Module Bkg Data with Text Fields) Structure details
Description: Acad. Performance Indices: Module Bkg Data with Text Fields
Related tables to PIQSI2S_MB_TEXT
Access table PIQSI2S_MB_TEXT
Structure field list including key, data, relationships and ABAP select examples
PIQSI2S_MB_TEXT 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 "Acad. Performance Indices: Module Bkg Data with Text Fields" 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_TEXT TYPE PIQSI2S_MB_TEXT.
The PIQSI2S_MB_TEXT table consists of various fields, each holding specific information or linking keys about Acad. Performance Indices: Module Bkg Data with Text Fields data available in SAP. These include MODREG_OTEXT (Object Type Text), MODREG_SHORT (Object Abbreviation), MODREG_STEXT (Object Name), ID (Module Booking Identification).. 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_TEXT 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 |
MODREG_ICON | Icon with Quick Info | PIQICON_QF | CHAR | 37 | PIQICON_QF | ||||
MODREG_OTEXT | Object Type Text | OTEXT | CHAR | 25 | TEXT25 | ||||
MODREG_SHORT | Object Abbreviation | SHORT_D | CHAR | 12 | TEXT12 | ||||
MODREG_STEXT | Object Name | STEXT | CHAR | 40 | TEXT40 | ||||
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 | Assigned to domain | PIQMODREG_ANNULMENT | |||
ANNULMENTT | Exclusion Indicator for Module Bookings (Description) | PIQMODREG_ANNULMENTT | CHAR | 40 | TEXT40 | ||||
PERID | Academic Session | PIQPERID | NUMC | 3 | Assigned to domain | PIQPERID | |||
PERIT | Academic Session (Description) | PIQPERIT | CHAR | 20 | TEXT20 | ||||
PERYR | Academic Year | PIQPERYR | NUMC | 4 | Assigned to domain | PIQPERYR | |||
PERYT | Academic Year (Description) | PIQPERYT | CHAR | 20 | TEXT20 | ||||
BOOKDATE | Booking Date | PIQDATE | DATS | 8 | DATUM | ||||
SMRATING | Alternative Assessment Method for Module | PIQSMRATING | CHAR | 3 | Assigned to domain | PIQSMRATING | |||
SMRATINGT | Alternative Assessment Method for Module (Description) | PIQSMRATINGT | CHAR | 40 | PIQSMRATINGT | ||||
STORREASON | Cancellation Reason | PIQSTORREASON | CHAR | 4 | Assigned to domain | PIQSTORREASON | HRPIQ00WITHDRAWN | ||
STORREASONT | Cancellation Reason (Description) | PIQSTORREASONT | CHAR | 40 | PIQSTORREASONT | ||||
STORDATE | Cancellation Date | PIQSTORDATE | DATS | 8 | PIQSTORDATE | ||||
AGRID | Appraisal ID | PIQAGRID | CHAR | 32 | SYSUUID_C | ||||
AGRTYPE | Appraisal Type | PIQAGRTYPE | NUMC | 4 | Assigned to domain | PIQAGRTYPE | |||
AGRTYPETEXT | Appraisal Type (Description) | PIQAGRTYPET | CHAR | 25 | TEXT25 | ||||
AGRSTAT | Appraisal Status | PIQAGRSTAT | CHAR | 5 | Assigned to domain | PIQAGRSTAT | |||
AGRSTATTEXT | Appraisal Status (Description) | PIQAGRSTATTEXT | CHAR | 30 | TEXT30 | ||||
PLVAR | Plan Version | PLVAR | CHAR | 2 | Assigned to domain | PLVAR | POP | ||
OTYPE | Object Type | OTYPE | CHAR | 2 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
CPUNITT | Description of Credit Type Unit | PIQCPUNITT | CHAR | 25 | TEXT25 | ||||
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 | Assigned to domain | PIQSCALE_ID | PIQSCALE_ID | ||
GRADESCALET | Academic Scale (Description) | PIQSCALE_TEXT | CHAR | 30 | PIQSCALE_TEXT |
Key field | Non-key field |
How do I retrieve data from SAP structure PIQSI2S_MB_TEXT using ABAP code?
As PIQSI2S_MB_TEXT 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_TEXT as there is no data to select.How to access SAP table PIQSI2S_MB_TEXT
Within an ECC or HANA version of SAP you can also view further information about PIQSI2S_MB_TEXT 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