T7PIQ_GB_SCHOOL is a SAP table coming under IS module and IS-PS-CA component.View details, Fields & related tables of T7PIQ_GB_SCHOOL in SAP.
- Table description : UCAS: Schools
- Module : IS-HER-CM-GB
- Parent Module : IS
- Package : PMIQ_GB
- Software Component : IS-PS-CA
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP T7PIQ_GB_SCHOOL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SCHOOL_ID | UCAS: School Number | PIQ_GB_UCAS_SCHOOL | PIQ_GB_UCAS_SCHOOL |
| NAME | -Cm UCAS: Field description | PIQ_GB_UCAS_DESCRIPTION | TEXT50 |
| COUNTRY_CODE | UCAS: School country code | PIQ_GB_UCAS_COUNTRY | PIQ_GB_UCAS_COUNTRY |
| EST_GRP | UCAS: Establishment group | PIQ_GB_UCAS_EST_GRP | CHAR1 |
| STATUS | UCAS: School status | PIQ_GB_UCAS_SCHOOL_STATUS | CHAR1 |
| DFE_ID | UCAS: DFE number | PIQ_GB_UCAS_DFE_ID | CHAR7 |
| NC_ID | UCAS: National Centre Number (NCN) | PIQ_GB_UCAS_NC_ID | CHAR5 |
| BTEC_ID | UCAS: BTEC National Centre Number | PIQ_GB_UCAS_BTEC_ID | CHAR6 |
| HEAD_NAME | UCAS: Headmaster/Principal Name | PIQ_GB_UCAS_HEAD_NAME | PIQ_GB_UCAS_NAME |
| HEAD_TITLE | UCAS: Headmaster/Principal Title | PIQ_GB_UCAS_HEAD_TITLE | PIQ_GB_UCAS_NAME |
| CONT_TITLE | UCAS: Usual Contact Title | PIQ_GB_UCAS_CONT_TITLE | PIQ_GB_UCAS_NAME |
| CONT_NAME | UCAS: Usual Contact Name | PIQ_GB_UCAS_CONT_NAME | PIQ_GB_UCAS_NAME |
| ADDRESS_1 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS | PIQ_GB_UCAS_ADDRESS_LINE |
| ADDRESS_2 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS | PIQ_GB_UCAS_ADDRESS_LINE |
| ADDRESS_3 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS | PIQ_GB_UCAS_ADDRESS_LINE |
| ADDRESS_4 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS | PIQ_GB_UCAS_ADDRESS_LINE |
| POSTCODE | Postal Code | PD_PSTLZ | PSTLZ |
| TELNR | Telephone Number | TELENR | CHAR25 |
| SCHOOL_TYPE | UCAS: School type | PIQ_GB_UCAS_SCHOOL_TYPE | PIQ_GB_UCAS_SCHOOL_TYPE |
| DAY_BOARD | UCAS: School Day Board | PIQ_GB_UCAS_DAY_BOARD | CHAR1 |
| SEX | UCAS: School Sexes | PIQ_GB_UCAS_SEX | CHAR1 |
| DTM_COLL | UCAS: Date annual data collected | PIQ_GB_UCAS_DTM_COLL | DATE |
| ROLL_NR | UCAS: Number on Roll | PIQ_GB_UCAS_ROLL_NR | CHAR1 |
| FULL_TIME | UCAS: Full Time | PIQ_GB_UCAS_FULL_TIME | CHAR1 |
| FIFTH_FORM | UCAS: Fifth Form | PIQ_GB_UCAS_FIFTH_FORM | CHAR1 |
| SIXTH_FORM | UCAS: Sixth Form | PIQ_GB_UCAS_SIXTH_FORM | CHAR1 |
| HI_EDUCAT | UCAS: Higher Education | PIQ_GB_UCAS_HI_EDUCAT | CHAR1 |
| WELSH | UCAS: Welshs Schools Main Language | PIQ_GB_UCAS_WELSH | CHAR1 |
| TOWN | City | KORT | TEXT40 |
| COUNTY | Description | BEZEI20 | TEXT20 |
| LEA_CODE | UCAS: LEA code | PIQ_GB_UCAS_LEA | PIQ_GB_UCAS_LEA |
| AEDTM | UCAS: Date of the last change made by UCAS | PIQ_GB_UCAS_AEDTM | DATS |
| PREV_SCHOOL_ID | UCAS: Previous School ID | PIQ_GB_UCAS_PREV_SCHOOL_ID | PIQ_GB_UCAS_SCHOOL |
| BASE_YEAR | UCAS: Base Year | PIQ_GB_UCAS_BASE_YEAR | PIQ_GB_UCAS_YEAR |
| NO_APPLIC | UCAS: Number of UCAS Applicants | PIQ_GB_UCAS_NO_APPLIC | NUM4 |
| NO_ACCEPT | UCAS: Number of UCAS Acceptances | PIQ_GB_UCAS_NO_ACCEPT | NUM4 |
| FORMS | UCAS: Forms processed | PIQ_GB_UCAS_FORMS | CHAR1 |
| FAX | Fax Number | FAXNR | CHAR25 |
| UCAS: Email address | PIQ_GB_UCAS_EMAIL |
T7PIQ_GB_SCHOOL related tables
| Table | Note |
|---|---|
| T7PIQ_GB_SCHOOL | UCAS: Schools |
| T7PIQ_GB_SCHOOLM | UCAS: Schools Mapping table Marvin -> SAP |
| T7BRES | Schools |
| T7UNPAD_EGSN | NPO: Education Grant Schools / Colleges |
| T7PIQ_GB_CAMPUSM | UCAS: Mapping table UCAS Campus -> SAP Campus |
| T7PIQ_GB_CHALLM | UCAS: Mapping table disabilites UCAS->SAP |
| T7PIQ_GB_ENT_PN | UCAS: Mapping UCAS point of entry -> SAP program stage |
| T7PIQ_GB_OFFSUB | UCAS: UCAS Offer subject codes |
| T7PIQ_GB_OFFSUBT | UCAS : Text Table for UCAS Subject Codes |
| T7PIQ_GB_TITLE | UCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre |
| T7PIQ_GB_UCASAC | UCAS: UCAS ACTION |
| T7PIQ_GB_UCASACT | UCAS: UCAS ACTION text table |
| PIQDB_GB_CONTEXT | UCAS: Contextual Data |
| PIQDB_GB_MODDATA | UCAS: Applicant Module Details |
| PIQDB_GB_NEEDS | UCAS: Application Specific Special needs |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP