SAP United Kingdom Tables

Are you looking for the right table related to SAP United Kingdom Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in United Kingdom (IS-HER-CM-GB) module.

Top 10 tables in United Kingdom

TableDescription
T7PIQ_GB_PGCECLTHESA: PGCE - Classification of UG Degree Text Table
T7PIQ_GB_IDTYPESUCAS : Identification Types
T7PIQ_GB_CON_DMUCAS: Mapping table Marvin Course Id -> Default Conditions
T7PIQ_GB_CON_DUCAS: Default Conditions
PIQDB_GB_NEEDSUCAS: Application Specific Special needs
HRT1783Table Part Infotype 1783
T7PIQ_GB_BANDTrevised do not use ! School Results Special Paper Grade
T7PIQ_GB_AMENDMUCAS: Amendment
T7PIQ_GB_BORDRESUCAS: Mapping Exam Board Code -> Exam qualification
PIQDB_GB_MODDATAUCAS: Applicant Module Details

List of tables in United Kingdom

TableDescription
T7PIQ_GB_PGCECLTHESA: PGCE - Classification of UG Degree Text Table
T7PIQ_GB_IDTYPESUCAS : Identification Types
T7PIQ_GB_CON_DMUCAS: Mapping table Marvin Course Id -> Default Conditions
T7PIQ_GB_CON_DUCAS: Default Conditions
PIQDB_GB_NEEDSUCAS: Application Specific Special needs
HRT1783Table Part Infotype 1783
T7PIQ_GB_BANDTrevised do not use ! School Results Special Paper Grade
T7PIQ_GB_AMENDMUCAS: Amendment
T7PIQ_GB_BORDRESUCAS: Mapping Exam Board Code -> Exam qualification
PIQDB_GB_MODDATAUCAS: Applicant Module Details
T7PIQ_GB_CON_DEFUCAS: Default Conditions
T7PIQ_GB_CON_HIUCAS: Confirmation History
HRP1795DB Table for Infotype 1795
HRP1783DB Table for Infotype 1783
T7PIQ_GB_CHALLMUCAS: Mapping table disabilites UCAS->SAP
T7PIQ_GB_FEINSTHESA: Further Education Institutions
T7PIQ_GB_BANDreviesed do not use ! School Results Special Paper Grade
T7PIQ_GB_CONDUCAS: Conditions
HRT1786Table Part Infotype 1786
HRP1782DB Table for Infotype 1782
T7PIQ_GB_ABBRTUCAS: Abbreviation Text Table
T7PIQ_GB_COURSEUCAS: Program of Study
T7PIQ_GB_AMND_DTUCAS : Amended dates for web service
HRT1796Table Part Infotype 1796
T7PIQ_GB_MAP_ADDUCAS : Map Address details to Comm / Address Independent
T7PIQ_GB_HQUALUCAS: Highest Qualification on Entry
T7PIQ_GB_INST_ORUCAS: Organization of Universities
T7PIQ_GB_POINTSUCAS: Points Score for Entry to Higher Education
T7PIQ_GB_TTCIDTHESA: Teacher Training Course Identifiers
T7PIQ_GB_REPLYUCAS: Reply Student
T7PIQ_GB_NHSEMPHESA: NHS Employer
T7PIQ_GB_RESTYPTUCAS: School Results quality text table
T7PIQ_GB_QLEVELUCAS: Qualification Level for GNVQs (revised do not use)
T7PIQ_GB_REF_ERRUCAS: Error Codes
T7PIQ_GB_RCATTUCAS: Residential category text table (Revised do not use)
T7PIQ_GB_TTACOTHESA: Term Time Accomodation
PIQDB_GB_CONTEXTUCAS: Contextual Data
HRP1785DB Table for Infotype 1785
HRP1786DB Table for Infotype 1786
T7PIQ_GB_SUBJ2UCAS: MARVIN subject codes
T7PIQ_GB_INT_PRIUCAS: Interview Priority
T7PIQ_GB_REPLYTUCAS: Reply Student text table
T7PIQ_GB_FEESTUCAS: Fee payer code text table
T7PIQ_GB_EXLVLCTUCAS:Exam Level Code Text Table
T7PIQ_GB_SCHOOLUCAS: Schools
HRP1934DB Table for Infotype 1934
T7PIQ_GB_SBJTHESA: JACS Subject Codes text table
HRP1796DB Table for Infotype 1796
T7PIQ_GB_TRANSUCAS: Transactions
T7PIQ_GB_DECISUCAS: Decision institution
T7PIQ_GB_OCCUPMUCAS: Mapping table occupational group
T7PIQ_GB_SCECCLTUCAS: Socioeconomic Class text table
T7PIQ_GB_ABLSUBUCAS: Mapping EBL Subject Code ->SAP Subject Code
T7PIQ_GB_CAMPUSMUCAS: Mapping table UCAS Campus -> SAP Campus
HRT1934Table Part Infotype 1934
T7PIQ_GB_TTCACOHESA: Term Time Accomodation
T7PIQ_GB_NHSEMPTHESA: NHS Employer text table
T7PIQ_GB_LEAUCAS: LEA code
T7PIQ_GB_PGCECLHESA: PGCE - Classification of UG Degree
T7PIQ_GB_APP_IMPUCAS : Applicant Import data
HRT1785Table Part Infotype 1785
T7PIQ_GB_MATCHTUCAS: Match indicator text table
T7PIQ_GB_SPSTUTHESA: Special Students text table
PIQDB_GB_SEQ_EXUCAS: Student extract information from sequence files
T7PIQ_GB_SCHOOLMUCAS: Schools Mapping table Marvin -> SAP
T7PIQ_GB_SCHTYPTUCAS: Text Table for School Type
T7PIQ_GB_SPSTUHESA: Special Students
T7PIQ_GB_OFFRLETUCAS: Student Offer Level Text
T7PIQ_GB_FEINSHESA: Further Education Institutions
T7PIQ_GB_OCC_SOCUCAS : Social Class for the Parental OCC
T7PIQ_GB_POTELEVUCAS: Student Offer Level
T7PIQ_GB_SWITCHUCAS : Switch table to activate ucaslink
T7PIQ_GB_CRS_INSUCAS: Offered Prog. of Study per institution
T7PIQ_GB_UCASACTUCAS: UCAS ACTION text table
T7PIQ_GB_CON_HITUCAS: Confirmation History text table
T7PIQ_GB_ETHNICMUCAS: Mapping table ethnic origin
T7PIQ_GB_UCASACUCAS: UCAS ACTION
T7PIQ_GB_HSCTUCAS: School results HSC/HongKong/GNVQ text table
T7PIQ_GB_QEQTUCAS: Other qualifications text table
T7PIQ_GB_ABBRUCAS: Abbreviations
T7PIQ_GB_REF_ERTUCAS: Error Codes and descriptions
T7PIQ_GB_OFFRLEVUCAS: Student Offer Level
T7PIQ_GB_APPL_WSUCAS: Import data last updated for each applicant
T7PIQ_GB_INT_PRTUCAS: Interview priority text table
T7PIQ_GB_OFFSUBUCAS: UCAS Offer subject codes
T7PIQ_GB_HQUALTUCAS: Highest Qualification on Entry text table
T7PIQ_GB_QEQUCAS: Other qualifications Flag
T7PIQ_GB_SUBTYPEMaintain note subtype to be copied on course change
T7PIQ_GB_EBOARDTUCAS: School results Exam Boards text table
T7PIQ_GB_ENT_PNTUCAS: Point of Entry text table
T7PIQ_GB_SUBSTIUCAS: Substitution
T7PIQ_GB_DECISTUCAS: Decision institution text table
T7PIQ_GB_MATCHUCAS: Match indicator
T7PIQ_GB_AMENDMTUCAS: Amendment text table
T7PIQ_GB_STATUSTUCAS: Confirmation Status text table
T7PIQ_GB_SOCIALMUCAS: Mapping table social class
T7PIQ_GB_SUBSTITUCAS: Substitution text table
T7PIQ_GB_SUBJTUCAS: EBL Subect Codes text table
T7PIQ_GB_ABLSUBTUCAS : ABL subject code text
T7PIQ_GB_CHALLMTUCAS : Diability Description
T7PIQ_GB_POCC_TUCAS:Text Table for Social Class for the Parental Occupation
T7PIQ_GB_FEEELTUCAS: Fee eligibility text table
HRP1933DB Table for Infotype 1933
T7PIQ_GB_TITLEUCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre
T7PIQ_GB_HSCUCAS: Exam Qualifcations HSC/IBAC
T7PIQ_GB_COURSEMUCAS: Mapping table Marvin Course Id -> SAP Prog. of Study
T7PIQ_GB_COURSETUCAS: Program of Study text table
T7PIQ_GB_UCAS_WSUCAS : Ucaslink Web service Master Data
T7PIQ_GB_EXLVLCDUCAS :Exam Level Code
T7PIQ_GB_RESTYPUCAS: EBL School Results qualifications
T7PIQ_GB_WS_USERUCAS : Web Service user credentials
T7PIQ_GB_POTELETUCAS: Potential Offer Level Description
T7PIQ_GB_POCCUCAS : Social Class for Parental Occupation
T7PIQ_GB_INSTUCAS: Institution Codes
T7PIQ_GB_CON_DTUcas: Default Conditions text table
T7PIQ_GB_DECTRAUCAS: Decisions per transaction
T7PIQ_GB_RCATUCAS: Residential category (Revised do not use)
T7PIQ_GB_INSTTUCAS: Institutions text table
T7PIQ_GB_SCHTYPUCAS: School Type
T7PIQ_GB_EBOARDUCAS: EBL School Results Exam Boards
T7PIQ_GB_OFFSUBTUCAS : Text Table for UCAS Subject Codes
T7PIQ_GB_COUNTYMGB: Mapping table SAP country & county codes to UCAS/HESA
T7PIQ_GB_SBJHESA: JACS Subject Codes
T7PIQ_GB_INST_HEHESA: Institution Codes
T7PIQ_GB_FEEELUCAS: Fee eligibility
T7PIQ_GB_SUBJUCAS: Mapping EBL Subject Code ->SAP Subject Code
T7PIQ_GB_ENT_PNUCAS: Mapping UCAS point of entry -> SAP program stage
T7PIQ_GB_STATUSUCAS: Confirmation Status
T7PIQ_GB_FEESUCAS: Fee payer code
T7PIQ_GB_SCECCLUCAS: Socioeconomic Class
T7PIQ_GB_TTCIDHESA: Teacher Training Course Identifier
T7PIQ_GB_TRANSTUCAS: Transactions text table
T7PIQ_GB_SUBJ2TUCAS: Texttable for Subjects w/o EBL Code
T7PIQ_GB_UFILEINUCAS: Records UFileIn