SAP Table T7PIQ_GB_INST_HE

HESA: Institution Codes

T7PIQ_GB_INST_HE (HESA: Institution Codes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T7PIQ_GB_INST_HE to other SAP tables.

T7PIQ_GB_INST_HE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
INSTID HESA: HE institution last attended PIQ_GB_HESA_INSTHE NUMC 4 0
INSTTEXT HESA: Text for Institution ID PIQ_GB_HESA_INSTTEXT CHAR 60 0
INSTSTXT Institution short name PIQ_GB_HESA_INSTSTXT CHAR 30 0
INSTCAT HESA: HE Institution type PIQ_GB_HESA_INSTCAT CHAR 1 0
NULL HE Institution
1 No HE institution but awarding body
2 No HE institution but other inst. providing teaching
3 No HE Inst. but award. body and other inst. prov. teaching

T7PIQ_GB_INST_HE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T7PIQ_GB_INST_HE MANDT T7PIQ_GB_INST_HE MANDT T000 Clients MANDT