PIQIB_ED_TRANSWORK_OVW SAP (Transferred Academic Achievements Overview) Structure details
Description: Transferred Academic Achievements Overview
Related tables to PIQIB_ED_TRANSWORK_OVW
Access table PIQIB_ED_TRANSWORK_OVW
Structure field list including key, data, relationships and ABAP select examples
PIQIB_ED_TRANSWORK_OVW 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 "Transferred Academic Achievements Overview" 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_PIQIB_ED_TRANSWORK_OVW TYPE PIQIB_ED_TRANSWORK_OVW.
The PIQIB_ED_TRANSWORK_OVW table consists of various fields, each holding specific information or linking keys about Transferred Academic Achievements Overview data available in SAP. These include GUIDTYPE (Identifier Type (GUID)), GUID (Equivalency Identifier (ID)), GRPGRP (Academic Work Grouping), AGMIDGRP (ID of Transfer Regulation for External Achievement).. 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 PIQIB_ED_TRANSWORK_OVW 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 |
GUIDTYPE | Identifier Type (GUID) | PIQGUIDTYPE | CHAR | 4 | Assigned to domain | PIQGUIDTYPE | |||
GUID | Equivalency Identifier (ID) | PIQEDGUID | CHAR | 32 | Assigned to domain | PIQPROC_DOCID | |||
.INCLU-GRP | 0 | ||||||||
GRPGRP | Academic Work Grouping | PIQEDGROUP | CHAR | 2 | CHAR2 | ||||
AGMIDGRP | ID of Transfer Regulation for External Achievement | PIQEDAGMID | CHAR | 32 | SYSUUID_C | ||||
NOTEGRP | GUID - Unique Note Identifier | PIQNOTE_GUID | CHAR | 32 | SYSUUID_C | ||||
TEXTGRP | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
GRP_NOTEICON_SOURCE | 0 | ||||||||
GRP_NOTEICON_TOOLTIP | 0 | ||||||||
GRP_KEY | 0 | ||||||||
GRP_TEXT | 0 | ||||||||
.INCLU-AGM | 0 | ||||||||
MANDTAGM | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
AGMIDAGM | ID of Transfer Regulation for External Achievement | PIQEDAGMID | CHAR | 32 | SYSUUID_C | ||||
EXTBEGDAAGM | Valid From Date for Completion of Ext. Academic Achievement | PIQEDEXT_BEGDA | DATS | 8 | DATUM | ||||
EXTENDDAAGM | Valid To Date for Completion of Ext. Academic Achievement | PIQEDEXT_ENDDA | DATS | 8 | DATUM | ||||
VALID_BEGAGM | Validity Start Date of Transfer Regulation | PIQEDAGM_VALID_BEG | DATS | 8 | DATUM | ||||
VALID_ENDAGM | Validity End Date of Transfer Regulation | PIQEDAGM_VALID_END | DATS | 8 | DATUM | ||||
FREE1AGM | Characteristic 1 for Up To 10-Character Customer Entries | PIQEDFREE10 | CHAR | 10 | PIQED_FREE10 | ||||
FREE2AGM | Characteristic 2 for Up To 20-Character Customer Entries | PIQEDFREE20 | CHAR | 20 | PIQED_FREE20 | ||||
PRIORITYAGM | Priority of Transfer Regulation | PIQEDPRIORITY | CHAR | 2 | PIQED_PRIORITY | ||||
SEL_EO_OBJIDAGM | External Organization | PIQEDEO | NUMC | 8 | Assigned to domain | HROBJID | |||
SEL_EO_STEXTAGM | External Organization (Description) | PIQEDEO_STEXT | CHAR | 40 | TEXT40 | ||||
SEL_EO_ACCREAGM | Accredited Institution | PIQEO_ISACCEDITED | CHAR | 1 | XFIELD | ||||
SEL_EO_SEQNRAGM | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | NUM03 | ||||
LANGUAGM | Language Key | LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
AGMTEXTAGM | Transfer Regulation for External Achievement (Description) | PIQEDAGMTEXT | CHAR | 40 | TEXT40 | ||||
SHORT_INTAGM | Character 100 | CHAR100 | CHAR | 100 | CHAR100 | ||||
SHORT_EXTAGM | Character 100 | CHAR100 | CHAR | 100 | CHAR100 | ||||
UE_EO_OBJIDAGM | External Organization | PIQEDEO | NUMC | 8 | Assigned to domain | HROBJID | |||
UE_EO_STEXTAGM | External Organization (Description) | PIQEDEO_STEXT | CHAR | 40 | TEXT40 | ||||
UE_EO_ACCREAGM | Accredited Institution | PIQEO_ISACCEDITED | CHAR | 1 | XFIELD | ||||
.INCLU-_EX | 0 | ||||||||
OTYPE_EX | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
OBJID_EX | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
COREPEATFLAG_EX | Indicator: Repeated Subject | PIQTRCOREPEATFLAG | CHAR | 1 | |||||
HONORSINDIC_EX | Indicator: Honors Subject | PIQTRHONORSINDIC | CHAR | 1 | |||||
EXTGRADESYM_EX | External Grade | PIQEDEXTGRADETR | CHAR | 10 | PIQGRADESYM | ||||
EXTGRADE_EX | Std Value for Scale Value | PIQSCALE_NORM_VAL | DEC | 8(2) | PIQSCALE_NORM_VAL | ||||
EXTGRADESCALE_EX | Academic Scale Identification (ID) | PIQSCALE_ID | CHAR | 4 | Assigned to domain | PIQSCALE_ID | PIQSCALE_ID | ||
GRADEMANFLAG_EX | Overwrite Converted Original Grade of External Subject | PIQTRGRADEMANFLAG | CHAR | 1 | |||||
INTGRADESYM_EX | Internal Grade | PIQEDINTGRADETR | CHAR | 10 | PIQGRADESYM | ||||
INTGRADE_EX | Std Value for Scale Value | PIQSCALE_NORM_VAL | DEC | 8(2) | PIQSCALE_NORM_VAL | ||||
INTGRADESCALE_EX | Academic Scale Identification (ID) | PIQSCALE_ID | CHAR | 4 | T7PIQSCALE | PIQSCALE_ID | PIQSCALE_ID | ||
EXTCOATMCRED_EX | Attempted Credits in External Subject | PIQTREXTCOATMCRED | QUAN | 10(5) | PIQCP | ||||
EXTCOGRDCRED_EX | Graded Credits in External Subject | PIQTREXTCOGRDCRED | QUAN | 10(5) | PIQCP | ||||
EXTCOERNCRED_EX | Earned Credits in External Subject | PIQTREXTCOERNCRED | QUAN | 10(5) | PIQCP | ||||
EXTCOCREDTYPE_EX | Original Credit Type of External Subject | PIQTREXTCOCREDTYPE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
COCREDMANFLAG_EX | Overwrite Converted Credits Per External Subject Manually | PIQTRCOCREDMANFLAG | CHAR | 1 | |||||
INTCOATMCRED_EX | Attempted Credits in Ext. Subject in Internal Credit Type | PIQTRINTCOATMCRED | QUAN | 10(5) | PIQCP | ||||
INTCOGRDCRED_EX | Graded Credits in Ext. Subject in Internal Credit Type | PIQTRINTCOGRDCRED | QUAN | 10(5) | PIQCP | ||||
INTCOERNCRED_EX | Earned Credits in Ext. Subject in Internal Credit Type | PIQTRINTCOERNCRED | QUAN | 10(5) | PIQCP | ||||
INTCOCREDTYPE_EX | Internal Credit Type | PIQTRINTCOCREDTYPE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASFORCOCRED_EX | Basis for Accomplished Credits | PIQTRBASFORCOCRED | CHAR | 4 | Assigned to domain | PIQTRBASFORCRED | |||
COWITHDRDATE_EX | Date of Withdrawal | PIQTRCOWITHDRDATE | DATS | 8 | |||||
COSESID_EX | Session In Which External Subject Was Taken | PIQTRCOSESID | CHAR | 4 | Assigned to domain | PIQTRSESSIONID | |||
COSESYEAR_EX | Year In Which Subject Was Taken | PIQTRCOSESYEAR | NUMC | 4 | PIQTRSESSIONYEAR | ||||
COBEGDATE_EX | Start Date of Subject | PIQTRCOBEGDATE | DATS | 8 | |||||
COENDDATE_EX | End Date of Subject | PIQTRCOENDDATE | DATS | 8 | |||||
AWSTATUS_EX | Status of External Academic Work or Qualification | PIQEDEXTAWSTATUS | CHAR | 1 | PIQEDAWSTATUS | ||||
EQCONFERDATE_EX | (Anticipated) Completion Date | PIQTRDEGDATE | DATS | 8 | |||||
.INCLU-_EX | 0 | ||||||||
SHORT_EX | External Academic Achievement (Abbreviation) | PIQEDEXT_SHORT | CHAR | 12 | TEXT12 | ||||
STEXT_EX | Object Name | STEXT | CHAR | 40 | TEXT40 | ||||
OTYPET_EX | Object Type of External Academic Achievement (Description) | PIQEDOTYPE_EXT_TEXT | CHAR | 25 | TEXT25 | ||||
SCALEINT_EX | Scale (Description) | PIQSCALETEXT | CHAR | 30 | PIQSCALE_TEXT | ||||
SCALEEXT_EX | Scale (Description) | PIQSCALETEXT | CHAR | 30 | PIQSCALE_TEXT | ||||
.INCLU-_EO | 0 | ||||||||
ISSEO_EO | Issuing External Organization | PIQTRISSEO | NUMC | 8 | Assigned to domain | HROBJID | HRPIQ00EXTORG | ||
STEXT_EO | Name of External Organization | PIQF4EO_STEXT | CHAR | 40 | TEXT40 | ||||
SHORT_EO | External Organization Abbreviation | PIQF4EO_SHORT | CHAR | 12 | TEXT12 | ||||
EOCODETYPEID_EO | Coding System for External Organization | PIQEOCODETYPEID | CHAR | 6 | Assigned to domain | PIQEOCODETYPEID | HRPIQ00EOCODETYPEID | ||
EOCODE_EO | Code of External Organization | PIQEOCODE | CHAR | 16 | CHAR16 | ||||
CATEGORY_EO | External Organization Category | PIQEO_CATEGORY | CHAR | 4 | Assigned to domain | PIQEO_CATEGORY | HRPIQ00EOCATEGORY | ||
ACCREDITED_EO | Accredited Institution | PIQEO_ISACCEDITED | CHAR | 1 | XFIELD | ||||
EOCODETYPET_EO | Description of Coding System for External Organization | PIQEOCODETYPET | CHAR | 40 | TEXT40 | ||||
CATEGORYIDTEXT_EO | Name of External Organization Category | PIQEO_CATEGORY_TEXT | CHAR | 30 | TEXT30 | ||||
EOCLASS_EO | Classification of EO Category | PIQEOCLASS | CHAR | 4 | Assigned to domain | PIQEOCLASS | |||
EOCLASSTEXT_EO | Description of External Organization Classification | PIQEOCLASST | CHAR | 40 | TEXT40 | ||||
EXTW_KEY | 0 | ||||||||
.INCLU-_IN | 0 | ||||||||
OTYPE_IN | Object Type of Internal Academic Achievement | PIQEDINTOTYPE | CHAR | 2 | PIQED_INTOTYPE | POT | |||
OBJID_IN | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
GRADESYM_IN | Grade Symbol | PIQGRADESYM | CHAR | 10 | PIQGRADESYM | ||||
GRADE_IN | Std Value for Scale Value | PIQSCALE_NORM_VAL | DEC | 8(2) | PIQSCALE_NORM_VAL | ||||
GRADESCALE_IN | Academic Scale Identification (ID) | PIQSCALE_ID | CHAR | 4 | T7PIQSCALE | PIQSCALE_ID | PIQSCALE_ID | ||
CPATTEMP_IN | Attempted Credits | PIQCPATTEMP | QUAN | 10(5) | PIQCP | ||||
CPEARNED_IN | Earned Credits | PIQCPEARNED | QUAN | 10(5) | PIQCP | ||||
CPGRADED_IN | Graded Credits | PIQCPGRADED | QUAN | 10(5) | PIQCP | ||||
CPUNIT_IN | Unit of Measurement for Credits | PIQCPUNIT | UNIT | 3 | T7PIQCP | CUNIT | MEINS | ||
PROGC_VAR_IN | Program Type | PIQPROGC_VAR | CHAR | 4 | T7PIQPROGCVAR | PIQPROGC_VAR | |||
SC_OBJID_IN | Program ID | PIQSCOBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
TRANSFERBOOKID_IN | Relationship Identifier (ID) | PIQEDTRANSFERID | CHAR | 32 | SYSUUID_C | ||||
AWSTATUS_IN | Status of Internal Academic Work or Qualification | PIQEDINTAWSTATUS | CHAR | 1 | PIQEDAWSTATUS | ||||
PERYR_IN | Assigned Academic Year of Internal Academic Work/Qualif. | PIQEDINTYEAR | NUMC | 4 | T7PIQYEAR | PIQPERYR | |||
PERID_IN | Assigned Academic Session of Internal Academic Work/Qualif. | PIQEDINTSESSION | NUMC | 3 | T7PIQPERIOD | PIQPERID | |||
AGRBEGDA_IN | Start of Appraisal Validity | PIQAGRBEGDA | DATS | 8 | PIQDATE | ||||
AGRENDDA_IN | End of Appraisal Validity | PIQAGRENDDA | DATS | 8 | PIQDATE | ||||
.INCLU-_IN | 0 | ||||||||
SHORT_IN | Internal Academic Achievement (Abbreviation) | PIQEDINT_SHORT | CHAR | 12 | TEXT12 | ||||
STEXT_IN | Object Name | STEXT | CHAR | 40 | TEXT40 | ||||
OTYPET_IN | Object Type of Internal Work/Qualification (Description) | PIQEDOTYPE_INT_TEXT | CHAR | 25 | TEXT25 | ||||
SCALET_IN | Scale (Description) | PIQSCALETEXT | CHAR | 30 | PIQSCALE_TEXT | ||||
PROGC_VART_IN | Program Type (Description) | PIQPROGC_VART | CHAR | 30 | TEXT30 | ||||
GRADESYMT_IN | Scale Value (Description) | PIQSCALE_GRADETEXT | CHAR | 20 | PIQSCALE_GRADETEXT | ||||
INTW_KEY | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure PIQIB_ED_TRANSWORK_OVW using ABAP code?
As PIQIB_ED_TRANSWORK_OVW 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 PIQIB_ED_TRANSWORK_OVW as there is no data to select.How to access SAP table PIQIB_ED_TRANSWORK_OVW
Within an ECC or HANA version of SAP you can also view further information about PIQIB_ED_TRANSWORK_OVW 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