SAP T7PIQ_GB_SCHOOL table - UCAS: Schools details in SAP

SAP T7PIQ_GB_SCHOOL table summary

Object Name: T7PIQ_GB_SCHOOL
Dictionary Type: Transparent table
Description: UCAS: Schools

Field list for T7PIQ_GB_SCHOOL table on an S/4 SAP system

Details

T7PIQ_GB_SCHOOL-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

T7PIQ_GB_SCHOOL-SCHOOL_ID table field - UCAS: School Number ▼

Description: UCAS: School Number
Field Name: SCHOOL_ID
Data Element: PIQ_GB_UCAS_SCHOOL
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_SCHOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHOOL_ID

T7PIQ_GB_SCHOOL-NAME table field - -Cm UCAS: Field description ▼

Description: -Cm UCAS: Field description
Field Name: NAME
Data Element: PIQ_GB_UCAS_DESCRIPTION
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

T7PIQ_GB_SCHOOL-COUNTRY_CODE table field - UCAS: School country/region code ▼

Description: UCAS: School country/region code
Field Name: COUNTRY_CODE
Data Element: PIQ_GB_UCAS_COUNTRY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_COUNTRY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY_CODE

T7PIQ_GB_SCHOOL-EST_GRP table field - UCAS: Establishment group ▼

Description: UCAS: Establishment group
Field Name: EST_GRP
Data Element: PIQ_GB_UCAS_EST_GRP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EST_GRP

T7PIQ_GB_SCHOOL-STATUS table field - UCAS: School status ▼

Description: UCAS: School status
Field Name: STATUS
Data Element: PIQ_GB_UCAS_SCHOOL_STATUS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

T7PIQ_GB_SCHOOL-DFE_ID table field - UCAS: DFE number ▼

Description: UCAS: DFE number
Field Name: DFE_ID
Data Element: PIQ_GB_UCAS_DFE_ID
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DFE_ID

T7PIQ_GB_SCHOOL-NC_ID table field - UCAS: National Centre Number (NCN) ▼

Description: UCAS: National Centre Number (NCN)
Field Name: NC_ID
Data Element: PIQ_GB_UCAS_NC_ID
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CHAR5
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NC_ID

T7PIQ_GB_SCHOOL-BTEC_ID table field - UCAS: BTEC National Centre Number ▼

Description: UCAS: BTEC National Centre Number
Field Name: BTEC_ID
Data Element: PIQ_GB_UCAS_BTEC_ID
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: CHAR6
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BTEC_ID

T7PIQ_GB_SCHOOL-HEAD_NAME table field - UCAS: Headmaster/Principal Name ▼

Description: UCAS: Headmaster/Principal Name
Field Name: HEAD_NAME
Data Element: PIQ_GB_UCAS_HEAD_NAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEAD_NAME

T7PIQ_GB_SCHOOL-HEAD_TITLE table field - UCAS: Headmaster/Principal Title ▼

Description: UCAS: Headmaster/Principal Title
Field Name: HEAD_TITLE
Data Element: PIQ_GB_UCAS_HEAD_TITLE
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HEAD_TITLE

T7PIQ_GB_SCHOOL-CONT_TITLE table field - UCAS: Usual Contact Title ▼

Description: UCAS: Usual Contact Title
Field Name: CONT_TITLE
Data Element: PIQ_GB_UCAS_CONT_TITLE
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONT_TITLE

T7PIQ_GB_SCHOOL-CONT_NAME table field - UCAS: Usual Contact Name ▼

Description: UCAS: Usual Contact Name
Field Name: CONT_NAME
Data Element: PIQ_GB_UCAS_CONT_NAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONT_NAME

T7PIQ_GB_SCHOOL-ADDRESS_1 table field - UCAS: Address line ▼

Description: UCAS: Address line
Field Name: ADDRESS_1
Data Element: PIQ_GB_UCAS_ADDRESS
Data Type: CHAR
length (Dec): 27(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_ADDRESS_LINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_1

T7PIQ_GB_SCHOOL-ADDRESS_2 table field - UCAS: Address line ▼

Description: UCAS: Address line
Field Name: ADDRESS_2
Data Element: PIQ_GB_UCAS_ADDRESS
Data Type: CHAR
length (Dec): 27(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_ADDRESS_LINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_2

T7PIQ_GB_SCHOOL-ADDRESS_3 table field - UCAS: Address line ▼

Description: UCAS: Address line
Field Name: ADDRESS_3
Data Element: PIQ_GB_UCAS_ADDRESS
Data Type: CHAR
length (Dec): 27(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_ADDRESS_LINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_3

T7PIQ_GB_SCHOOL-ADDRESS_4 table field - UCAS: Address line ▼

Description: UCAS: Address line
Field Name: ADDRESS_4
Data Element: PIQ_GB_UCAS_ADDRESS
Data Type: CHAR
length (Dec): 27(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_ADDRESS_LINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_4

T7PIQ_GB_SCHOOL-POSTCODE table field - Postal Code ▼

Description: Postal Code
Field Name: POSTCODE
Data Element: PD_PSTLZ
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTCODE

T7PIQ_GB_SCHOOL-TELNR table field - Telephone Number ▼

Description: Telephone Number
Field Name: TELNR
Data Element: TELENR
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELNR

T7PIQ_GB_SCHOOL-SCHOOL_TYPE table field - UCAS: School type ▼

Description: UCAS: School type
Field Name: SCHOOL_TYPE
Data Element: PIQ_GB_UCAS_SCHOOL_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table: T7PIQ_GB_SCHTYP
Conversion Routine:
Domain Name: PIQ_GB_UCAS_SCHOOL_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHOOL_TYPE

T7PIQ_GB_SCHOOL-DAY_BOARD table field - UCAS: School Day Board ▼

Description: UCAS: School Day Board
Field Name: DAY_BOARD
Data Element: PIQ_GB_UCAS_DAY_BOARD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DAY_BOARD

T7PIQ_GB_SCHOOL-SEX table field - UCAS: School Sexes ▼

Description: UCAS: School Sexes
Field Name: SEX
Data Element: PIQ_GB_UCAS_SEX
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEX

T7PIQ_GB_SCHOOL-DTM_COLL table field - UCAS: Date annual data collected ▼

Description: UCAS: Date annual data collected
Field Name: DTM_COLL
Data Element: PIQ_GB_UCAS_DTM_COLL
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DTM_COLL

T7PIQ_GB_SCHOOL-ROLL_NR table field - UCAS: Number on Roll ▼

Description: UCAS: Number on Roll
Field Name: ROLL_NR
Data Element: PIQ_GB_UCAS_ROLL_NR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROLL_NR

T7PIQ_GB_SCHOOL-FULL_TIME table field - UCAS: Full Time ▼

Description: UCAS: Full Time
Field Name: FULL_TIME
Data Element: PIQ_GB_UCAS_FULL_TIME
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULL_TIME

T7PIQ_GB_SCHOOL-FIFTH_FORM table field - UCAS: Fifth Form ▼

Description: UCAS: Fifth Form
Field Name: FIFTH_FORM
Data Element: PIQ_GB_UCAS_FIFTH_FORM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIFTH_FORM

T7PIQ_GB_SCHOOL-SIXTH_FORM table field - UCAS: Sixth Form ▼

Description: UCAS: Sixth Form
Field Name: SIXTH_FORM
Data Element: PIQ_GB_UCAS_SIXTH_FORM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIXTH_FORM

T7PIQ_GB_SCHOOL-HI_EDUCAT table field - UCAS: Higher Education ▼

Description: UCAS: Higher Education
Field Name: HI_EDUCAT
Data Element: PIQ_GB_UCAS_HI_EDUCAT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HI_EDUCAT

T7PIQ_GB_SCHOOL-WELSH table field - UCAS: Welshs Schools Main Language ▼

Description: UCAS: Welshs Schools Main Language
Field Name: WELSH
Data Element: PIQ_GB_UCAS_WELSH
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WELSH

T7PIQ_GB_SCHOOL-TOWN table field - City ▼

Description: City
Field Name: TOWN
Data Element: KORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOWN

T7PIQ_GB_SCHOOL-COUNTY table field - Description ▼

Description: Description
Field Name: COUNTY
Data Element: BEZEI20
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTY

T7PIQ_GB_SCHOOL-LEA_CODE table field - UCAS: LEA code ▼

Description: UCAS: LEA code
Field Name: LEA_CODE
Data Element: PIQ_GB_UCAS_LEA
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_LEA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEA_CODE

T7PIQ_GB_SCHOOL-AEDTM table field - UCAS: Date of the last change made by UCAS ▼

Description: UCAS: Date of the last change made by UCAS
Field Name: AEDTM
Data Element: PIQ_GB_UCAS_AEDTM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AEDTM

T7PIQ_GB_SCHOOL-PREV_SCHOOL_ID table field - UCAS: Previous School ID ▼

Description: UCAS: Previous School ID
Field Name: PREV_SCHOOL_ID
Data Element: PIQ_GB_UCAS_PREV_SCHOOL_ID
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_SCHOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREV_SCHOOL_ID

T7PIQ_GB_SCHOOL-BASE_YEAR table field - UCAS: Base Year ▼

Description: UCAS: Base Year
Field Name: BASE_YEAR
Data Element: PIQ_GB_UCAS_BASE_YEAR
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_YEAR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BASE_YEAR

T7PIQ_GB_SCHOOL-NO_APPLIC table field - UCAS: Number of UCAS Applicants ▼

Description: UCAS: Number of UCAS Applicants
Field Name: NO_APPLIC
Data Element: PIQ_GB_UCAS_NO_APPLIC
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: NUM4
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NO_APPLIC

T7PIQ_GB_SCHOOL-NO_ACCEPT table field - UCAS: Number of UCAS Acceptances ▼

Description: UCAS: Number of UCAS Acceptances
Field Name: NO_ACCEPT
Data Element: PIQ_GB_UCAS_NO_ACCEPT
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: NUM4
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NO_ACCEPT

T7PIQ_GB_SCHOOL-FORMS table field - UCAS: Forms processed ▼

Description: UCAS: Forms processed
Field Name: FORMS
Data Element: PIQ_GB_UCAS_FORMS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORMS

T7PIQ_GB_SCHOOL-FAX table field - Fax Number ▼

Description: Fax Number
Field Name: FAX
Data Element: FAXNR
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX

T7PIQ_GB_SCHOOL-EMAIL table field - UCAS: Email address ▼

Description: UCAS: Email address
Field Name: EMAIL
Data Element: PIQ_GB_UCAS_EMAIL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMAIL

T7PIQ_GB_SCHOOL-UKPRN_NUM table field - CM UCAS : External Reference Number Assigned by UKRLP ▼

Description: CM UCAS : External Reference Number Assigned by UKRLP
Field Name: UKPRN_NUM
Data Element: PIQ_GB_UCAS_UKPRN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: PIQ_GB_UCAS_UKPRN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UKPRN_NUM

View list of all SAP tables(S4H/ECC)

Select data from SAP table