Q1785 SAP (Screen Fields for Infotype 1785 (EBL School Results)) Structure details
Description: Screen Fields for Infotype 1785 (EBL School Results)
Structure field list including key, data, relationships and ABAP select examples
Q1785 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 "Screen Fields for Infotype 1785 (EBL School Results)" 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_Q1785 TYPE Q1785.
The Q1785 table consists of various fields, each holding specific information or linking keys about Screen Fields for Infotype 1785 (EBL School Results) data available in SAP. These include RESULT_PREV (CM UCAS: Previous EBL Results), SCHOOL_SHORT (CM UCAS: Marvin Code School/Institution), SCHOOL_LONG (CM UCAS: School/Institution description), BTEC_FLAG (UCAS: BTEC).. 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 Q1785 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 |
RESULT_FINAL | CM UCAS: Final EBL Results | PIQ_GB_UCAS_RESULT_FINAL | CHAR | 1 | CHAR1 | ||||
RESULT_PREV | CM UCAS: Previous EBL Results | PIQ_GB_UCAS_RESULT_PREV | CHAR | 1 | CHAR1 | ||||
SCHOOL_SHORT | CM UCAS: Marvin Code School/Institution | PIQ_GB_UCAS_SCHOOL_SHORT | CHAR | 12 | CHAR12 | ||||
SCHOOL_LONG | CM UCAS: School/Institution description | PIQ_GB_UCAS_SCHOOL_LONG | CHAR | 40 | CHAR40 | ||||
BTEC_FLAG | UCAS: BTEC | PIQ_GB_UCAS_BTEC_CB | CHAR | 1 | CHAR1 | ||||
IRISH_FLAG | UCAS: Irish Leaving Certification Flag | PIQ_GB_UCAS_IRISH_FLAG_CB | CHAR | 1 | CHAR1 | ||||
SQA_FLAG | General Indicator | PIQFLAG | CHAR | 1 | FLAG | ||||
OTHER_EXAM | UCAS: Other A/AS/Highers/CSYS Flag | PIQ_GB_UCAS_OTHER_RESULTS_CB | CHAR | 1 | CHAR1 | ||||
SUBJECT_EBL | CM UCAS: EBL Subject Code | PIQ_GB_UCAS_SUBJ_EBL | CHAR | 3 | Assigned to domain | PIQ_GB_UCAS_SUBJ_EBL | |||
SUBJECT_SHORT | Object Abbreviation | SHORT_D | CHAR | 12 | TEXT12 | ||||
SUBJECT_LONG | Object Description | PIQSUBTEXT | CHAR | 40 | TEXT40 | ||||
POINTS | CM UCAS: No of points | PIQ_GB_UCAS_POINTS | NUMC | 3 | NUMC3 | ||||
ACHIEVED_YES | UCAS: The record of the achievement exists | PIQ_GB_UCAS_ACHIEVED1 | CHAR | 1 | CHAR1 | ||||
ACHIEVED_NO | UCAS: No record of achievement exists | IQ_GB_UCAS_ACHIEVED2 | CHAR | 1 | CHAR1 | ||||
ACHIEVED_NA | ***CM UCAS: | PIQ_GB_UCAS_ACHIEVED3 | CHAR | 1 | CHAR1 | ||||
QUALITYT | UCAS: Qualification | PIQ_GB_UCAS_GRADE_TYPET | CHAR | 50 | TEXT50 | ||||
EXAM_BAOARDT | UCAS: Exam Board Name | PIQ_GB_UCAS_EX_BOARDT | CHAR | 50 | TEXT50 | ||||
POINTS_TOT | UCAS: Total number of points | PIQ_GB_UCAS_POINTS_TOT | DEC | 4 | PIQ_GB_UCAS_POINTS_TOT | ||||
POINTS_A_AS | UCAS: Number of Points Scored in GCE A/AS | PIQ_GB_UCAS_POINTS_A_AS | DEC | 4 | PIQ_GB_UCAS_POINTS_A_AS | ||||
POINTS_VCE | UCAS: Number of Points Scored in VCE A/AS/Double | PIQ_GB_UCAS_POINTS_VCE | DEC | 4 | PIQ_GB_UCAS_POINTS_A_AS | ||||
POINTS_SH | UCAS: Number of Points in Scottish Highers + Advanced Higher | PIQ_GB_UCAS_POINTS_SH | DEC | 4 | PIQ_GB_UCAS_POINTS_SH | ||||
GCEASN | CM UCAS: Number of GCE AS level | PIQ_GB_UCAS_TR_GCEASN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
GCEASTS | CM UCAS: Tariff Score for GCE AS Level | PIQ_GB_UCAS_TR_GCEASTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
VCEASN | CM UCAS: Number of VCE AS level | PIQ_GB_UCAS_TR_VCEASN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
VCEASTS | CM UCAS: Tariff Score for VCE AS Level | PIQ_GB_UCAS_TR_VCEASTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
GCEAN | CM UCAS: Number of GCE A level | PIQ_GB_UCAS_TR_GCEAN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
GCEATS | CM UCAS: Tariff Score for GCE A Level | PIQ_GB_UCAS_TR_GCEATS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
VCEAN | CM UCAS: Number of VCE A level | PIQ_GB_UCAS_TR_VCEAN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
VCEATS | CM UCAS: Tariff Score for VCE A Level | PIQ_GB_UCAS_TR_VCEATS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
KSQN | CM UCAS: Number of Key Skills | PIQ_GB_UCAS_TR_KSQN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
KSQTS | CM UCAS: Tariff score for Key Skills qualification | PIQ_GB_UCAS_TR_KSQTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
UKSAN | CM UCAS: Number of 1-unit award Key Skills | PIQ_GB_UCAS_TR_UKSAN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
UKSATS | CM UCAS: Tariff score for 1-unit key skills award | PIQ_GB_UCAS_TR_UKSATS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
SAHN | CM UCAS: Number of Scottish Advanced Higher | PIQ_GB_UCAS_TR_SAHN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
SAHTS | CM UCAS: Tariff score for Scottish Advanced Higher | PIQ_GB_UCAS_TR_SAHTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
SHN | CM UCAS: Number of Scottish Higher | PIQ_GB_UCAS_TR_SHN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
SHTS | CM UCAS: Tariff score for Scottish Higher | PIQ_GB_UCAS_TR_SHTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
SI2N | CM UCAS: Number of Scottish Intermediate | PIQ_GB_UCAS_TR_SI2N | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
SI2TS | CM UCAS: Tariff score for Scottish Intermediate 2 | PIQ_GB_UCAS_TR_SI2TS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
SSGCN | CM UCAS: Number of Scottish Standard Grade Credit | PIQ_GB_UCAS_TR_SSGCN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
SSGCTS | CM UCAS: Tariff score for Scottish Standard Grade Credit | PIQ_GB_UCAS_TR_SSGCTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
SCSN | CM UCAS: Number of Scottish Core Skills | PIQ_GB_UCAS_TR_SCSN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
SCSTS | CM UCAS: Tariff score for Scottish Core Skills | PIQ_GB_UCAS_TR_SCSTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
AEAN | CM UCAS: Number of Advanced Extension Awards | PIQ_GB_UCAS_TR_AEAN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
AEANTS | CM UCAS: Tariff score for Advanced Extension Awards | PIQ_GB_UCAS_TR_AEANTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
TOTALTS | CM UCAS: Total Tariff Score | PIQ_GB_UCAS_TR_TOTALTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
CACHEN | CM UCAS: Number of CACHE qualifications | PIQ_GB_UCAS_TR_CACHEN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
CACHETS | CM UCAS: Tariff Score for CACHE qualifications | PIQ_GB_UCAS_TR_CACHETS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
BTECN | CM UCAS: Number of BTEC National | PIQ_GB_UCAS_TR_BTECN | NUMC | 1 | PIQ_GB_UCAS_TR_NUM | ||||
BTECTS | CM UCAS: Tariff Score for BTEC National | PIQ_GB_UCAS_TR_BTECTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
IBTS | CM UCAS: Tariff Score for International Baccalaureate | PIQ_GB_UCAS_TR_IBTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
ILCTS | CM UCAS: Tariff Score for Irish Leaving Certificate | PIQ_GB_UCAS_TR_ILCTS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE | ||||
MDPATS | CM UCAS: Tariff Score for Music, Drama, Performing Arts | PIQ_GB_UCAS_TR_MDPATS | NUMC | 3 | PIQ_GB_UCAS_TR_SCORE |
Key field | Non-key field |
How do I retrieve data from SAP structure Q1785 using ABAP code?
As Q1785 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 Q1785 as there is no data to select.How to access SAP table Q1785
Within an ECC or HANA version of SAP you can also view further information about Q1785 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