PIQ_GB_UCAS_REF_SCHOOL_DETAILS SAP (Reference School Details) Structure details

Dictionary Type: Structure
Description: Reference School Details




ABAP Code to SELECT data from PIQ_GB_UCAS_REF_SCHOOL_DETAILS
Related tables to PIQ_GB_UCAS_REF_SCHOOL_DETAILS
Access table PIQ_GB_UCAS_REF_SCHOOL_DETAILS




Structure field list including key, data, relationships and ABAP select examples

PIQ_GB_UCAS_REF_SCHOOL_DETAILS 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 "Reference School Details" 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_PIQ_GB_UCAS_REF_SCHOOL_DETAILS TYPE PIQ_GB_UCAS_REF_SCHOOL_DETAILS.

The PIQ_GB_UCAS_REF_SCHOOL_DETAILS table consists of various fields, each holding specific information or linking keys about Reference School Details data available in SAP. These include MANDT (Client), SCHOOL_ID (UCAS: School Number), NAME (-Cm UCAS: Field description), COUNTRY_CODE (UCAS: School country code).. 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: Can be enhanced (character-type or numeric)


SAP PIQ_GB_UCAS_REF_SCHOOL_DETAILS 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
MANDTClient MANDTCLNT3T000MANDT
SCHOOL_IDUCAS: School Number PIQ_GB_UCAS_SCHOOLCHAR7Assigned to domainPIQ_GB_UCAS_SCHOOL
NAME-Cm UCAS: Field description PIQ_GB_UCAS_DESCRIPTIONCHAR50TEXT50
COUNTRY_CODEUCAS: School country code PIQ_GB_UCAS_COUNTRYCHAR1PIQ_GB_UCAS_COUNTRY
EST_GRPUCAS: Establishment group PIQ_GB_UCAS_EST_GRPCHAR1CHAR1
STATUSUCAS: School status PIQ_GB_UCAS_SCHOOL_STATUSCHAR1CHAR1
DFE_IDUCAS: DFE number PIQ_GB_UCAS_DFE_IDCHAR7CHAR7
NC_IDUCAS: National Centre Number (NCN) PIQ_GB_UCAS_NC_IDCHAR5CHAR5
BTEC_IDUCAS: BTEC National Centre Number PIQ_GB_UCAS_BTEC_IDCHAR6CHAR6
HEAD_NAMEUCAS: Headmaster/Principal Name PIQ_GB_UCAS_HEAD_NAMECHAR35PIQ_GB_UCAS_NAME
HEAD_TITLEUCAS: Headmaster/Principal Title PIQ_GB_UCAS_HEAD_TITLECHAR35PIQ_GB_UCAS_NAME
CONT_TITLEUCAS: Usual Contact Title PIQ_GB_UCAS_CONT_TITLECHAR35PIQ_GB_UCAS_NAME
CONT_NAMEUCAS: Usual Contact Name PIQ_GB_UCAS_CONT_NAMECHAR35PIQ_GB_UCAS_NAME
ADDRESS_1UCAS: Address line PIQ_GB_UCAS_ADDRESSCHAR27PIQ_GB_UCAS_ADDRESS_LINE
ADDRESS_2UCAS: Address line PIQ_GB_UCAS_ADDRESSCHAR27PIQ_GB_UCAS_ADDRESS_LINE
ADDRESS_3UCAS: Address line PIQ_GB_UCAS_ADDRESSCHAR27PIQ_GB_UCAS_ADDRESS_LINE
ADDRESS_4UCAS: Address line PIQ_GB_UCAS_ADDRESSCHAR27PIQ_GB_UCAS_ADDRESS_LINE
POSTCODEPostal Code PD_PSTLZCHAR10PSTLZ
TELNRTelephone Number TELENRCHAR25CHAR25
SCHOOL_TYPEUCAS: School type PIQ_GB_UCAS_SCHOOL_TYPECHAR1T7PIQ_GB_SCHTYPPIQ_GB_UCAS_SCHOOL_TYPE
DAY_BOARDUCAS: School Day Board PIQ_GB_UCAS_DAY_BOARDCHAR1CHAR1
SEXUCAS: School Sexes PIQ_GB_UCAS_SEXCHAR1CHAR1
DTM_COLLUCAS: Date annual data collected PIQ_GB_UCAS_DTM_COLLDATS8DATE
ROLL_NRUCAS: Number on Roll PIQ_GB_UCAS_ROLL_NRCHAR1CHAR1
FULL_TIMEUCAS: Full Time PIQ_GB_UCAS_FULL_TIMECHAR1CHAR1
FIFTH_FORMUCAS: Fifth Form PIQ_GB_UCAS_FIFTH_FORMCHAR1CHAR1
SIXTH_FORMUCAS: Sixth Form PIQ_GB_UCAS_SIXTH_FORMCHAR1CHAR1
HI_EDUCATUCAS: Higher Education PIQ_GB_UCAS_HI_EDUCATCHAR1CHAR1
WELSHUCAS: Welshs Schools Main Language PIQ_GB_UCAS_WELSHCHAR1CHAR1
TOWNCity KORTCHAR40TEXT40
COUNTYDescription BEZEI20CHAR20TEXT20
LEA_CODEUCAS: LEA code PIQ_GB_UCAS_LEANUMC3Assigned to domainPIQ_GB_UCAS_LEA
AEDTMUCAS: Date of the last change made by UCAS PIQ_GB_UCAS_AEDTMDATS8DATS
PREV_SCHOOL_IDUCAS: Previous School ID PIQ_GB_UCAS_PREV_SCHOOL_IDCHAR7Assigned to domainPIQ_GB_UCAS_SCHOOL
BASE_YEARUCAS: Base Year PIQ_GB_UCAS_BASE_YEARNUMC4PIQ_GB_UCAS_YEAR
NO_APPLICUCAS: Number of UCAS Applicants PIQ_GB_UCAS_NO_APPLICNUMC4NUM4
NO_ACCEPTUCAS: Number of UCAS Acceptances PIQ_GB_UCAS_NO_ACCEPTNUMC4NUM4
FORMSUCAS: Forms processed PIQ_GB_UCAS_FORMSCHAR1CHAR1
FAXFax Number FAXNRCHAR25CHAR25
EMAILUCAS: Email address PIQ_GB_UCAS_EMAILCHAR241
SCHOOL_CODEUCAS : School Code PIQ_GB_UCAS_SCHOOL_CODECHAR10CHAR10
CONTACT_POSTUCAS : Contact Post PIQ_GB_UCAS_CONTACT_POSTCHAR20CHAR20
ED_EXCEL_NOUCAS : Education Excel No PIQ_GB_UCAS_ED_EXCEL_NOCHAR10CHAR10
HIGHER_ED_COUNTUCAS : Higher Education Count PIQ_GB_UCAS_HIGHER_ED_COUNTNUMC10NUMC10
MAIL_SORT_CODEUCAS : Mail Sort Code PIQ_GB_UCAS_MAIL_SORT_CODECHAR10CHAR10
ESTABLISH_NOUCAS : Merged Establish Number PIQ_GB_UCAS_ESTABLISH_NONUMC10NUMC10
OLD_NAMEUCAS : Old Name PIQ_GB_UCAS_OLD_NAMECHAR50CHAR50
STATISTICS_DATEUCAS: Date of the last change made by UCAS PIQ_GB_UCAS_AEDTMDATS8DATS
STATISTICS_TIMEUCAS: Time of the last change made by UCAS PIQ_GB_UCAS_UZEITTIMS6UZEIT
SCHOOL_TYP_CODEUCAS: Referenec School Type Code PIQ_GB_UCAS_SCHOOL_TYP_CODECHAR1CHAR1
SCHOOL_TYP_DESCUCAS: Reference School Type PIQ_GB_UCAS_SCHOOL_TYP_DESCCHAR50CHAR50
SCHOOL_TYP_SUMMER_SCHL_FUCAS: Referenec School Type Summer school flag PIQ_GB_UCAS_SCHOOL_TYP_SCHL_FCHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP structure PIQ_GB_UCAS_REF_SCHOOL_DETAILS using ABAP code?

As PIQ_GB_UCAS_REF_SCHOOL_DETAILS 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 PIQ_GB_UCAS_REF_SCHOOL_DETAILS as there is no data to select.

How to access SAP table PIQ_GB_UCAS_REF_SCHOOL_DETAILS

Within an ECC or HANA version of SAP you can also view further information about PIQ_GB_UCAS_REF_SCHOOL_DETAILS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!