SAP ABAP Table T7PIQ_GB_COUNTYM (GB: Mapping table SAP country & county codes to UCAS/HESA)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-GB (Application Component) United Kingdom
⤷ PMIQ_GB (Package) Campus Management (Great Britain)
⤷ IS-HER-CM-GB (Application Component) United Kingdom
⤷ PMIQ_GB (Package) Campus Management (Great Britain)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | T7PIQ_GB_COUNTYM | Table Relationship Diagram |
Short Description | GB: Mapping table SAP country & county codes to UCAS/HESA |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | COUNTY | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
4 | COUNTYC | COUNC | COUNC | CHAR | 3 | 0 | County Code | T005E | |
5 | UCAS_COUNTY | PIQ_GB_UCAS_COUNTY | NUMC3 | NUMC | 3 | 0 | UCAS: County / Country code | ||
6 | HESA_COUNTY | PIG_GB_HESA_COUNTY | NUMC4 | NUMC | 4 | 0 | HESA: Country/County code | ||
7 | UCAS_DESC | CHAR | 40 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | T7PIQ_GB_COUNTYM | COUNTRY | T005 | LAND1 | 1 | CN | |
2 | T7PIQ_GB_COUNTYM | COUNTY | T005S | BLAND | KEY | 1 | CN |
3 | T7PIQ_GB_COUNTYM | COUNTYC | T005E | COUNC | KEY | 1 | CN |
4 | T7PIQ_GB_COUNTYM | MANDT | T000 | MANDT | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |